This quiz works best with JavaScript enabled. Home > Class 12 > Class 12 Computer Science Chapter 3 Database Management Systems – Quiz 16 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 12 Computer Science Chapter 3 Database Management Systems Quiz 16 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. How to select all data from studentinfo table starting the name from letter 'r'? A) SELECT * FROM studentinfo WHERE sname LIKE 'r%'. B) SELECT * FROM studentinfo WHERE sname LIKE '%r%'. C) SELECT * FROM studentinfo WHERE sname LIKE '%r'. D) SELECT * FROM studentinfo WHERE sname LIKE ' r%'. Show Answer Correct Answer: A) SELECT * FROM studentinfo WHERE sname LIKE 'r%'. 2. In a relational database, a tuple represents: A) A row in a table. B) A column in a table. C) A relationship between tables. D) A set of constraints. Show Answer Correct Answer: A) A row in a table. 3. What is a single row of a table called? A) Attribute. B) Record. C) Column. D) Tuple. Show Answer Correct Answer: D) Tuple. 4. What is one key advantage of a database? A) It slows down data retrieval. B) It enables fast retrieval of information. C) It requires a manual process to update data. D) It is only useful for small data sets. Show Answer Correct Answer: B) It enables fast retrieval of information. 5. Which of the following data independence types refers to immunity of application programs to changes in physical storage structure? A) Logical data independence. B) Physical data independence. C) Conceptual data independence. D) External data independence. Show Answer Correct Answer: B) Physical data independence. 6. ..... is a key uniquely identifies a record in a table. A) Primary key. B) Candidate key. C) Alternate key. D) None of the above. Show Answer Correct Answer: A) Primary key. 7. What is the main purpose of a DBMS? A) To create video games. B) To manage and control access to a database. C) To design websites. D) To write software programs. Show Answer Correct Answer: B) To manage and control access to a database. 8. EBay uses Neo4j primarily for improving which of the following? A) Transactional speed. B) Product recommendations. C) User security. D) Marketing automation. Show Answer Correct Answer: B) Product recommendations. 9. What is a disadvantage of paper-based systems? A) Difficult to search B) Easy to store C) Low cost D) High durability A) Requires no physical space. B) Highly accessible online. C) Time-consuming to update. D) A) Difficult to search. Show Answer Correct Answer: D) A) Difficult to search. 10. What is the purpose of backup and recovery management in a DBMS? A) To enhance data redundancy. B) To ensure data safety and integrity. C) To manage hardware resources. D) To create user interfaces. Show Answer Correct Answer: B) To ensure data safety and integrity. 11. Jennifer is creating a database for several customers. How will she list the Customer ID? A) Yes/No. B) Data. C) Number. D) Currency. Show Answer Correct Answer: C) Number. 12. What must be common between two tables to create a relationship? A) Fields. B) Characters. C) Files. D) Names. Show Answer Correct Answer: A) Fields. 13. In a database system, the primary function of a DBMS is to: A) Create, modify, and delete data structures. B) Control concurrency of operations. C) Manage data storage and retrieval. D) Provide network services. Show Answer Correct Answer: C) Manage data storage and retrieval. 14. When primary key is made up of two or more columns then it is called ..... primary key. A) Mixed. B) Reference. C) Composite. D) Compost. Show Answer Correct Answer: C) Composite. 15. What is the difference between a primary key and a unique key? A) Both primary key and unique key are the same. B) A primary key can be composed of multiple columns, while a unique key cannot. C) A primary key uniquely identifies a record in a table, while a unique key ensures all values in a column are different. D) A primary key can accept null values, while a unique key cannot. Show Answer Correct Answer: C) A primary key uniquely identifies a record in a table, while a unique key ensures all values in a column are different. 16. Which type of data can be stored in the database? A) Image oriented data. B) Text, files containing data. C) Data in the form of audio or video. D) All of the above. Show Answer Correct Answer: D) All of the above. 17. What is a disadvantage of file-based systems? A) Data redundancy B) Easy access C) Low cost D) High performance A) Centralized control. B) Data integrity. C) A) Data redundancy. D) User-friendly interface. Show Answer Correct Answer: C) A) Data redundancy. 18. Which of the following is a key feature of a DBMS? A) Data integrity enforcement. B) Automatic software updates. C) File compression. D) Only storing unstructured data. Show Answer Correct Answer: A) Data integrity enforcement. 19. In MS Access, which feature helps generate printable summaries and formatted outputs of agricultural data? A) Queries. B) Reports. C) Tables. D) Relationships. Show Answer Correct Answer: B) Reports. 20. Where is DBMS commonly used? A) Banking systems B) Cooking recipes C) Painting D) Gardening A) A) Banking systems. B) F) Fashion design. C) E) Video games. D) G) Sports analytics. Show Answer Correct Answer: A) A) Banking systems. 21. Which component manages how data is physically stored and accessed? A) Query Processor. B) Transaction Manager. C) Storage Manager. D) Compiler. Show Answer Correct Answer: C) Storage Manager. 22. Which of the following best defines data integrity in a DBMS? A) Accuracy and consistency of data over its lifecycle. B) Ability to generate reports. C) A feature that prevents database updates. D) A function that speeds up queries. Show Answer Correct Answer: A) Accuracy and consistency of data over its lifecycle. 23. What does the DataGridView control do? A) Displays data in a scrollable grid. B) Connects to a data source. C) Creates a new database. D) Saves data to a file. Show Answer Correct Answer: A) Displays data in a scrollable grid. 24. Who is responsible for defining user access and recovery plans? A) Naive User. B) Online User. C) Application Developer. D) Database Administrator (DBA). Show Answer Correct Answer: D) Database Administrator (DBA). 25. What is the purpose of the CREATE TABLE statement in SQL? A) To retrieve data from a table. B) To modify an existing table's structure. C) To delete a table from the database. D) To define a new table and its structure in the database. Show Answer Correct Answer: D) To define a new table and its structure in 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