This quiz works best with JavaScript enabled. Home > Class 12 > Class 12 Computer Science Chapter 3 Database Management Systems – Quiz 8 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 12 Computer Science Chapter 3 Database Management Systems Quiz 8 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. In a ..... clustering index, the index record contains the search-key value and a pointer to the first data record with that search-key value and the rest of the records will be in the sequential pointers. A) Dense. B) Sparse. C) Straight. D) Continuous. Show Answer Correct Answer: A) Dense. 2. Which database view is used by users who input and view data? A) Physical view. B) Logical view. C) User view. D) None of the above. Show Answer Correct Answer: C) User view. 3. Which of the following is an advantage of using a DBMS? A) Improved data security. B) Increased data redundancy. C) Limited data accessibility. D) Decreased data consistency. Show Answer Correct Answer: A) Improved data security. 4. The number of attributes in a relation is called its: A) Cardinality. B) Degree. C) Tuple. D) Entity. Show Answer Correct Answer: B) Degree. 5. What is the primary purpose of a supertype/subtype relationship in an ERD? A) To normalize the database. B) To define unique keys. C) To handle data redundancy. D) To represent inheritance among entities. Show Answer Correct Answer: D) To represent inheritance among entities. 6. ..... :Protecting data by making it unreadable. A) Encryption. B) Decryption. C) Authentication. D) Compression. Show Answer Correct Answer: A) Encryption. 7. Which is correct for an Online Shop ERD? A) Customer-Many-to-Many-Product (through Orders). B) Customer-One-to-One-Order. C) Order-One-to-One-Product. D) Product-Recursive. Show Answer Correct Answer: A) Customer-Many-to-Many-Product (through Orders). 8. In a library system, a Book can be borrowed many times, and a Borrower can borrow many Books. What type of relationship best describes the connection between Book and Borrower? A) One-to-One. B) Many-to-Many. C) One-to-Many. D) Recursive. Show Answer Correct Answer: B) Many-to-Many. 9. What does a NULL constraint in SQL specify? A) The column must always have a numeric value. B) The column cannot have duplicate values. C) The column must not have any value. D) The column can have empty values. Show Answer Correct Answer: D) The column can have empty values. 10. What are the different normal forms in normalization? A) 1NF, 2NF, 3NF, BCNF, 4NF, 5NF. B) 1NF, 2NF, 3NF, 4NF, 6NF. C) 1NF+, 2NF+, 3NF+, 4NF+, 5NF+. D) 1NF, 2NF, 3NF, 4NF, 5NF, 6NF. Show Answer Correct Answer: A) 1NF, 2NF, 3NF, BCNF, 4NF, 5NF. 11. Which of the following is NOT typically managed by a Database Management System (DBMS)? A) Storage Manager. B) Query Manager. C) Transaction Manager. D) Internet Browsing History. Show Answer Correct Answer: D) Internet Browsing History. 12. What is a feature of files regarding layout? A) They require a server. B) They are always encrypted. C) They support complex queries. D) Everyone uses the same flat layout. Show Answer Correct Answer: D) Everyone uses the same flat layout. 13. What does the term 'data independence' refer to? A) The ability to change data without affecting applications. B) The ability to secure data from unauthorized access. C) The ability to store data in different formats. D) The ability to access data from multiple sources. Show Answer Correct Answer: A) The ability to change data without affecting applications. 14. Which validation rule accepts only a-z letters for fields in Access? A) Is null or NOT like "*[! a-z]*". B) Is null or NOT like "*[a-z ]*". C) Is null or NOT like "*![a-z]*". D) Is null or NOT like "[! a-z]". Show Answer Correct Answer: A) Is null or NOT like "*[! a-z]*". 15. Primary key does allow the Null Values, whereas in Unique key doesn't accept the Null values . True or False? A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 16. Which DBMS does Snapchat use for high-performance data handling? A) Redis. B) Google Cloud Spanner. C) Cassandra. D) Oracle Database. Show Answer Correct Answer: B) Google Cloud Spanner. 17. Kemampuan untuk memodifikasi skema di satu level tanpa mengubah skema di level selanjutnya yang lebih tinggi. A) Komitmen Data. B) Independensi Data. C) Kompetensi Data. D) Irasional Data. Show Answer Correct Answer: B) Independensi Data. 18. What is the main purpose of database prototyping? A) Reduce hardware cost. B) Improve user feedback early. C) Eliminate database design. D) Replace DBMS. Show Answer Correct Answer: B) Improve user feedback early. 19. What is the purpose of a composite key in a database? A) To enforce data integrity. B) To uniquely identify a record using multiple attributes. C) To link two tables together. D) To store large amounts of data. Show Answer Correct Answer: B) To uniquely identify a record using multiple attributes. 20. What is the primary purpose of a DBMS? A) To perform complex calculations on data. B) To create user interfaces for applications. C) To store, retrieve, and manage data in databases. D) To ensure data is visually appealing. Show Answer Correct Answer: C) To store, retrieve, and manage data in databases. 21. A database management system (DBMS) is primarily used to: A) Design websites. B) Store, organize, and manage data efficiently. C) Write programming languages. D) Create animations. Show Answer Correct Answer: B) Store, organize, and manage data efficiently. 22. Identify the procedure for acquiring the necessary locks for a transaction where all necessary locks are acquired before any are released? A) Record controller. B) Exclusive lock. C) Authorization rule. D) Two phase lock. Show Answer Correct Answer: D) Two phase lock. 23. Which of the following protocols ensures conflict serializability and safety from deadlocks? A) Two-phase locking protocol. B) Time-stamp ordering protocol. C) Graph based protocol. D) None of the mentioned. Show Answer Correct Answer: B) Time-stamp ordering protocol. 24. Which advantage of DBMS directly contributes to making better business decisions? A) Improved decision making. B) Improved data security. C) Better data integration. D) Minimized data inconsistency. Show Answer Correct Answer: A) Improved decision making. 25. Which of the following query is correct for using comparison operators in SQL? A) SELECT sname, coursename FROM studentinfo WHERE age>50 and <80;. B) SELECT sname, coursename FROM studentinfo WHERE age>50 and age <80;. C) SELECT sname, coursename FROM studentinfo WHERE age>50 and WHERE age<80;. D) None of the above. Show Answer Correct Answer: B) SELECT sname, coursename FROM studentinfo WHERE age>50 and age <80;. ← 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 9Class 12 Computer Science Chapter 3 Database Management Systems Quiz 10Class 12 Computer Science Chapter 3 Database Management Systems Quiz 11 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books