This quiz works best with JavaScript enabled. Home > Class 12 > Class 12 Computer Science Chapter 3 Database Management Systems – Quiz 55 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 12 Computer Science Chapter 3 Database Management Systems Quiz 55 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What is a collection of concepts that can be used to describe the structure of a database? A) Data Model. B) Schema. C) Instance. D) None of the above. Show Answer Correct Answer: A) Data Model. 2. What are the advantages of using a DBMS over traditional file systems? A) Increased file size management. B) Simplified data storage without security features. C) Limited data access for multiple users. D) Advantages of using a DBMS over traditional file systems include improved data integrity, security, reduced redundancy, support for complex queries, concurrent access, and better backup and recovery options. Show Answer Correct Answer: D) Advantages of using a DBMS over traditional file systems include improved data integrity, security, reduced redundancy, support for complex queries, concurrent access, and better backup and recovery options. 3. Which of the following SQL query is correct for selecting the name of staffs from 'tblstaff' table where salary is 15, 000 or 25, 000? A) SELECT sname from tblstaff WHERE salary IN (15000, 25000);. B) SELECT sname from tblstaff WHERE salary BETWEEN 15000 AND 25000;. C) Both a and b. D) None of the above. Show Answer Correct Answer: A) SELECT sname from tblstaff WHERE salary IN (15000, 25000);. 4. The term "data independence" in DBMS refers to: A) The separation of data from the applications. B) The ability to store data offline. C) Data stored in multiple locations. D) Data that does not change over time. Show Answer Correct Answer: A) The separation of data from the applications. 5. Why is it important for information to be accurate, relevant, and timely in organizations? A) To ensure that data is stored in flat files. B) To make good decisions that affect the organization. C) To increase the number of file folders. D) To reduce the need for computer models. Show Answer Correct Answer: B) To make good decisions that affect the organization. 6. Which of the following is NOT a type of SQL operation? A) COMPILE. B) INSERT. C) DELETE. D) SELECT. Show Answer Correct Answer: A) COMPILE. 7. What is a key feature of relational DBMS? A) Tables with relationships B) Single file storage C) No data relationships D) Only text data A) A) Tables with relationships. B) Flat file storage. C) No relationships between data. D) Only numeric data. Show Answer Correct Answer: A) A) Tables with relationships. 8. Which of the following is an example of a Database-System Application? A) Word Processor. B) Web Browser. C) Inventory Management System. D) Photo Editing Software. Show Answer Correct Answer: C) Inventory Management System. 9. Among the following Operating Systems, which one describes the first operating systems for the personal computer that could be operated using the command prompt? A) Macintosh operating system (MacOS). B) Disk Operating System (DOS). C) Windows operating system. D) Linux operating system. Show Answer Correct Answer: B) Disk Operating System (DOS). 10. Which of the following describes the 'conceptual' level in the three-schema architecture? A) It details how data is physically stored on disk, including file organizations and indexes. B) It defines the overall logical structure of the database for the entire organization. C) It provides a customized view of the data for a specific user or application. D) It manages the security and access permissions of all users. Show Answer Correct Answer: B) It defines the overall logical structure of the database for the entire organization. 11. How does the JOIN operation in relational algebra work? A) Concatenates two tables vertically. B) Combines rows from two tables based on a common attribute. C) Creates a new table with only unique values. D) Removes unwanted columns from a table. Show Answer Correct Answer: B) Combines rows from two tables based on a common attribute. 12. In an ERD, what do 'attributes' describe about an entity? A) The relationships it has with other entities. B) The cardinality of its relationships. C) The properties or characteristics of the entity. D) The unique identifier for the entity. Show Answer Correct Answer: C) The properties or characteristics of the entity. 13. A SELECT command without a WHERE clause returns? A) All records from a table that match the previous WHERE clause. B) All the records from a table, or information about all the records. C) SELECT is invalid without a Where clause. D) Nothing. Show Answer Correct Answer: B) All the records from a table, or information about all the records. 14. Which of the following is a type of NoSQL database? A) MySQL. B) PostgreSQL. C) SQLite. D) MongoDB. Show Answer Correct Answer: D) MongoDB. 15. What is the recommended practice for naming tables in a database? A) Tables should be named in plural form. B) Tables should be named in singular form. C) Tables should include numerals. D) Tables should use multiple words without linking. Show Answer Correct Answer: B) Tables should be named in singular form. 16. Which DBMS is known for its open-source flexibility and is widely used by Wikipedia? A) MySQL. B) MariaDB. C) Oracle Database. D) PostgreSQL. Show Answer Correct Answer: B) MariaDB. 17. Which of the following is a result of reduced data dependence and reduced structural dependence? A) Reduced program maintenance. B) Increased data redundancy. C) Decreased data sharing. D) Increased structural dependence. Show Answer Correct Answer: A) Reduced program maintenance. 18. What is the primary purpose of database transaction isolation? A) To prevent data loss. B) To ensure transactions do not interfere with each other. C) To reduce database complexity. D) To speed up data processing. Show Answer Correct Answer: B) To ensure transactions do not interfere with each other. 19. What are the main types of DBMS? A) Graph, Time-series, Spatial. B) Flat-file, Key-value, Document-oriented. C) Hierarchical, Network, Relational, Object-oriented, NoSQL. D) In-memory, Distributed, Columnar. Show Answer Correct Answer: C) Hierarchical, Network, Relational, Object-oriented, NoSQL. 20. What will be the output of the following SQL query? SELECT COUNT (*) FROM Employees WHERE Salary > 50000; A) The total salary of employees earning more than 50, 000. B) The number of employees earning more than 50, 000. C) The number of employees in the Employees table. D) The maximum salary in the Employees table. Show Answer Correct Answer: B) The number of employees earning more than 50, 000. 21. Which of the following is not an Schema? A) Database Schema. B) Physical Schema. C) Critical Schema. D) Logical Schema. Show Answer Correct Answer: C) Critical Schema. 22. What should you do to ensure that the requested records meet your needs? A) Save or print the records immediately. B) Check if the results are what you asked for. C) Log out to keep the system secure. D) Add new search filters without looking at the results. Show Answer Correct Answer: B) Check if the results are what you asked for. 23. How does a DBMS improve data accessibility and responsiveness? A) By requiring users to write their own query languages. B) By limiting the functionality available to end-users. C) By allowing end-users to ask ad hoc questions and obtain information quickly. D) By providing a view mechanism to simplify data. Show Answer Correct Answer: C) By allowing end-users to ask ad hoc questions and obtain information quickly. 24. In a supertype/subtype hierarchy, each subtype has: A) Only one supertype. B) Many supertypes. C) At most two supertypes. D) At least one subtype. Show Answer Correct Answer: A) Only one supertype. 25. Which statement is true about the following diagram? A) A person can only be a faculty, student, or staff. B) A student can be both an undergraduate and a graduate student at the same time. C) All attributes of person and student are inherited by undergraduate. D) All attributes of graduate are inherited by person. Show Answer Correct Answer: A) A person can only be a faculty, student, or staff. ← 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