This quiz works best with JavaScript enabled. Home > Class 12 > Class 12 Computer Science Chapter 3 Database Management Systems – Quiz 39 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 12 Computer Science Chapter 3 Database Management Systems Quiz 39 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Which key stoke moves the active cell towards left in Access table? A) F2. B) F5. C) Tab. D) Shift + Tab. Show Answer Correct Answer: D) Shift + Tab. 2. What is a primary use of a data warehouse? A) Managing daily transactions. B) Storing data for tactical or strategic decision-making. C) Handling customer service requests. D) Running payroll systems. Show Answer Correct Answer: B) Storing data for tactical or strategic decision-making. 3. Which SQL statement is used to create a view? A) CREATE VIEW. B) SELECT VIEW. C) MAKE VIEW. D) NEW VIEW. Show Answer Correct Answer: A) CREATE VIEW. 4. Which of the following is considered as DBMS? A) Oracle. B) FoxPro. C) Access. D) All of these. Show Answer Correct Answer: D) All of these. 5. Why do we convert many-to-many into one-to-many? A) To reduce tables. B) To avoid redundancy and improve relationships. C) To store more attributes. D) To simplify queries. Show Answer Correct Answer: B) To avoid redundancy and improve relationships. 6. What is the primary purpose of OLAP systems? A) To provide cloud-based services. B) To store unstructured data. C) To manage transactions. D) To analyze large volumes of data. Show Answer Correct Answer: D) To analyze large volumes of data. 7. What is meant by data redundancy? A) Data being deleted from the system. B) Duplication of data across different programs. C) Data being stored in a single location. D) Data being stored in multiple formats. Show Answer Correct Answer: B) Duplication of data across different programs. 8. What is the purpose of data constraints in a database? A) To increase data redundancy. B) To simplify data retrieval. C) To ensure data accuracy and reliability. D) To allow unlimited data entry. Show Answer Correct Answer: C) To ensure data accuracy and reliability. 9. Database management system is ..... software A) System. B) Relational. C) Application. D) Game. Show Answer Correct Answer: C) Application. 10. What is an ER diagram? A) A programming language. B) A pictorial representation of data. C) A file type. D) A type of database. Show Answer Correct Answer: B) A pictorial representation of data. 11. Which of the following software is appropriate to store data about school students? A) MS-Access. B) Writer. C) Calc. D) Impress. Show Answer Correct Answer: A) MS-Access. 12. MongoDB supports SQL queries. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 13. What is the purpose of a composite key in a relational schema? A) To define the structure of a table. B) To allow NULL values in a relation. C) To enforce referential integrity. D) To uniquely identify tuples using multiple attributes. Show Answer Correct Answer: D) To uniquely identify tuples using multiple attributes. 14. Which of the following is not involved in DBMS? A) End Users. B) Data. C) Application Request. D) HTML. Show Answer Correct Answer: D) HTML. 15. Which of the following is an example of a Data Definition Language (DDL) command? A) SELECT. B) UPDATE. C) CREATE. D) INSERT. Show Answer Correct Answer: C) CREATE. 16. Which is the example of File Based System? A) Using MySQL to find specific data. B) Using MS Access to control users access. C) Using spreadsheet software to manage data of employee. D) Using OpenOffice.org Base to create new table. Show Answer Correct Answer: C) Using spreadsheet software to manage data of employee. 17. The created database is listed using the ..... command. A) INSERT. B) USE. C) SHOW. D) UPDATE. Show Answer Correct Answer: C) SHOW. 18. What is the expansion of OLE in Access? A) Object linking and embedding. B) Object linking and encrypting. C) Object linking and editing. D) Object linking and encapsulation. Show Answer Correct Answer: A) Object linking and embedding. 19. What is the maximum length of the field name in Access? A) 16 characters. B) 32 characters. C) 64 characters. D) 128 characters. Show Answer Correct Answer: C) 64 characters. 20. This process of hiding the details of entities in the ER model is known as? A) Generalization. B) Abstraction. C) Specialization. D) None of these above. Show Answer Correct Answer: B) Abstraction. 21. In agricultural databases, which of the following data types would be suitable for soil pH values? A) Text. B) Number (Decimal). C) Date/Time. D) Memo. Show Answer Correct Answer: B) Number (Decimal). 22. What is SQL? A) Structured Query Language. B) Standard Query Language. C) Structural Query Language. D) Standardized Query Language. Show Answer Correct Answer: A) Structured Query Language. 23. Consider the following transactions with data items P and Q initialized to zero:T1:read (P) ; read (Q) ; if P = 0 then Q:= Q + 1 ; write (Q) ;T2:read (Q) ; read (P) ; if Q = 0 then P:= P + 1 ; write (P) ;Any non-serial interleaving of T1 and T2 for concurrent execution leads to A) A serializable schedule. B) A schedule that is not conflict serializable. C) A conflict serializable schedule. D) A schedule for which a precedence graph cannot be drawn. Show Answer Correct Answer: B) A schedule that is not conflict serializable. 24. Which DBMS does Adobe use to handle local data storage within its software? A) SQLite. B) MySQL. C) MongoDB. D) IBM Db2. Show Answer Correct Answer: A) SQLite. 25. ..... :Person responsible for technical management of databases. A) Database Administrator (DBA). B) Software Engineer. C) Network Analyst. D) System Operator. Show Answer Correct Answer: A) Database Administrator (DBA). ← 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