This quiz works best with JavaScript enabled. Home > Class 12 > Class 12 Computer Science Chapter 3 Database Management Systems – Quiz 52 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 12 Computer Science Chapter 3 Database Management Systems Quiz 52 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What does the COUNT function do in SQL? A) It counts the number of rows in a table. B) It sorts the result set in ascending order. C) It filters records based on specified conditions. D) It retrieves unique values from a column. Show Answer Correct Answer: A) It counts the number of rows in a table. 2. What are the advantages of using stored procedures for query optimization? A) Stored procedures improve performance through pre-compilation, reduced network traffic, and better execution plan reuse. B) Stored procedures eliminate the need for indexing completely. C) Stored procedures increase data redundancy and complexity. D) Stored procedures require more manual coding for each query. Show Answer Correct Answer: A) Stored procedures improve performance through pre-compilation, reduced network traffic, and better execution plan reuse. 3. Which one of the following OSI layer is responsible if the website loads slowly but the network connection is stable? A) Application layer. B) Physical layer. C) Network layer. D) Transport layer. Show Answer Correct Answer: A) Application layer. 4. How does denormalization affect database performance? A) Denormalization can improve read performance but may negatively impact write performance due to increased redundancy. B) Denormalization eliminates redundancy in the database. C) Denormalization has no effect on database performance. D) Denormalization only improves write performance without affecting reads. Show Answer Correct Answer: A) Denormalization can improve read performance but may negatively impact write performance due to increased redundancy. 5. How do transactions ensure data consistency in a DBMS? A) Transactions ensure data consistency through ACID properties. B) Transactions are only for data retrieval, not consistency. C) Data consistency is achieved through user permissions. D) Transactions rely solely on backup systems. Show Answer Correct Answer: A) Transactions ensure data consistency through ACID properties. 6. Which type of user would be responsible for managing the database schema? A) End user. B) Database administrator. C) System designer. D) Application developer. Show Answer Correct Answer: B) Database administrator. 7. A file system suffers from which of the following limitations? A) Lack of data redundancy. B) Data inconsistency. C) Easy data sharing. D) Simplicity of structure. Show Answer Correct Answer: B) Data inconsistency. 8. Which DBMS function is responsible for storing data and related data entry forms, report definitions, etc.? A) Data storage management. B) Data encryption. C) Data analysis. D) Data visualization. Show Answer Correct Answer: A) Data storage management. 9. Sistem ..... yang selalu meningkatkan kebutuhan perubahan tiap waktu. A) Proteksi. B) Maintain. C) Reset. D) Format. Show Answer Correct Answer: B) Maintain. 10. What is TRUE about Relational Data Model? A) Tables are used in relational models to represent data and the relationships between them. B) Edgar F. Codd presented this model in 1969. C) Most commercial data processing applications use the relational data model. D) All of the above. Show Answer Correct Answer: D) All of the above. 11. What is the difference between a unique constraint and a primary key? A) A primary key can have duplicate values, while a unique constraint cannot. B) A primary key cannot be null and uniquely identifies records, while a unique constraint can allow nulls and ensures uniqueness. C) Both primary keys and unique constraints can be null. D) A unique constraint is used for foreign keys, while a primary key is not. Show Answer Correct Answer: B) A primary key cannot be null and uniquely identifies records, while a unique constraint can allow nulls and ensures uniqueness. 12. Explain the concept of foreign keys and their purpose. A) Foreign keys are used to enforce referential integrity between tables in a relational database. B) Foreign keys are primarily for data encryption. C) Foreign keys are used to store large binary files. D) Foreign keys are used to create indexes on tables. Show Answer Correct Answer: A) Foreign keys are used to enforce referential integrity between tables in a relational database. 13. What is a distributed database? A) A database that only supports local access. B) A single logical database spread across multiple locations. C) A database that cannot be customized. D) A database stored in a single location. Show Answer Correct Answer: B) A single logical database spread across multiple locations. 14. What is the E-R model used for? A) The E-R model is used for web development. B) The E-R model is used for graphic design. C) The E-R model is used for project management. D) The E-R model is used for database design and visualization. Show Answer Correct Answer: D) The E-R model is used for database design and visualization. 15. SELECT dept ..... name, ID, avg (salary)FROM instructorGROUP BY dept ..... name;This statement IS erroneous because A) Avg(salary) should not be selected. B) Dept id should not be used in group by clause. C) Misplaced group by clause. D) Group by clause is not valid in this query. Show Answer Correct Answer: B) Dept id should not be used in group by clause. 16. To remove a table structure from an SQL database, we use the ..... command. A) Delete. B) Purge. C) Remove. D) Drop table. Show Answer Correct Answer: D) Drop table. 17. Why is it only possible to access database files through the DBMS? A) Because the DBMS provides security and structure for accessing data. B) Because the files are stored in a cloud server. C) Because the database files are encrypted by default. D) Because the DBMS is a physical storage device. Show Answer Correct Answer: A) Because the DBMS provides security and structure for accessing data. 18. Which of the following will help to maintain unique record in the table? A) Foreign Key. B) Primary Key. C) Composite Key. D) Alternate Key. Show Answer Correct Answer: B) Primary Key. 19. Server Role:Stores data and runs the ..... A) DBMS. B) CPU. C) RAM. D) OS. Show Answer Correct Answer: A) DBMS. 20. Which of the following are valid levels of access? A) Read and change. B) Read only, edit, delete and append. C) Administrator and change. D) None of the above. Show Answer Correct Answer: B) Read only, edit, delete and append. 21. The following are functions of a DBMS except A) Creating database. B) Processing data. C) Creating and processing forms. D) Administrating database. Show Answer Correct Answer: C) Creating and processing forms. 22. What does local autonomy in a distributed database refer to? A) The need for constant data replication. B) The requirement to always connect to a central server. C) The ability to operate independently when connections fail. D) The inability to manage local databases. Show Answer Correct Answer: C) The ability to operate independently when connections fail. 23. Who developed the first database management system? A) Larry Page. B) Steve Jobs. C) Bill Gates. D) Charles Bachman. Show Answer Correct Answer: D) Charles Bachman. 24. What is the purpose of the SELECT operation in relational algebra? A) Combine rows from different tables. B) Filter rows based on a condition. C) Add new records to a table. D) Sort the table in ascending order. Show Answer Correct Answer: B) Filter rows based on a condition. 25. What is Database Management System? A) A software system that enables users to access to the database. B) A software system that enables users to create access to the database. C) A software system that enables users to define, create, maintain and control access to the database. D) A software system that enables users to maintain and control access to the database. Show Answer Correct Answer: C) A software system that enables users to define, create, maintain and control access to the database. ← 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