This quiz works best with JavaScript enabled. Home > Class 12 > Class 12 Computer Science Chapter 3 Database Management Systems – Quiz 50 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 12 Computer Science Chapter 3 Database Management Systems Quiz 50 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What are the key components of a data model? A) Entities, attributes, relationships, and constraints. B) Fields, records, structures, and functions. C) Tables, views, indexes, and queries. D) Schemas, models, formats, and types. Show Answer Correct Answer: A) Entities, attributes, relationships, and constraints. 2. What is a key difference between paper-based and digital database systems? A) Paper-based systems are faster and more secure. B) Digital systems are costlier but slower. C) Paper-based systems are manual and prone to data loss, while digital systems are faster and more secure. D) Both systems are equally efficient. Show Answer Correct Answer: C) Paper-based systems are manual and prone to data loss, while digital systems are faster and more secure. 3. Chloe is creating a database for several customers. What is the data type for the field total sales? A) Yes/No. B) Data. C) Number. D) Currency. Show Answer Correct Answer: D) Currency. 4. The number of tuples in a relation is called its ..... , while the number of attributes in a relation is called its ..... A) Degree, Cardinality. B) Cardinality, Degree. C) Participation constraint, cardinality. D) Degree, Participation constraint. Show Answer Correct Answer: B) Cardinality, Degree. 5. Which of the following is NOT a database management system? A) PostgreSQL. B) Excel. C) MySQL. D) Oracle. Show Answer Correct Answer: B) Excel. 6. What is a logical schema? A) A data model for a specific database that is independent of the DBMS used. B) A physical representation of a database. C) A programming language used to query databases. D) A hardware device used to store data. Show Answer Correct Answer: A) A data model for a specific database that is independent of the DBMS used. 7. What is DBMS and its role in managing databases? A) DBMS is a software used to manage and organize databases. B) DBMS is a programming language. C) DBMS is a type of computer monitor. D) DBMS is a hardware component used in networking. Show Answer Correct Answer: A) DBMS is a software used to manage and organize databases. 8. What are the different normal forms in database normalization? A) 1NF, 2NF, 3NF, 4NF, 5NF, 6NF. B) 1NF, 2NF, 3NF, 6NF. C) 1NF, 2NF, 3NF, 4NF, 5NF, 7NF. D) 1NF, 2NF, 3NF, BCNF, 4NF, 5NF. Show Answer Correct Answer: D) 1NF, 2NF, 3NF, BCNF, 4NF, 5NF. 9. Which of the following is the disadvantages of DBMS? A) Cost of setup of DBMS is relatively cheap. B) Database systems are complex. C) Database will not be corrupted. D) Database systems are fast to be designed. Show Answer Correct Answer: B) Database systems are complex. 10. If a user requests information about a specific product from a database, which DBMS function translates this logical request into a command to physically locate and retrieve the data? A) Data transformation and presentation. B) Data dictionary management. C) Data storage management. D) Data backup management. Show Answer Correct Answer: A) Data transformation and presentation. 11. What is the purpose of concurrency control in databases? A) To increase speed. B) To prevent transaction interference and maintain consistency. C) To reduce memory usage. D) To allow multiple users to access the database. Show Answer Correct Answer: B) To prevent transaction interference and maintain consistency. 12. How the Every weak entity set can be changed into a strong entity set through? A) Using generalization. B) Using aggregation. C) Adding appropriate attributes. D) None of the above. Show Answer Correct Answer: C) Adding appropriate attributes. 13. Which of the following is a characteristic of client-side programming? A) Processes requests on the web server. B) Manages database connections. C) Runs on the client's browser. D) Generates dynamic content. Show Answer Correct Answer: C) Runs on the client's browser. 14. What type of attributes does a strong entity set with only simple attributes have? A) Weak attributes. B) Composite attributes. C) Multi-valued attributes. D) Simple attributes. Show Answer Correct Answer: D) Simple attributes. 15. What is a common query language used in DBMS? A) HTML. B) Java. C) Python. D) SQL. Show Answer Correct Answer: D) SQL. 16. Which best describes the difference between logical and physical schema? A) Logical = data storage; Physical = user views. B) Logical = data organization; Physical = actual storage. C) Logical = indexes; Physical = keys. D) Logical = physical storage media; Physical = queries. Show Answer Correct Answer: B) Logical = data organization; Physical = actual storage. 17. Which of the following describes a one-to-one relationship in an ERD? A) An entity is related to only one instance of another entity. B) Multiple entities are related to multiple instances of another entity. C) An entity is related to many instances of another entity. D) Many entities are related to a single instance of another entity. Show Answer Correct Answer: A) An entity is related to only one instance of another entity. 18. What is the output of a query in tuple relational calculus? A) A single value. B) A set of tuples. C) A single tuple. D) No output. Show Answer Correct Answer: B) A set of tuples. 19. What are the key differences between OLAP and OLTP systems? A) OLAP is designed for operational tasks, while OLTP focuses on data warehousing. B) OLAP handles real-time data, whereas OLTP is for historical data. C) OLAP is for transaction processing, while OLTP is for data analysis. D) OLAP is for data analysis and reporting, while OLTP is for transaction processing. Show Answer Correct Answer: D) OLAP is for data analysis and reporting, while OLTP is for transaction processing. 20. Duplication of data is called ..... A) Inconsistency. B) Consistency. C) Redundancy. D) Foreign Key. Show Answer Correct Answer: C) Redundancy. 21. What is the role of end users in a database system? A) Creating backup procedures. B) Using application programs to access data. C) Managing the DBMS. D) Designing the database. Show Answer Correct Answer: B) Using application programs to access data. 22. What is the expected outcome of the lesson on DDBMS? A) Understanding the benefits and drawbacks of DDBMS. B) Learning only about local databases. C) Ignoring the characteristics of DDBMS. D) Focusing solely on data replication. Show Answer Correct Answer: A) Understanding the benefits and drawbacks of DDBMS. 23. Which of the following is used to ensure that a relationship between two tables remains consistent? A) Primary Key Constraint. B) Referential Integrity Constraint. C) Unique Constraint. D) Check Constraint. Show Answer Correct Answer: B) Referential Integrity Constraint. 24. What is a risk of vendor lock-in? A) Without open exports. B) With multiple file formats. C) With user access issues. D) With data redundancy. Show Answer Correct Answer: A) Without open exports. 25. A standardized programming language that is used to manage relational databases A) SQL. B) Table. C) MySQL. D) Query. Show Answer Correct Answer: A) SQL. ← 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