This quiz works best with JavaScript enabled. Home > Class 12 > Class 12 Computer Science Chapter 3 Database Management Systems – Quiz 47 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 12 Computer Science Chapter 3 Database Management Systems Quiz 47 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What does the project operation do in relational algebra? A) Renames columns. B) Deletes columns. C) Selects specific columns. D) Combines rows. Show Answer Correct Answer: C) Selects specific columns. 2. What is SQL and what is it used for? A) SQL is used for creating web applications. B) SQL is a programming language used for managing and manipulating relational databases. C) SQL is a markup language for designing websites. D) SQL is a type of spreadsheet software. Show Answer Correct Answer: B) SQL is a programming language used for managing and manipulating relational databases. 3. A key which is referring to the primary key of another table is called ..... A) Alternate Key. B) Primary Key. C) First Primary Key. D) Foreign Key. Show Answer Correct Answer: D) Foreign Key. 4. What is the definition of a database? A) A collection of unrelated files. B) An organized collection of data that can be easily accessed, managed, and updated. C) A digital device used for computations. D) A network of interconnected systems. Show Answer Correct Answer: B) An organized collection of data that can be easily accessed, managed, and updated. 5. Which of the following is NOT a characteristic of a relational table? A) Each cell contains a single value. B) Each column has a unique name. C) The order of rows is significant. D) All rows are unique. Show Answer Correct Answer: C) The order of rows is significant. 6. Which of the following is an example of a logical data model? A) ER model. B) Network model. C) Relational model. D) File system model. Show Answer Correct Answer: A) ER model. 7. Which type of database supports a company's day-to-day operations? A) Data warehouse. B) Relational database. C) Operational database. D) Distributed database. Show Answer Correct Answer: C) Operational database. 8. Write the output when the data 'Primary Key' is set to the text < in Access? A) Primary key. B) Primary key. C) PRIMARY KEY. D) Primary Key. Show Answer Correct Answer: A) Primary key. 9. In a library system, which relationship exists between Book and Borrow? A) One-to-One. B) One-to-Many. C) Many-to-Many. D) Recursive. Show Answer Correct Answer: B) One-to-Many. 10. What is the primary purpose of a Relational Database Management System? A) To store data in a hierarchical tree structure. B) To manage data using a network model. C) To organize data into tables with rows and columns. D) To process data with a focus on unstructured data. Show Answer Correct Answer: C) To organize data into tables with rows and columns. 11. What are the advantages of using NoSQL databases over traditional SQL databases? A) Strict adherence to predefined schemas. B) Limited support for unstructured data. C) Advantages of NoSQL databases include flexibility in data models, horizontal scalability, lower latency, and support for various data types. D) Increased complexity in data management. Show Answer Correct Answer: C) Advantages of NoSQL databases include flexibility in data models, horizontal scalability, lower latency, and support for various data types. 12. In terms of databases, what is meant by isolation? A) Users cannot share data. B) Transactions must not interfere with other transactions. C) Changes must not break the database. D) None of the above. Show Answer Correct Answer: B) Transactions must not interfere with other transactions. 13. What is allowed the input mask symbol # in Access? A) Letter or digit. B) Letter A through Z. C) A digit 0-9 with +/-sign. D) A digit 0-9 without +/-sign. Show Answer Correct Answer: C) A digit 0-9 with +/-sign. 14. Accurate, relevant, and timely ..... is the key to good decision making. A) Information. B) Processing. C) Data. D) Relationships. Show Answer Correct Answer: A) Information. 15. Which of the following is NOT a characteristic of a relation in a relational database? A) All data values in an attribute must be from the same domain. B) Each attribute has a unique name. C) Tuples can be ordered. D) Each tuple must be distinct. Show Answer Correct Answer: C) Tuples can be ordered. 16. Why we need database? A) To store a particular picture. B) To store a particular text. C) To store a particular collection of data. D) To store a particular audio. Show Answer Correct Answer: C) To store a particular collection of data. 17. What role does a DBMS play in e-commerce? A) A DBMS handles customer service inquiries directly. B) A DBMS only stores images for e-commerce websites. C) A DBMS is responsible for designing the website layout. D) A DBMS manages and organizes data for e-commerce operations, ensuring data integrity and facilitating transactions. Show Answer Correct Answer: D) A DBMS manages and organizes data for e-commerce operations, ensuring data integrity and facilitating transactions. 18. Which Codd's rule guarantees access to every data element? A) Rule 1-Information Rule. B) Rule 2-Guaranteed Access Rule. C) Rule 5-Powerful Language Rule. D) Rule 4-View Updating Rule. Show Answer Correct Answer: B) Rule 2-Guaranteed Access Rule. 19. What are the advantages of using a NoSQL database? A) Limited data types and structures. B) Strict schema requirements for data. C) Advantages of NoSQL databases include flexibility, scalability, high availability, and support for unstructured data. D) High cost of implementation. Show Answer Correct Answer: C) Advantages of NoSQL databases include flexibility, scalability, high availability, and support for unstructured data. 20. Which is NOT part of the database development process? A) Database planning. B) Data normalization. C) Software marketing. D) Database testing. Show Answer Correct Answer: C) Software marketing. 21. How does data independence improve maintenance in a DBMS? A) By requiring substantial alterations to programs for data changes. B) By increasing the complexity of the DBMS. C) By separating data descriptions from applications. D) By making applications dependent on data descriptions. Show Answer Correct Answer: C) By separating data descriptions from applications. 22. Which SQL command is used to update existing records in a table? A) UPDATE. B) MODIFY. C) CHANGE. D) ALTER. Show Answer Correct Answer: A) UPDATE. 23. Among the following computer system components, which one is responsible to manage and control the overall tasks in the computer system? A) Central processing unit (CPU). B) Operating system. C) High level languages. D) Application software. Show Answer Correct Answer: B) Operating system. 24. A company wants to merge two departments with different database structures. Which is the best approach? A) Use denormalization to combine all data in one table. B) Normalize both databases and integrate them with consistent keys. C) Store everything in spreadsheets first. D) Use only manual records. Show Answer Correct Answer: B) Normalize both databases and integrate them with consistent keys. 25. Which of the following operators is used to combine results from two queries, removing duplicates? A) JOIN. B) UNION. C) INTERSECT. D) MERGE. Show Answer Correct Answer: B) UNION. ← 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