This quiz works best with JavaScript enabled. Home > Class 12 > Class 12 Computer Science Chapter 3 Database Management Systems – Quiz 29 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 12 Computer Science Chapter 3 Database Management Systems Quiz 29 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Which of the following is true about a foreign key? A) It cannot reference a primary key in another table. B) It must have a different data type than the primary key it references. C) It ensures referential integrity by linking to a primary key in another table. D) It must always be a unique value. Show Answer Correct Answer: C) It ensures referential integrity by linking to a primary key in another table. 2. What is the primary purpose of the relational model in databases? A) Organize data in tables. B) Create graphical representations. C) Perform complex calculations. D) Manage network connections. Show Answer Correct Answer: A) Organize data in tables. 3. Which of the following best describes the key difference between a file-based system and a database management system? A) Storage medium. B) Data organisation and management capabilities. C) Cost of implementation. D) Number of files stored. Show Answer Correct Answer: B) Data organisation and management capabilities. 4. Indices whose search key specifies an order different from the sequential order of the file are called ..... indices. A) Nonclustered. B) Secondary. C) All of the mentioned. D) None of the mentioned. Show Answer Correct Answer: C) All of the mentioned. 5. Database is collection of ..... A) Modules. B) Data. C) Programs. D) None of these. Show Answer Correct Answer: B) Data. 6. What does data independence refer to? A) Separation of data from applications. B) Data stored in multiple locations. C) Data redundancy. D) Data encryption. Show Answer Correct Answer: A) Separation of data from applications. 7. What is the main purpose of a database? A) To store and manage data B) To create software C) To design websites D) To run applications A) G) To host web servers. B) F) To manage user accounts. C) E) To analyze financial data. D) A) To store and manage data. Show Answer Correct Answer: D) A) To store and manage data. 8. Which of the following would result in a data anomaly? A) Inconsistent redundant data. B) Modification of data. C) Timeliness of data. D) Obsolescence of data. Show Answer Correct Answer: A) Inconsistent redundant data. 9. Which of the following is a disadvantage of a DBMS? A) Improved data sharing. B) High initial cost and complexity. C) Enhanced data security. D) Reduced data redundancy. Show Answer Correct Answer: B) High initial cost and complexity. 10. Which DBMS component controls user access and prevents unauthorized users from editing records? A) Transaction Manager. B) Authorization. C) Indexing. D) Schema. Show Answer Correct Answer: B) Authorization. 11. Which of the following statements is true about the relational database model? A) Requires less storage. B) Allows flexible queries using tables and keys. C) Supports tree-like structures. D) Uses less processing power. Show Answer Correct Answer: B) Allows flexible queries using tables and keys. 12. In the context of a database, what is ACID? A) A chemical compound. B) A set of properties that guarantee database transactions are processed reliably. C) A database programming language. D) A data visualization tool. Show Answer Correct Answer: B) A set of properties that guarantee database transactions are processed reliably. 13. Which of the following best explains the concept of data redundancy? A) Storing the same piece of data in multiple places within a database. B) Ensuring data is always up to date. C) Encrypting data for security. D) Backing up data to an external drive. Show Answer Correct Answer: A) Storing the same piece of data in multiple places within a database. 14. Which of the following topics is covered in the "INTRODUCTION TO DBMS" section? A) Data vs Information. B) Network Security. C) Artificial Intelligence. D) Web Development. Show Answer Correct Answer: A) Data vs Information. 15. Which of the following is a dynamic web technology? A) JavaScript. B) HTML. C) XML. D) CSS. Show Answer Correct Answer: A) JavaScript. 16. Define the term 'schema' in a database context. A) A schema is a programming language for databases. B) A schema is a backup system for database data. C) A schema is a type of database query. D) A schema is the organizational blueprint of a database that defines its structure and relationships. Show Answer Correct Answer: D) A schema is the organizational blueprint of a database that defines its structure and relationships. 17. What does database integrity refer to in a DBMS? A) The validity and consistency of stored data. B) The protection of the database from unauthorized users. C) The speed at which data can be accessed. D) The size of the database. Show Answer Correct Answer: A) The validity and consistency of stored data. 18. The following figure shows a: A) Disjoint constraint. B) Completeness constraint. C) Supertype/subtype hierarchy. D) Spindle constraint. Show Answer Correct Answer: C) Supertype/subtype hierarchy. 19. ..... is a condition specified on a database schema and restricts the data that can be stored in an instance of the database. A) Key constraint. B) Check constraint. C) Foreign key constraint. D) Integrity constraint. Show Answer Correct Answer: D) Integrity constraint. 20. When a process is waiting for some I/O events, after the waiting process is completed, to what state does the process transition next? A) Terminated state. B) Running state. C) Ready state. D) New state. Show Answer Correct Answer: C) Ready state. 21. If a web developer wants to create a login page with real-time validation, then which technologies should they combine? A) HTML, CSS, JavaScript. B) JavaScript, SQL, PHP. C) HTML, CSS, Python. D) Java, PHP, SQL. Show Answer Correct Answer: A) HTML, CSS, JavaScript. 22. Which one of the following schema development practice is used for optimizing database performance? A) Name conventions. B) Data security. C) Normalization. D) Documentation. Show Answer Correct Answer: C) Normalization. 23. Which of the following is NOT a function of a DBMS? A) Data storage. B) Data retrieval. C) Operating system management. D) Data manipulation. Show Answer Correct Answer: C) Operating system management. 24. A company wants to store information about employees and their salaries. The data includes EmployeeID, EmployeeName, JobTitle, and Salary. Which of the following is an example of an attribute in this scenario? A) Employees. B) Manages. C) Salary. D) Database. Show Answer Correct Answer: C) Salary. 25. What is meant by location transparency in a distributed DBMS? A) Users must know the exact location of data. B) Data is only accessible from one location. C) Data can be accessed without knowing its physical location. D) All data must be stored in the same format. Show Answer Correct Answer: C) Data can be accessed without knowing its physical location. ← 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