This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 32 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 32 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What is the purpose of a primary key in a database? A) The purpose of a primary key in a database is to uniquely identify each record in a table. B) To group related records in a table. C) To enforce data integrity across multiple tables. D) To store large amounts of data efficiently. Show Answer Correct Answer: A) The purpose of a primary key in a database is to uniquely identify each record in a table. 2. What type of data does the 'Appointments Table' in a hospital database contain? A) Prescription details. B) Appointment ID, Patient ID, Doctor ID, Date & Time. C) Doctor specialization. D) Patient medical history. Show Answer Correct Answer: B) Appointment ID, Patient ID, Doctor ID, Date & Time. 3. Which constraint uniquely identifies each row in a table? A) Primary Key. B) Unique. C) Foreign Key. D) Not Null. Show Answer Correct Answer: A) Primary Key. 4. What type of relationship involves three entities? A) Binary Relationship. B) Unary Relationship. C) Ternary Relationship. D) None of the above. Show Answer Correct Answer: C) Ternary Relationship. 5. A ..... shows specific information from a database to make it easier to read or analyze. A) View. B) Table. C) Form. D) Index. Show Answer Correct Answer: A) View. 6. Relational Structure A) A database structure that stores data in related tables using keys. B) A type of database that uses a single table for all data. C) A method of storing data in a flat file format. D) A structure that organizes data in a hierarchical manner. Show Answer Correct Answer: A) A database structure that stores data in related tables using keys. 7. How can you modify an existing table in a database? A) Use the ALTER TABLE statement. B) Use the DROP TABLE statement. C) Use the CREATE TABLE statement. D) Use the SELECT statement. Show Answer Correct Answer: A) Use the ALTER TABLE statement. 8. Database A) A collection of unrelated information stored in a random manner. B) A collection of related information organised in a logical way for rapid search and retrieval. C) A type of software used for creating websites. D) A method of storing data in physical files. Show Answer Correct Answer: B) A collection of related information organised in a logical way for rapid search and retrieval. 9. A relation is in this form if it is in BCNF and has no multivalued dependencies: A) Second normal form. B) Third normal form. C) Fourth normal form. D) Domain/key normal form. Show Answer Correct Answer: C) Fourth normal form. 10. Which operation is considered a query function? A) INSERT. B) DELETE. C) UPDATE. D) SELECT. Show Answer Correct Answer: D) SELECT. 11. Section A:True or False (5 marks)-Write True or False beside each statement. A database is a collection of related data that can be easily accessed and managed. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 12. Robert needs to create a database of all his friends. In a table, is what last name considered? A) Field. B) Record. C) Table. D) Cell Address. Show Answer Correct Answer: A) Field. 13. In a relational database, what is a primary table? A) A table that stores only attributes. B) A table that contains all data. C) A table that forms a relationship with another table. D) A table with no relationships. Show Answer Correct Answer: C) A table that forms a relationship with another table. 14. Apa itu konsep relasi dalam database? A) Proses penggabungan dua database. B) Hubungan antara kolom yang tidak terkait dalam database. C) Pengelompokan data dalam database. D) Hubungan antara entitas atau tabel dalam database yang saling terkait melalui kunci asing. Show Answer Correct Answer: D) Hubungan antara entitas atau tabel dalam database yang saling terkait melalui kunci asing. 15. What is the role of database designers? A) To write software programs. B) To identify data to be stored. C) To manage hardware resources. D) To monitor database usage. Show Answer Correct Answer: B) To identify data to be stored. 16. Which of the following is a benefit of using a database over a file-based system? A) Increased data privacy. B) Less data integrity. C) More complex data entry. D) Higher data redundancy. Show Answer Correct Answer: A) Increased data privacy. 17. What is a lookup wizard used for? A) To print reports. B) To delete old data. C) To define lookup fields. D) To create new records. Show Answer Correct Answer: C) To define lookup fields. 18. Which of the following is NOT a valid primary key in a database? A) A customer's name. B) A student's last name. C) A product's name. D) An order's date. Show Answer Correct Answer: B) A student's last name. 19. A set of attributes in one table that refer to the primary key in another table. A) Primary key. B) Foreign key. C) Unique key. D) Composite key. Show Answer Correct Answer: B) Foreign key. 20. What does validation NOT check in a computerised system? A) Sensibility of data. B) Reasonableness of data. C) Accuracy of data. D) Format of data. Show Answer Correct Answer: C) Accuracy of data. 21. Which type of data model focuses on high-level ideas and answers the question of what a system contains? A) Relational Data Model. B) Logical Data Model. C) Physical Data Model. D) Conceptual Data Model. Show Answer Correct Answer: D) Conceptual Data Model. 22. What is the role of a database administrator (DBA)? A) To develop new database software. B) To maintain a successful database environment. C) To design user interfaces. D) To create data entry forms. Show Answer Correct Answer: B) To maintain a successful database environment. 23. What data type is used to store attachments, such as images and documents, with the records in a table? A) Calculated. B) Hyperlink. C) OLE Object. D) Attachment. Show Answer Correct Answer: D) Attachment. 24. Which of the following represents a diagram showing the logical steps of a program? A) Source code. B) Machine code. C) Flowchart. D) Debugging. Show Answer Correct Answer: C) Flowchart. 25. What is the primary performance benefit of using a stored procedure for a query that is executed thousands of times per minute? A) It automatically creates indexes on the tables being queried. B) The database caches the procedure's execution plan, avoiding the need to re-compile the query each time. C) It uses less network bandwidth because EXEC is shorter than a SELECT statement. D) It automatically runs at the SERIALIZABLE isolation level. Show Answer Correct Answer: B) The database caches the procedure's execution plan, avoiding the need to re-compile the query each time. ← PreviousNext →Related 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 8Class 11 Computer Science Chapter 7 Database Concepts Quiz 9Class 11 Computer Science Chapter 7 Database Concepts Quiz 10 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books