This quiz works best with JavaScript enabled. Home > Class 12 > Class 12 Computer Science Chapter 3 Database Management Systems – Quiz 32 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 12 Computer Science Chapter 3 Database Management Systems Quiz 32 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. As a programmer, you might use comments while writing the object oriented programming using Java. How could you express such comments in Java programming? A) % . B) /* */. C) # . D) / . Show Answer Correct Answer: B) /* */. 2. Which validation rule allows only 0-9 for fields in Access? A) Is Null or Not Like "*[ !0-9 ]*". B) Is Null or Not Like "[! 0-9]". C) Is Null or Not Like "*[0-9]*". D) Is Null or Not Like "*[!0-9]*". Show Answer Correct Answer: D) Is Null or Not Like "*[!0-9]*". 3. The process of defining a more general entity type from a set of more specialized entity types is called: A) Generalization. B) Specialization. C) Normalization. D) Extrapolation. Show Answer Correct Answer: A) Generalization. 4. What is the purpose of a surrogate key? A) To store large data. B) To link tables. C) To create indexes. D) To uniquely identify records. Show Answer Correct Answer: D) To uniquely identify records. 5. What is a primary key in a relational table? A) A unique identifier for each record. B) A foreign key from another table. C) A column containing duplicate values. D) A system-generated index. Show Answer Correct Answer: A) A unique identifier for each record. 6. Which one of the following attribute can be taken as a primary key? A) Name. B) Street. C) Id. D) Department. Show Answer Correct Answer: C) Id. 7. ..... :Client performs significant processing. A) Thick Client. B) Thin Client. C) Web Client. D) Remote Client. Show Answer Correct Answer: A) Thick Client. 8. What is the transformation process of data into information? A) Contextualisation, categorisation, calculation, correction, and condensation. B) Storing data in text files. C) Creating redundancy in data storage. D) Using paper-based filing systems. Show Answer Correct Answer: A) Contextualisation, categorisation, calculation, correction, and condensation. 9. Define entity integrity in the context of databases. A) Entity integrity requires foreign keys to be unique and not null. B) Entity integrity ensures that each row in a database table is uniquely identifiable through primary keys, which must be unique and not null. C) Entity integrity allows duplicate rows in a table. D) Entity integrity is concerned with the relationships between tables. Show Answer Correct Answer: B) Entity integrity ensures that each row in a database table is uniquely identifiable through primary keys, which must be unique and not null. 10. What is a key characteristic of high-quality data? A) Timely. B) Inaccessible. C) Ambiguous. D) Redundant. Show Answer Correct Answer: A) Timely. 11. ..... is named collection of data items which represents a complete unit of information. A) Field. B) Record. C) Table. D) Data base. Show Answer Correct Answer: B) Record. 12. Why might there be multiple external views in a database system? A) To allow different users to see or view their data based on their requirements. B) To increase the speed of data processing. C) To reduce storage space. D) To encrypt all data. Show Answer Correct Answer: A) To allow different users to see or view their data based on their requirements. 13. What is the main advantage of database normalization? A) The main advantage of database normalization is to reduce data redundancy and improve data integrity. B) Simplifies complex queries and enhances performance. C) Increases data duplication and decreases data integrity. D) Eliminates the need for data backups and recovery. Show Answer Correct Answer: A) The main advantage of database normalization is to reduce data redundancy and improve data integrity. 14. Data ..... exists when the same data are stored unnecessarily at different places. A) Dependency. B) Redundancy. C) Inconsistency. D) Fragmentation. Show Answer Correct Answer: B) Redundancy. 15. What is the purpose of a data model in a DBMS? A) To provide a user interface for data entry. B) To ensure data is encrypted at all times. C) The purpose of a data model in a DBMS is to define the structure, relationships, and constraints of data. D) To store data in a flat file format. Show Answer Correct Answer: C) The purpose of a data model in a DBMS is to define the structure, relationships, and constraints of data. 16. What is a common method for testing a database? A) Data redundancy testing. B) Data integrity testing. C) Data deletion testing. D) Data duplication testing. Show Answer Correct Answer: B) Data integrity testing. 17. Which of the following is a valid time format is Access? A) Hh:mm:ss AM/PM. B) Hh.mm.ss AM/PM. C) Hh-mm-ss AM/PM. D) Hh/mm/ss AM/PM. Show Answer Correct Answer: A) Hh:mm:ss AM/PM. 18. What is the difference between a database schema and a database instance? A) A schema is a dynamic state, while an instance is a static definition. B) A schema is the actual data in the database, while an instance is the data's definition. C) A schema describes the database's structure, while an instance is the data at a particular moment in time. D) A schema is only used in RDBMS, while an instance is only used in file systems. Show Answer Correct Answer: C) A schema describes the database's structure, while an instance is the data at a particular moment in time. 19. What is the Foreign key? A) A foreign key is a column which is added to create a relationship with another table. B) Foreign keys help us to maintain data integrity. C) Every relationship in the model needs to be supported by a foreign key. D) All of the above. Show Answer Correct Answer: D) All of the above. 20. Which type of relationship exists when one row in a table can be associated with many rows in another table? A) One-to-one. B) One-to-many. C) Many-to-many. D) Self-referential. Show Answer Correct Answer: B) One-to-many. 21. Which of the following keys is generally used to represents the relationships between the tables? A) Primary key. B) Foreign key. C) Secondary key. D) None of the above. Show Answer Correct Answer: B) Foreign key. 22. ..... :Presentation, application, and database layers. A) Three-Tier Architecture. B) Client-Server Model. C) Monolithic Architecture. D) Microservices Architecture. Show Answer Correct Answer: A) Three-Tier Architecture. 23. List and explain three types of constraints in SQL. A) DEFAULT. B) INDEX. C) PRIMARY KEY, FOREIGN KEY, CHECK. D) UNIQUE. Show Answer Correct Answer: C) PRIMARY KEY, FOREIGN KEY, CHECK. 24. Database is an orderly collection of data A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 25. Consists of multiple tables of information related to common fields. A) Relational Database. B) Big Data. C) Data Integrity. D) Database Management Systems. Show Answer Correct Answer: A) Relational 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