This quiz works best with JavaScript enabled. Home > Class 12 > Class 12 Computer Science Chapter 3 Database Management Systems – Quiz 48 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 12 Computer Science Chapter 3 Database Management Systems Quiz 48 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. A ..... addresses whether an instance of a supertype may simultaneously be a member of two or more subtypes. A) Disjointness constraint. B) Disjoint rule. C) Partial specialization. D) Total specialization. Show Answer Correct Answer: A) Disjointness constraint. 2. ..... :Verifying a user's identity. A) Authentication. B) Encryption. C) Authorization. D) Accounting. Show Answer Correct Answer: A) Authentication. 3. Which of the following commands should be used to create a database named "student" ? A) CREATE?I student. B) CREATE DATABASE student. C) DATABASE /student. D) DATABASE student. Show Answer Correct Answer: B) CREATE DATABASE student. 4. What is the purpose of the GROUP BY clause? A) To group data. B) To delete data. C) To filter data. D) To sort data. Show Answer Correct Answer: A) To group data. 5. Abort (Rollback):The cancellation of a transaction where all changes are ..... ? A) Undone. B) Saved. C) Ignored. D) Committed. Show Answer Correct Answer: A) Undone. 6. What describes the relation name and attributes in a relational database? A) Relation Instance. B) Relation Schema. C) Relation Key. D) Attribute Domain. Show Answer Correct Answer: B) Relation Schema. 7. What is a relationship set? A) A type of entity. B) A collection of relationships. C) A data type. D) A single relationship. Show Answer Correct Answer: B) A collection of relationships. 8. What is a disadvantage of the database approach? A) Increased performance for specific applications. B) Improved backup and recovery services. C) Limited data redundancy. D) Complexity of the DBMS. Show Answer Correct Answer: D) Complexity of the DBMS. 9. In terms of databases, what is meant by security? A) Only the most important data is kept in a secure place. B) Different access rights cannot be assigned to different users. C) All data is kept in a secure place and different access rights can be assigned to different users. D) None of the above. Show Answer Correct Answer: C) All data is kept in a secure place and different access rights can be assigned to different users. 10. How can a hospital ensure that only authorized personnel access sensitive patient data? A) Implementing strong password policies and access controls. B) Allowing open access to all hospital staff. C) Sharing login credentials between departments. D) Storing data in unencrypted formats. Show Answer Correct Answer: A) Implementing strong password policies and access controls. 11. Which of the following is a top-down approach in which the entity's higher level can be divided into two lower sub-entities? A) Aggregation. B) Generalization. C) Specialization. D) All of the above. Show Answer Correct Answer: C) Specialization. 12. ..... :Allowing individuals control over their data. A) Autonomy. B) Transparency. C) Security. D) Efficiency. Show Answer Correct Answer: A) Autonomy. 13. What is the role of a database in modern computing? A) To manage data efficiently and ensure integrity. B) To provide a paper-based filing system. C) To store data in text files. D) To create redundancy in data storage. Show Answer Correct Answer: A) To manage data efficiently and ensure integrity. 14. Which of the following best describes "Data Dependence" in file systems? A) The ability to change data properties without affecting programs. B) The inability to change data properties without affecting programs. C) The ability to share data securely across locations. D) The ability to perform ad hoc queries easily. Show Answer Correct Answer: B) The inability to change data properties without affecting programs. 15. Which key establishes a link between two tables? A) Primary key. B) Foreign key. C) Candidate key. D) Composite key. Show Answer Correct Answer: B) Foreign key. 16. What is the difference between relational algebra and relational calculus? A) Relational algebra is used for data retrieval; relational calculus is used for data storage. B) Relational algebra is procedural; relational calculus is non-procedural. C) Relational algebra uses SQL syntax; relational calculus uses XML syntax. D) Relational algebra is based on set theory; relational calculus is based on logic. Show Answer Correct Answer: B) Relational algebra is procedural; relational calculus is non-procedural. 17. What is the full form of RDBMS? A) Relational Database Management System. B) Remote Data Backup Management Service. C) Random Data Backup Management System. D) Real-time Database Management Software. Show Answer Correct Answer: A) Relational Database Management System. 18. What is a primary advantage of using a database management system? A) Data redundancy. B) Improved data security. C) Increased data entry time. D) Limited data access. Show Answer Correct Answer: B) Improved data security. 19. What is a characteristic of a database approach? A) Manual data entry only. B) Centralized data management. C) No data sharing. D) Decentralized data management. Show Answer Correct Answer: B) Centralized data management. 20. What is an advantage of using a DBMS? A) Increased data redundancy. B) Uncontrolled data access. C) Enforced data integrity. D) Greater data inconsistency. Show Answer Correct Answer: C) Enforced data integrity. 21. What is a disadvantage of using a DBMS according to the text? A) Enhanced performance for all applications. B) Increased cost of data conversion. C) Simplification of data maintenance. D) Reduced impact of system failures. Show Answer Correct Answer: B) Increased cost of data conversion. 22. What is the default name of a SQL Server database created in Visual Studio? A) Database1.mdf. B) NewDatabase.mdf. C) DefaultDatabase.mdf. D) MyDatabase.mdf. Show Answer Correct Answer: A) Database1.mdf. 23. Which of the following is a common feature of modern DBMSs? A) Lack of support for concurrent users. B) Support for transaction management. C) Inability to recover from system failures. D) No support for data backup. Show Answer Correct Answer: B) Support for transaction management. 24. What is the function of a database schema? A) To store the actual data values in the database. B) To define the logical structure of the database. C) To manage the physical hardware where the database is stored. D) To provide a backup of the entire database. Show Answer Correct Answer: B) To define the logical structure of the database. 25. The file in DBMS is called as ..... in RDBMS. A) Console. B) Schema. C) Table. D) Entity. Show Answer Correct Answer: C) Table. ← 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