This quiz works best with JavaScript enabled. Home > Class 12 > Class 12 Computer Science Chapter 3 Database Management Systems – Quiz 49 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 12 Computer Science Chapter 3 Database Management Systems Quiz 49 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What is the purpose of a DBMS? A) To delete data. B) To print data. C) To create files. D) To store and access data. Show Answer Correct Answer: D) To store and access data. 2. Which data model organizes data in a tree-like structure? A) Relational Model. B) Hierarchical Model. C) Network Model. D) Object-Oriented Model. Show Answer Correct Answer: B) Hierarchical Model. 3. Explain what a database schema is. A) A database schema is a formal description of the structure of a database, including tables, fields, and relationships. B) A database schema is a type of software used to manage user accounts. C) A database schema is a programming language for writing database queries. D) A database schema is a backup system for storing data securely. Show Answer Correct Answer: A) A database schema is a formal description of the structure of a database, including tables, fields, and relationships. 4. What are the main components of a database system architecture? A) The main components of a database system architecture are the DBMS, the database, application programs, and users. B) The main components are the server, network, and storage devices. C) The main components consist of hardware, software, and network protocols. D) The main components include only the database and users. Show Answer Correct Answer: A) The main components of a database system architecture are the DBMS, the database, application programs, and users. 5. Which normal form is achieved when a table is free of transitive dependency? A) First Normal Form (1NF). B) Second Normal Form (2NF). C) Third Normal Form (3NF). D) Boyce-Codd Normal Form (BCNF). Show Answer Correct Answer: C) Third Normal Form (3NF). 6. Which normal form is considered to eliminate transitive dependencies? A) First Normal Form (1NF). B) Second Normal Form (2NF). C) Third Normal Form (3NF). D) None of the above. Show Answer Correct Answer: C) Third Normal Form (3NF). 7. What is the primary goal of normalization in the context of a relational database? A) Maximize data redundancy. B) Minimize data security. C) Organize data to reduce data duplication and dependency. D) Increase query performance. Show Answer Correct Answer: C) Organize data to reduce data duplication and dependency. 8. What is the difference between DDL and DML? A) DDL is a programming language; DML is a markup language. B) DDL defines database structure; DML manipulates data within that structure. C) DDL and DML are the same and can be used interchangeably. D) DDL is used for querying data; DML defines database structure. Show Answer Correct Answer: B) DDL defines database structure; DML manipulates data within that structure. 9. ..... :Taking responsibility for data misuse. A) Accountability. B) Confidentiality. C) Anonymity. D) Integrity. Show Answer Correct Answer: A) Accountability. 10. Which of the following is NOT typically associated with a data warehouse? A) Storing historical data. B) Supporting day-to-day operations. C) Requiring data massaging for decisions. D) Having a structure quite different from operational databases. Show Answer Correct Answer: B) Supporting day-to-day operations. 11. What is SQL and its role in DBMS? A) SQL is a markup language for designing user interfaces. B) SQL is used for creating web applications. C) SQL is a programming language used to manage and manipulate relational databases in a DBMS. D) SQL is a type of database management system. Show Answer Correct Answer: C) SQL is a programming language used to manage and manipulate relational databases in a DBMS. 12. An operating system function that memorizes track of information regarding the creation, deletion, transfer, copy, and storage of files in an organized manner is related to ..... A) Memory Management. B) Device Management. C) File Management. D) Security Management. Show Answer Correct Answer: C) File Management. 13. What is the primary purpose of transaction transparency in DDBMS? A) To increase processing speed. B) To reduce network traffic. C) To maintain data consistency and integrity. D) To simplify database design. Show Answer Correct Answer: C) To maintain data consistency and integrity. 14. Which of the following aggregate function is used to specify number of tuples in the given table A) Count(*). B) Count(Attribute). C) Sum(attribute). D) Max(*). Show Answer Correct Answer: A) Count(*). 15. Which SQL command is used to insert new rows into a table? A) APPEND. B) ADD. C) INSERT INTO. D) CREATE. Show Answer Correct Answer: C) INSERT INTO. 16. What is a common use case for graph databases? A) Storing large volumes of unstructured data. B) Performing complex calculations. C) Analyzing relationships between data points. D) Managing transactions. Show Answer Correct Answer: C) Analyzing relationships between data points. 17. Serial Schedule:Transactions execute one after another with ..... A) No overlap. B) Partial overlap. C) Full overlap. D) Random overlap. Show Answer Correct Answer: A) No overlap. 18. A column or combination of columns that contain values that uniquely identify each row in the table A) Primary key. B) Foreign key. C) Composite key. D) None of the above. Show Answer Correct Answer: A) Primary key. 19. ..... :Protecting data from loss and failure. A) Backup and Recovery Security. B) Network Security. C) Physical Security. D) Application Security. Show Answer Correct Answer: A) Backup and Recovery Security. 20. Which view allows to modify table's structure in Access? A) Design view. B) Datasheet view. C) Pivot table view. D) Pivot chart view. Show Answer Correct Answer: A) Design view. 21. Which of the following is NOT a transparency feature of a distributed DBMS? A) Data redundancy transparency. B) Concurrency transparency. C) Failure transparency. D) Replication transparency. Show Answer Correct Answer: A) Data redundancy transparency. 22. What is the significance of a primary key in a relational database? A) It defines the data type of attributes. B) It allows duplicate values in a table. C) It uniquely identifies each record in a table. D) It is used to create foreign key relationships. Show Answer Correct Answer: C) It uniquely identifies each record in a table. 23. What is the role of a data dictionary in a DBMS? A) To define the structure and organization of a database. B) To perform complex data calculations. C) To enforce data integrity constraints. D) To execute database queries. Show Answer Correct Answer: A) To define the structure and organization of a database. 24. A company wants to enforce strict access control on its database. Which feature should it implement? A) Authorization and Role-Based Access Control (RBAC). B) Query Optimization. C) Data Replication. D) Normalization. Show Answer Correct Answer: A) Authorization and Role-Based Access Control (RBAC). 25. Transaction: ..... is a set of read and write operations that form a single logical unit of work. A) A set of read and write operations that form a single logical unit of work. B) A set of arithmetic operations performed in sequence. C) A group of unrelated database queries. D) A collection of backup files. Show Answer Correct Answer: A) A set of read and write operations that form a single logical unit of work. ← 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