This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 53 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 53 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. The following key is used to denote uniqueness in the collection? A) Id . B) Id. C) Id-. D) Id. Show Answer Correct Answer: B) Id. 2. Which of the following is the BEST example of numerical data? A) Student Name. B) 3.14159. C) A12345. D) %%%%$ $ $. Show Answer Correct Answer: B) 3.14159. 3. What does the term 'mini-world' refer to in database terminology? A) A type of database model. B) A small database. C) A database management tool. D) A part of the real world about which data is stored. Show Answer Correct Answer: D) A part of the real world about which data is stored. 4. Which of the following is NOT a popular database management system? A) Microsoft SQL Server. B) Oracle Database. C) Google Sheets. D) MySQL. Show Answer Correct Answer: C) Google Sheets. 5. What is the role of a foreign key in a relational database? A) To store multiple values in a field. B) To establish a relationship with another table. C) To eliminate redundancy. D) To uniquely identify a record. Show Answer Correct Answer: B) To establish a relationship with another table. 6. Which of the following is a feature of a well-normalised database? A) High data redundancy. B) Complex queries. C) Minimal data redundancy. D) Large number of tables. Show Answer Correct Answer: C) Minimal data redundancy. 7. In the relational model, a base table (base relation) is: A) A table whose rows are always computed on demand. B) A temporary table used for sorting. C) A permanently stored table that corresponds to an entity or relationship. D) A system catalog table. Show Answer Correct Answer: C) A permanently stored table that corresponds to an entity or relationship. 8. While inserting new rows in a table you must list values in the default order of the columns. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 9. Which of the following is a type of end-user? A) Database Administrators. B) Database Designers. C) Casual Users. D) Database Management Systems. Show Answer Correct Answer: C) Casual Users. 10. A deadlock occurs in a database system when: A) A transaction is forced to rollback due to a timeout. B) A transaction is waiting indefinitely for a lock to be released. C) All the transactions are waiting for a signal from the CPU scheduler. D) Two or more transactions are waiting for each other to release resources. Show Answer Correct Answer: D) Two or more transactions are waiting for each other to release resources. 11. An entity is a real world object about which information is to be stored in a database. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 12. MySQL is best classified as which type of system? A) A NoSQL database. B) A relational database management system (RDBMS). C) A programming language. D) A file management system. Show Answer Correct Answer: B) A relational database management system (RDBMS). 13. Which of the following best describes a tuple in a relational database? A) A row in a table. B) A type of query. C) A column in a table. D) A database schema. Show Answer Correct Answer: A) A row in a table. 14. What is a key limitation of flat file databases? A) Support for large volumes of data. B) No support for relationships. C) High complexity. D) High cost of implementation. Show Answer Correct Answer: B) No support for relationships. 15. Which of the following is an example of a column in a database? A) A single folder. B) A single attribute of a record. C) A single record. D) A single image. Show Answer Correct Answer: B) A single attribute of a record. 16. Which of the following is NOT one of the classical record-based logical data models? A) Hierarchical data model. B) Network data model. C) Relational data model. D) Object-oriented physical model. Show Answer Correct Answer: D) Object-oriented physical model. 17. What does the term 'atomicity' refer to in database transactions? A) All operations must be completed successfully or none at all. B) Transactions can be executed in isolation. C) Data must be consistent before and after execution. D) Changes are permanent once a transaction is completed. Show Answer Correct Answer: A) All operations must be completed successfully or none at all. 18. What are joined relations in SQL? A) Joined relations are only possible with three or more tables. B) Joined relations are a type of database index. C) Joined relations refer to the physical storage of tables in SQL. D) Joined relations in SQL are the result of combining rows from multiple tables based on a related column. Show Answer Correct Answer: D) Joined relations in SQL are the result of combining rows from multiple tables based on a related column. 19. Gina needs to create a database of all her friends. Where will all the information be kept? A) Field. B) Record. C) Table. D) Entry. Show Answer Correct Answer: B) Record. 20. Number of columns in a relation is called ..... A) Degree. B) Cardinality. C) Attribute. D) None of these. Show Answer Correct Answer: A) Degree. 21. What is a primary function of a DBMS? A) To create hardware. B) To implement and maintain a database. C) To write user manuals. D) To design websites. Show Answer Correct Answer: B) To implement and maintain a database. 22. A table is in 2NF if it is in 1NF and ..... A) It has no partial dependencies. B) It has no transitive dependencies. C) It has no composite keys. D) It has only one record. Show Answer Correct Answer: A) It has no partial dependencies. 23. What is the default size of a text data type? A) 240 characters. B) 255 characters. C) 260 characters. D) 270 characters. Show Answer Correct Answer: B) 255 characters. 24. Which of the following is an example of an entity-attribute relationship? A) The entity CUSTOMER with the attribute ADDRESS. B) The entity CUSTOMER with the attribute PRODUCT. C) The entity PRODUCT with the attribute CUSTOMER. D) The entity PRODUCT with the attribute PURCHASE. Show Answer Correct Answer: A) The entity CUSTOMER with the attribute ADDRESS. 25. What type of commands are GRANT and REVOKE? A) DML. B) DDL. C) TCL. D) DCL. Show Answer Correct Answer: D) DCL. ← 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