This quiz works best with JavaScript enabled. Home > Cbse > Class 11 > Science > Computer Science > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 27 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 27 (60 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What term is used to describe the process of organizing data into tables to minimize redundancy and dependency? A) Abstraction. B) Denormalization. C) Normalization. D) Concatenation. Show Answer Correct Answer: C) Normalization. 2. What is the file extension for databases created in MS Access 2007? A) .xlsx. B) .mdb. C) .docx. D) .accdb. Show Answer Correct Answer: D) .accdb. 3. Which data type can store date and time values with precision up to milliseconds and microseconds? A) Date/Time Extended. B) AutoNumber. C) Currency. D) Date/Time. Show Answer Correct Answer: A) Date/Time Extended. 4. Why is it incorrect to have two identical records when a key field is used? A) It increases file size. B) It violates the rule of uniqueness. C) It can cause printing errors. D) It helps in sorting data. Show Answer Correct Answer: B) It violates the rule of uniqueness. 5. If you were to organize a large collection of documents, which database component would be most similar to the file folders that group related documents together? A) Database. B) Records. C) Tables. D) Fields. Show Answer Correct Answer: B) Records. 6. Flat-file Structure A) A type of database that uses hierarchical data models. B) A complex database structure with multiple tables. C) A database structure that stores data in a cloud environment. D) A database structure that stores data in a single table or file. Show Answer Correct Answer: D) A database structure that stores data in a single table or file. 7. Which of the following is an example of a secondary key in a database? A) A student's last name. B) A customer's name. C) A product's name. D) An order's date. Show Answer Correct Answer: A) A student's last name. 8. Which data structure holds all information relevant to a specific entity in a database? A) Form. B) Record. C) Field. D) Table. Show Answer Correct Answer: B) Record. 9. What is an entity in a database context? A) An entity is a programming language used in databases. B) An entity is a type of database query. C) An entity is a collection of database records. D) An entity is a real-world object or concept in a database. Show Answer Correct Answer: D) An entity is a real-world object or concept in a database. 10. How do databases improve healthcare? A) By performing surgeries. B) By diagnosing diseases. C) By allowing quick access to patient information. D) By cleaning hospital rooms. Show Answer Correct Answer: C) By allowing quick access to patient information. 11. Which structure is best suited for real-time GPS navigation systems using unstructured data? A) Relational. B) Hierarchical. C) Flat file. D) NoSQL. Show Answer Correct Answer: D) NoSQL. 12. What is the purpose of indexing in a database? A) To encrypt database contents. B) To delete duplicate records. C) To speed up data retrieval. D) To normalize tables. Show Answer Correct Answer: C) To speed up data retrieval. 13. A row is a collection of data under different column headings, also called as A) Relation. B) Tuple. C) Record. D) Both record and tuple. Show Answer Correct Answer: D) Both record and tuple. 14. In a database context, what is a table most similar to? A) A spreadsheet. B) A photo album. C) A video. D) A book. Show Answer Correct Answer: A) A spreadsheet. 15. What type of end users maintain personal databases using ready-made software packages? A) Casual End Users. B) Sophisticated End Users. C) Naive End Users. D) Stand-alone Users. Show Answer Correct Answer: D) Stand-alone Users. 16. In MS Access, which view allows you to modify the structure and layout of a form? A) Print View. B) Query View. C) Datasheet View. D) Design View. Show Answer Correct Answer: D) Design View. 17. Which query type can prompt for criteria each time it is run? A) Delete Queries. B) Appended Queries. C) Parameter Queries. D) Make Table Queries. Show Answer Correct Answer: C) Parameter Queries. 18. Evolution of data models aims to improve ..... A) File size. B) Hardware cost. C) Data redundancy. D) Data independence. Show Answer Correct Answer: D) Data independence. 19. Dalam diagram use case, include digunakan untuk: A) Menunjukkan bahwa sebuah use case selalu memanggil use case lain. B) Menunjukkan hubungan antara aktor. C) Menunjukkan opsi tambahan. D) Menunjukkan entitas yang terlibat dalam use case. E) Menjelaskan proses utama. Show Answer Correct Answer: A) Menunjukkan bahwa sebuah use case selalu memanggil use case lain. 20. Which of these best describes a schema? A) A domain of names. B) A specific data entry in a column. C) The current data inside a table. D) The design of a table like (ID INT, Name VARCHAR(50)). Show Answer Correct Answer: D) The design of a table like (ID INT, Name VARCHAR(50)). 21. Course(course ..... id, sec ..... id, semester)Here the course ..... id, sec ..... id and semester are ..... and course is a ..... A) Tuple, Relation. B) Attributes, Relation. C) Relations, Attribute. D) Tuple, Relation. Show Answer Correct Answer: B) Attributes, Relation. 22. What is the purpose of metadata in a database? A) To process queries. B) To define data structures. C) To store user data. D) To replicate data. Show Answer Correct Answer: B) To define data structures. 23. What is the primary disadvantage of a flat file database? A) It can lead to data redundancy. B) It is not user-friendly. C) It requires multiple tables. D) It is too complex to implement. Show Answer Correct Answer: A) It can lead to data redundancy. 24. How can you export a report from Access to another format? A) Use the 'File' menu to print the report directly. B) Right-click the report and choose 'Delete' to remove it. C) Select 'Save As' to create a copy of the report. D) Use the 'External Data' tab to export the report to a different format. Show Answer Correct Answer: D) Use the 'External Data' tab to export the report to a different format. 25. What is normalization and why is it important? A) Normalization is a process that only affects data storage, not performance. B) Normalization is important because it minimizes data redundancy, ensures data integrity, and enhances query performance. C) Normalization is only necessary for small databases. D) Normalization increases data redundancy and slows down queries. Show Answer Correct Answer: B) Normalization is important because it minimizes data redundancy, ensures data integrity, and enhances query performance. 26. How can you filter data in a report in Access? A) You can filter data by exporting the report to Excel. B) Filtering is only possible in the query view, not in reports. C) You can only filter data by using SQL commands in Access. D) You can filter data in a report in Access by using the Filter By Form feature or applying filters in the report view. Show Answer Correct Answer: D) You can filter data in a report in Access by using the Filter By Form feature or applying filters in the report view. 27. What are the different types of Access Objects? A) Tables, Forms, Scripts, Views. B) Tables, Queries, Forms, Reports, Macros, Modules. C) Queries, Forms, Dashboards, Reports. D) Tables, Charts, Forms, Reports. Show Answer Correct Answer: B) Tables, Queries, Forms, Reports, Macros, Modules. 28. Explain the purpose of the 'GROUP BY' clause in SQL and provide an example. A) The 'GROUP BY' clause in SQL is used to sort the data in ascending order. B) The 'GROUP BY' clause in SQL is used to filter the data based on a condition. C) The 'GROUP BY' clause in SQL is used to update the data in a table. D) The purpose of the 'GROUP BY' clause in SQL is to group rows that have the same values and it is often used with aggregate functions. Show Answer Correct Answer: D) The purpose of the 'GROUP BY' clause in SQL is to group rows that have the same values and it is often used with aggregate functions. 29. Which type of database is best for handling large amounts of structured data? A) Relational database. B) Hierarchical database. C) Flat-file database. D) Network database. Show Answer Correct Answer: A) Relational database. 30. True or False:StudentName in the Students table is a domain. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 31. The ..... operation is used for selecting a subset with tuples according to a given condition. A) UNION. B) SELECT. C) INTERSECTION. D) DIFFERENCE. Show Answer Correct Answer: B) SELECT. 32. What is the function of the following command?Delete from r where P; A) Clears entries from relation. B) Deletes relation. C) Deletes particular tuple from relation. D) All of the mentioned. Show Answer Correct Answer: C) Deletes particular tuple from relation. 33. Which section of a PL/SQL anonymous block is *mandatory*? A) DECLARE. B) EXCEPTION. C) BEGIN (Executable Section). D) None are mandatory. Show Answer Correct Answer: C) BEGIN (Executable Section). 34. A DBMS performs several important functions that guarantee the integrity and consistency of the data in the database. Which of the following is NOT one of those functions? A) Data integrity management. B) Security management. C) Data storage management. D) Data reports. Show Answer Correct Answer: D) Data reports. 35. What does the term "key field" refer to in a database? A) A field that uniquely identifies a record within a table. B) Any field that is mandatory for data entry. C) The field with the most data in a database. D) A field that is hidden from the user for security reasonsTagsDOK Level 2:Skill/Concept. Show Answer Correct Answer: A) A field that uniquely identifies a record within a table. 36. The purpose of a database is to: A) Store and manage data efficiently. B) Replace spreadsheets. C) Store only text-based information. D) Eliminate the need for computers. Show Answer Correct Answer: A) Store and manage data efficiently. 37. Which of these would be the best choice for creating a music database in Excel? A) Artist's favorite food. B) Album title, release date, chart position, albums sold. C) Student name and ID. D) Teacher and their classes. Show Answer Correct Answer: B) Album title, release date, chart position, albums sold. 38. The statement in SQL which allows to change the definition of a table is A) Alter. B) Update. C) Create. D) Select. Show Answer Correct Answer: A) Alter. 39. What is a Composite Key in database management? A) A primary key for a table consisting of two or more fields. B) A unique key that is used to speed up queries. C) A primary key that is derived from a unique key. D) A foreign key that combines multiple tables. Show Answer Correct Answer: A) A primary key for a table consisting of two or more fields. 40. What is the default sort order of the ORDER BY clause? A) Ascending. B) Descending. C) Random. D) None. Show Answer Correct Answer: A) Ascending. 41. Which transaction property ensures database correctness? A) Atomicity. B) Consistency. C) Isolation. D) Durability. Show Answer Correct Answer: B) Consistency. 42. Which of the following is NOT a disadvantage of using a DBMS? A) Complexity. B) Cost. C) Performance. D) Data integrity. Show Answer Correct Answer: D) Data integrity. 43. Dr.E.F. Codd represented ..... rules that a database must obey if it has to be considered truly relational. A) 12. B) 14. C) 10. D) 15. Show Answer Correct Answer: B) 14. 44. A table contains: A) Only text data. B) Only numerical data. C) Rows and columns. D) Only primary keys. Show Answer Correct Answer: C) Rows and columns. 45. What happens when a relationship is enforced with referential integrity? A) Data in related tables remains consistent. B) Records are automatically deleted. C) The database sorts data automatically. D) The tables become locked. Show Answer Correct Answer: A) Data in related tables remains consistent. 46. Aaronique, Andre and Jahmar are organizing a student database. They have attributes ID, CITY, and NAME. Which one of these can be considered as a primary key? A) ID. B) ID, NAME. C) CITY. D) NAME. Show Answer Correct Answer: A) ID. 47. How does data integrity differ between relational and non-relational databases? A) Relational databases enforce data integrity through constraints, while non-relational databases may not have strict integrity rules. B) Relational databases do not support data integrity at all. C) Data integrity is not a concern in either type of database. D) Non-relational databases always ensure better data integrity than relational databases. Show Answer Correct Answer: A) Relational databases enforce data integrity through constraints, while non-relational databases may not have strict integrity rules. 48. Which SQL clause groups rows based on column values? A) WHERE. B) HAVING. C) GROUP BY. D) ORDER BY. Show Answer Correct Answer: C) GROUP BY. 49. All of the following meets database objectives except A) To control redundancy. B) To standardize data storage. C) To prevent sharing of data. D) To maintain data integrity. Show Answer Correct Answer: C) To prevent sharing of data. 50. Which of the following is NOT a type of database performance tuning technique? A) Normalization. B) Data compression. C) Indexing. D) Query optimization. Show Answer Correct Answer: A) Normalization. 51. Which command is used to insert new data into a table? A) UPDATE. B) ADD. C) INSERT. D) DELETE. Show Answer Correct Answer: C) INSERT. 52. Which of the following is an example of a foreign key in a database? A) A student's last name. B) An order's date. C) A product's name. D) A customer's name. Show Answer Correct Answer: A) A student's last name. 53. What is the best solution to data anomalies? A) Adding more tables. B) Database normalization. C) Deleting all duplicate records manually. D) Avoiding foreign keys. Show Answer Correct Answer: B) Database normalization. 54. When creating a foreign key relationship, which of the following statements is true? A) The foreign key must have the same name as the primary key in the referencing table. B) The foreign key and primary key must be of different data types. C) The foreign key must have a unique index applied to it. D) The foreign key can be null in the referencing table. Show Answer Correct Answer: A) The foreign key must have the same name as the primary key in the referencing table. 55. ..... managing the license keys managing user accounts and access etc. A) GIS. B) DBA. C) GAP. D) None of the these. Show Answer Correct Answer: B) DBA. 56. Which architecture involves multiple database servers? A) Centralized. B) Client/Server. C) In-memory. D) Flat file. Show Answer Correct Answer: B) Client/Server. 57. A group of columns serving as a primary key are known as ..... key A) Candidate. B) Composite. C) Alternate. D) Foreign. Show Answer Correct Answer: B) Composite. 58. Which data type can store up to 255 characters? A) Number. B) Text. C) Long Text. D) Date/Time. Show Answer Correct Answer: B) Text. 59. The relational model represents data in the form of ..... A) Files. B) Trees. C) Tables. D) Graphs. Show Answer Correct Answer: C) Tables. 60. A contains the smallest unit of meaningful data, so you might call it the basic building block for a data file. A) Record. B) Field. C) Table. D) None of the above. Show Answer Correct Answer: B) Field. ← PreviousNext →Related QuizzesScience QuizzesClass 11 QuizzesClass 11 Computer Science Chapter 7 Database Concepts Quiz 1Class 11 Computer Science Chapter 7 Database Concepts Quiz 2Class 11 Computer Science Chapter 7 Database Concepts Quiz 3Class 11 Computer Science Chapter 7 Database Concepts Quiz 4Class 11 Computer Science Chapter 7 Database Concepts Quiz 5Class 11 Computer Science Chapter 7 Database Concepts Quiz 6Class 11 Computer Science Chapter 7 Database Concepts Quiz 7Class 11 Computer Science Chapter 7 Database Concepts Quiz 8 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books