This quiz works best with JavaScript enabled. Home > Class 12 > Class 12 Computer Science Chapter 3 Database Management Systems – Quiz 17 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 12 Computer Science Chapter 3 Database Management Systems Quiz 17 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. In object oriented programming, which feature indicates the code reusability? A) Polymorphism. B) Encapsulation. C) Inheritance. D) Abstraction. Show Answer Correct Answer: C) Inheritance. 2. ..... specifies a search condition for a group or an aggregate. A) GROUP BY Clause. B) HAVING clause. C) FROM clause. D) WHERE clause. Show Answer Correct Answer: B) HAVING clause. 3. What is the main purpose of database testing? A) To increase data redundancy. B) To ensure data security. C) To validate data integrity and performance. D) To create new databases. Show Answer Correct Answer: C) To validate data integrity and performance. 4. What is the result of a query in MS Access? A) A new table. B) A report. C) A datasheet view. D) A form. Show Answer Correct Answer: C) A datasheet view. 5. Which of the following is NOT a type of database relationship? A) One-to-One. B) One-to-Many. C) Many-to-Many. D) One-to-None. Show Answer Correct Answer: D) One-to-None. 6. Before the used of database, organizations and individuals used ..... A) File Cabinets. B) File Systems. C) Printed Forms. D) Filing Systems. Show Answer Correct Answer: B) File Systems. 7. What does the GROUP BY clause do in SQL? A) It groups rows that have the same values in specified columns into summary rows. B) It filters records based on specified conditions. C) It joins two or more tables together. D) It sorts the result set in ascending order. Show Answer Correct Answer: A) It groups rows that have the same values in specified columns into summary rows. 8. A field which is ..... for each and every record is called Primary key. A) Common. B) Same. C) Unique. D) None of the above. Show Answer Correct Answer: C) Unique. 9. Which of the following is not valid field of table "Student" A) Admno. B) Name. C) Fees. D) Salary. Show Answer Correct Answer: D) Salary. 10. A completeness constraint may specify that each entity of the supertype must be a member of some subtype in the relationship. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 11. Which wildcard character matches any sequence of characters in SQL? A) %. B) . C) *. D) #. Show Answer Correct Answer: A) %. 12. What is the purpose of a data model in a database? A) To manage user permissions. B) To visualize data relationships. C) To encrypt sensitive information. D) To define how data is stored and accessed. Show Answer Correct Answer: D) To define how data is stored and accessed. 13. How do other data models differ from the relational model? A) Other data models use only flat files for storage. B) Other data models differ from the relational model in structure and data organization, such as using documents, key-value pairs, graphs, or columns instead of tables. C) Data models differ by using only spreadsheets for data management. D) Relational models are the only way to organize data. Show Answer Correct Answer: B) Other data models differ from the relational model in structure and data organization, such as using documents, key-value pairs, graphs, or columns instead of tables. 14. Consider attributes ID, CITY, and NAME. Which one if this can be considered as a primary key? A) NAME. B) ID. C) CITY. D) ID, NAME. Show Answer Correct Answer: B) ID. 15. Why is it important to use a DBMS to manage large sets of data? A) It makes data more secure, organized, and accessible. B) It creates faster internet speeds. C) It reduces the size of files on a computer. D) It helps design user interfaces for websites. Show Answer Correct Answer: A) It makes data more secure, organized, and accessible. 16. A single-user database that runs on a personal computer is called a(n) ..... database. A) Workgroup. B) Distributed. C) Enterprise. D) Desktop. Show Answer Correct Answer: D) Desktop. 17. If a business company wants its website to load faster by reducing image sizes, then what technique should they use? A) Remove all images from the website. B) Convert images to WebP format. C) Increase the image resolution. D) Use inline CSS for images. Show Answer Correct Answer: B) Convert images to WebP format. 18. Durability:Once a transaction commits, its changes ..... ? A) Cannot be lost. B) Can be reversed. C) Are temporary. D) May be lost. Show Answer Correct Answer: A) Cannot be lost. 19. NoSQL databases are less scalable than relational databases. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 20. The property by which subtype entities possess the values of all attributes of a supertype is called. A) Hierarchy reception. B) Class management. C) Multiple inheritance. D) Attribute inheritance. Show Answer Correct Answer: D) Attribute inheritance. 21. Which of the following best describes a homogeneous distributed database? A) A database system where different DBMSs are used across different sites. B) A system where database servers communicate via cloud computing. C) A database where data is stored in multiple backup locations. D) A distributed database where all sites use the same DBMS. Show Answer Correct Answer: D) A distributed database where all sites use the same DBMS. 22. What is a pitfall in relational database design? A) Complex data. B) Simple data. C) Unique data. D) Redundant data. Show Answer Correct Answer: D) Redundant data. 23. Data ..... helps ensure that an incorrect entry isn't made. A) Validation. B) Checks. C) Accuracy. D) Integrity. Show Answer Correct Answer: A) Validation. 24. A database can have only one table.(T/F) A) A. True. B) B. False. C) All the above. D) None of the above. Show Answer Correct Answer: B) B. False. 25. Which of the following is an example of a data integrity constraint? A) Data redundancy. B) Foreign key. C) Data inconsistency. D) Data duplication. Show Answer Correct Answer: B) Foreign key. ← 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