This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 55 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 55 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. A table is in 3NF if it is in 2NF and ..... A) It has no transitive dependencies. B) It has no foreign keys. C) It has duplicate records. D) It has only one table. Show Answer Correct Answer: A) It has no transitive dependencies. 2. Find all the cities whose humidity is 89 A) SELECT city WHERE humidity = 89;. B) SELECT city FROM weather WHERE humidity = 89;. C) SELECT humidity = 89 FROM weather;. D) SELECT city FROM weather;. Show Answer Correct Answer: B) SELECT city FROM weather WHERE humidity = 89;. 3. Apa itu normalisasi dalam basis data? A) Proses menghapus duplikasi data. B) Proses menyimpan semua data dalam satu tabel. C) Proses otomatis mencadangkan data. D) Proses membuat basis data offline. E) Proses mengekspor data ke format lain. Show Answer Correct Answer: A) Proses menghapus duplikasi data. 4. What is the primary purpose of a primary key in a database table? A) To store large amounts of data. B) To allow duplicate records. C) To create relationships between tables. D) To uniquely identify each record. Show Answer Correct Answer: D) To uniquely identify each record. 5. What is the purpose of a query in a database? A) To prepare data to be used in another program. B) To ask a database to find specific data from one or more tables. C) To organize information into columns and rows. D) To create printouts for presentation and sharing. Show Answer Correct Answer: B) To ask a database to find specific data from one or more tables. 6. Which of the following could be considered a potential secondary key in a Customer table? A) Customer username. B) Customer date of birth. C) Customer email address. D) Customer postcode. Show Answer Correct Answer: A) Customer username. 7. How can you create a report in Access? A) Open Access, go to 'File' tab, select 'New Document'. B) Select 'Design' tab and click on 'Create Report' button. C) Use 'Data' tab to create a new report. D) Open Access, go to 'Create' tab, select 'Report' or use 'Report Wizard'. Show Answer Correct Answer: D) Open Access, go to 'Create' tab, select 'Report' or use 'Report Wizard'. 8. Who is called Father of relational Database from the following? A) Chris Date. B) Hugh Darween. C) Edgar Frank Codd. D) Edgar Frank Cadd. Show Answer Correct Answer: C) Edgar Frank Codd. 9. What is the purpose of the Form Wizard? A) To create and customize forms. B) To delete unwanted data. C) To change the default file name. D) To organize spreadsheets. Show Answer Correct Answer: A) To create and customize forms. 10. MySQL runs on which operating systems? A) Unix and Linux only. B) Linux and Mac OS-X only. C) Unix, Linux, Windows and others. D) Any operating system at all. Show Answer Correct Answer: C) Unix, Linux, Windows and others. 11. How do you select all fields in Form Wizard? A) Click "Select One". B) Click the double arrow (>>). C) Click the single arrow (>). D) Click "Finish". Show Answer Correct Answer: B) Click the double arrow (>>). 12. What is the purpose of DDL commands in a database? A) The purpose of DDL commands in a database is to retrieve data from the database. B) The purpose of DDL commands in a database is to perform calculations and computations on the data. C) The purpose of DDL commands in a database is to secure and protect the data in the database. D) The purpose of DDL commands in a database is to define and manage the structure of the database. Show Answer Correct Answer: D) The purpose of DDL commands in a database is to define and manage the structure of the database. 13. What happens when you delete a record in MS Access? A) It can be automatically recovered. B) It moves to a backup table. C) It is permanently removed. D) It becomes hidden but remains in the database. Show Answer Correct Answer: C) It is permanently removed. 14. What is the primary goal of data management? A) To automate data-related processes without human input. B) To ensure data accuracy, consistency, security, and accessibility. C) To improve the presentation of data across platforms. D) None of the above. Show Answer Correct Answer: B) To ensure data accuracy, consistency, security, and accessibility. 15. What advanced skills can you develop after learning the basics of Access? A) Creating complex reports and automating tasks with macros. B) Learning to play a musical instrument. C) Practicing basic yoga poses. D) Understanding elementary mathematics. Show Answer Correct Answer: A) Creating complex reports and automating tasks with macros. 16. Indicate whether the statement is true or false:A logical view shows data as it is actually organized and structured on the data storage media. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 17. What is the role of a database administrator? A) To develop software applications. B) To create network protocols. C) To manage and maintain database systems. D) To design user interfaces. Show Answer Correct Answer: C) To manage and maintain database systems. 18. In the ER model, a relationship between 'Teacher' and 'Class' would be represented as: A) Attribute. B) Primary key. C) Connection line with diamond. D) Field. Show Answer Correct Answer: C) Connection line with diamond. 19. What are primary and foreign keys used for in a database? A) Foreign keys are used to delete records from a table. B) Primary keys are used to group similar records together. C) Primary keys are used to uniquely identify records in a table, while foreign keys are used to establish relationships between tables by referencing primary keys. D) Primary keys can be duplicated across different tables. Show Answer Correct Answer: C) Primary keys are used to uniquely identify records in a table, while foreign keys are used to establish relationships between tables by referencing primary keys. 20. What are the components of a single-table database? A) Fields. B) Records. C) Validation rules. D) All of the aboveTagsLO1. Show Answer Correct Answer: D) All of the aboveTagsLO1. 21. An organized collection of structured information, or data, typically stored electronically in a computer system. A) Database Application. B) Database Management System. C) Database Integration. D) Database. Show Answer Correct Answer: D) Database. 22. What is the purpose of a database schema? A) The purpose of a database schema is to define the organization and structure of data within a database. B) To create user interfaces for applications. C) To manage network security protocols. D) To store data in a cloud environment. Show Answer Correct Answer: A) The purpose of a database schema is to define the organization and structure of data within a database. 23. A bank database has different tables for "Customers, " "Loans, " and "Transactions." This organization ensures: A) Redundancy. B) Integrity and Simplicity. C) Data Duplication. D) Manual Handling. Show Answer Correct Answer: B) Integrity and Simplicity. 24. Which data model supports many-to-many relationships? A) Hierarchical. B) Network. C) Relational. D) File system. Show Answer Correct Answer: B) Network. 25. What type of relationship exists when a single record in Table A is linked to many records in Table B? A) One-to-One. B) One-to-Many. C) Many-to-Many. D) Many-to-One. Show Answer Correct Answer: B) One-to-Many. ← 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