This quiz works best with JavaScript enabled. Home > Class 12 > Class 12 Computer Science Chapter 3 Database Management Systems – Quiz 11 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 12 Computer Science Chapter 3 Database Management Systems Quiz 11 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. .... are the basic building blocks of a database. A) Tables. B) Record. C) Fields. D) All of the above. Show Answer Correct Answer: A) Tables. 2. List different types of distributed data DBMS architectures A) The different types of distributed database architectures include client-server architecture, peer-to-peer architecture, and multi-tier architecture. B) Relational architecture, NoSQL architecture, Object-oriented architecture. C) Single-tier architecture, Two-tier architecture, Three-tier architecture. D) Centralized architecture, Decentralized architecture, Hybrid architecture. Show Answer Correct Answer: A) The different types of distributed database architectures include client-server architecture, peer-to-peer architecture, and multi-tier architecture. 3. Which of the following is a feature of a semi-structured data model? A) Allows different sets of attributes for the same data type. B) Uses only relational structures. C) Is not used in modern applications. D) Requires fixed schemas. Show Answer Correct Answer: A) Allows different sets of attributes for the same data type. 4. What type of attribute cannot be divided further? A) Multi-value. B) Simple. C) Derived. D) Composite. Show Answer Correct Answer: B) Simple. 5. Data ..... helps help people use information to make decisions and take actions. A) Validation. B) Checks. C) Accuracy. D) Integrity. Show Answer Correct Answer: D) Integrity. 6. What are the three levels of data abstraction in a DBMS? A) Data level, schema level, and user level. B) Physical level, conceptual level, and external level. C) The three levels of data abstraction in a DBMS are physical level, logical level, and view level. D) Storage level, logical level, and interface level. Show Answer Correct Answer: C) The three levels of data abstraction in a DBMS are physical level, logical level, and view level. 7. What is a composite key and how is it used in normalization? A) A composite key is a single column used to identify records. B) Normalization eliminates the need for any keys in a database. C) A composite key is used only for indexing and has no role in normalization. D) A composite key is a unique identifier made up of multiple columns, used in normalization to ensure unique records and reduce redundancy. Show Answer Correct Answer: D) A composite key is a unique identifier made up of multiple columns, used in normalization to ensure unique records and reduce redundancy. 8. What is a natural way to perform ad hoc queries? A) Using SQL or filters. B) Using spreadsheets. C) Using CSV files. D) Using manual scanning. Show Answer Correct Answer: A) Using SQL or filters. 9. A NULL value represents: A) 0. B) Empty String. C) Unknown or Unavailable Data. D) Error. Show Answer Correct Answer: C) Unknown or Unavailable Data. 10. A relational database management system (RDBMS) is ideal for handling large volumes of unstructured data. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 11. What is a relationship? A) Two relational databases share a field. B) When a database has two matching primary keys. C) When two people have the same surname. D) When two or more people have the same surname. Show Answer Correct Answer: A) Two relational databases share a field. 12. Explain the concept of subqueries in SQL. A) A subquery is a method to create new tables in SQL. B) A subquery is a command to delete records from a table. C) A subquery is a type of database index. D) A subquery is a nested query that provides results to the enclosing query. Show Answer Correct Answer: D) A subquery is a nested query that provides results to the enclosing query. 13. Which of the following is a feature of a relational database? A) Hierarchical data storage. B) Network data model. C) Tables with rows and columns. D) Object-oriented data model. Show Answer Correct Answer: C) Tables with rows and columns. 14. Why are naming conventions not standardized across different companies? A) Because all companies use the same software systems. B) Because different companies in the same field have different naming conventions. C) Because naming conventions are legally protected. D) Because naming conventions are irrelevant in modern databases. Show Answer Correct Answer: B) Because different companies in the same field have different naming conventions. 15. Airbnb uses which DBMS to ensure scalability and ease of management? A) Google Cloud Spanner. B) IBM Db2. C) Microsoft Access. D) Amazon RDS. Show Answer Correct Answer: D) Amazon RDS. 16. In 1-tier architecture, all of the following are on the same machine EXCEPT: A) Application Logic. B) Database. C) Client Interface. D) Server Machine. Show Answer Correct Answer: D) Server Machine. 17. If a process of operating system is ready to execute, but waiting for availability of resources, then the possible state in this process could be identified as ..... A) New Born State. B) Ready State. C) Waiting State. D) Exit State. Show Answer Correct Answer: B) Ready State. 18. What is the primary goal of database normalisation? A) To increase data redundancy. B) To reduce data redundancy. C) To enhance data complexity. D) To decrease data integrity. Show Answer Correct Answer: B) To reduce data redundancy. 19. What is a data dictionary in a DBMS? A) A collection of metadata describing the structure of the database. B) A user manual for database users. C) A backup of all database records. D) A software tool for managing indexes. Show Answer Correct Answer: A) A collection of metadata describing the structure of the database. 20. Exclusive Lock (X Lock):Allows only one transaction to ..... and ..... a data item. A) Read, write. B) Write, delete. C) Read, delete. D) Update, delete. Show Answer Correct Answer: A) Read, write. 21. What is a characteristic of a relational database? A) Data cannot be related. B) Data is stored in tables. C) Data is unstructured. D) Data is stored in key-value pairs. Show Answer Correct Answer: B) Data is stored in tables. 22. What are access rights in a DBMS? A) Permissions granted to users to perform specific operations on a database. B) The physical location where a database is stored. C) The process of converting data into a structured format. D) The rules and guidelines for data entry and manipulation. Show Answer Correct Answer: A) Permissions granted to users to perform specific operations on a database. 23. Which type of query in MS Access is used to summarize data and calculate averages or totals? A) Select Query. B) Crosstab Query. C) Update Query. D) Parameter Query. Show Answer Correct Answer: B) Crosstab Query. 24. Explain the concept of data integrity. A) Data integrity is the process of deleting unnecessary data. B) Data integrity is the ability to store data in multiple formats. C) Data integrity refers to the speed of data processing. D) Data integrity is the maintenance of, and the assurance of, the accuracy and consistency of data over its entire lifecycle. Show Answer Correct Answer: D) Data integrity is the maintenance of, and the assurance of, the accuracy and consistency of data over its entire lifecycle. 25. Which operation is NOT part of data manipulation in a database? A) Insertion. B) Deletion. C) Update. D) Backup. Show Answer Correct Answer: D) Backup. ← PreviousNext →Related QuizzesClass 12 Computer Science Chapter 3 Database Management Systems Quiz 1Class 12 Computer Science Chapter 3 Database Management Systems Quiz 2Class 12 Computer Science Chapter 3 Database Management Systems Quiz 3Class 12 Computer Science Chapter 3 Database Management Systems Quiz 4Class 12 Computer Science Chapter 3 Database Management Systems Quiz 5Class 12 Computer Science Chapter 3 Database Management Systems Quiz 6Class 12 Computer Science Chapter 3 Database Management Systems Quiz 7Class 12 Computer Science Chapter 3 Database Management Systems Quiz 8Class 12 Computer Science Chapter 3 Database Management Systems Quiz 9Class 12 Computer Science Chapter 3 Database Management Systems Quiz 10 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books