This quiz works best with JavaScript enabled. Home > Cbse > Class 12 > Science > Computer Science > Class 12 Computer Science Chapter 3 Database Management Systems – Quiz 1 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 12 Computer Science Chapter 3 Database Management Systems Quiz 1 (60 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. ..... :Rules that ensure data accuracy. A) Normalization. B) Primary Keys. C) Foreign Keys. D) Integrity Constraints. Show Answer Correct Answer: D) Integrity Constraints. 2. In MS Access, which object is used to retrieve and analyze data? A) Query. B) Report. C) Table. D) Form. Show Answer Correct Answer: A) Query. 3. Which of the following is a front-end database component? A) APIs. B) Server-Side Logic. C) User Interface (UI). D) Database Management. Show Answer Correct Answer: C) User Interface (UI). 4. What is a report in MS Access used for? A) To present data in a printable format. B) To delete records. C) To input data. D) To modify database structure. Show Answer Correct Answer: A) To present data in a printable format. 5. What does normalization in a database refer to? A) Reducing data redundancy. B) Enhancing data security. C) Increasing data duplication. D) Creating backup copies. Show Answer Correct Answer: A) Reducing data redundancy. 6. Which DBMS is used by Uber for real-time tracking of rides? A) Cassandra. B) MongoDB. C) SQLite. D) Neo4j. Show Answer Correct Answer: B) MongoDB. 7. What practice is crucial for maintaining the confidentiality of patient records in a hospital's database? A) Sharing passwords among staff. B) Implementing strong access controls and encryption. C) Allowing open access to all hospital staff. D) Storing data in plain text for easy access. Show Answer Correct Answer: B) Implementing strong access controls and encryption. 8. In an ER diagram, a diamond shape is used to represent a: A) Entity. B) Key. C) Relationship. D) Attribute. Show Answer Correct Answer: C) Relationship. 9. Suppose a company wants to add a new field to its employee records. What is a likely consequence in a traditional file system? A) No changes are needed to application programs. B) All application programs using the file must be modified and recompiled. C) The new field is automatically added to all records. D) The file system updates itself. Show Answer Correct Answer: B) All application programs using the file must be modified and recompiled. 10. What is a normalization process in databases? A) Creating backups. B) Reducing redundancy. C) Combining tables. D) Encrypting data. Show Answer Correct Answer: B) Reducing redundancy. 11. What is the purpose of the JOIN clause in SQL? A) To create a new table in the database. B) To filter records based on specified conditions. C) To combine rows from two or more tables based on a related column. D) To sort the result set in ascending order. Show Answer Correct Answer: C) To combine rows from two or more tables based on a related column. 12. What is denormalization? A) Denormalization is the process of removing redundancy from a database. B) Denormalization refers to the normalization of data in a database. C) Denormalization is a method to encrypt sensitive data in a database. D) Denormalization is the process of optimizing the read performance of a database by intentionally introducing redundancy into the data. Show Answer Correct Answer: D) Denormalization is the process of optimizing the read performance of a database by intentionally introducing redundancy into the data. 13. Describe the process of converting a database to 3NF. A) The process involves ensuring the database is in 2NF, identifying functional dependencies, removing transitive dependencies, creating new tables, and establishing foreign key relationships. B) 3NF can be achieved by simply deleting all duplicate records. C) The process involves merging all tables into one. D) Converting a database to 3NF requires only adding indexes. Show Answer Correct Answer: A) The process involves ensuring the database is in 2NF, identifying functional dependencies, removing transitive dependencies, creating new tables, and establishing foreign key relationships. 14. What is the primary function of a foreign key in a database? A) To encrypt sensitive information. B) To store large amounts of data. C) To establish a relationship between two tables. D) To uniquely identify a record. Show Answer Correct Answer: C) To establish a relationship between two tables. 15. Which of the following is not a function of DML? A) INSERT. B) ALTER TABLE. C) DELETE. D) UPDATE. Show Answer Correct Answer: B) ALTER TABLE. 16. What is the Compound key? A) Compound key has many fields which allow you to uniquely recognize a specific record. B) Each column may not be unique by itself within the database. C) The combination of composite keys become unique. D) All of the above. Show Answer Correct Answer: D) All of the above. 17. What is the purpose of the INDEX keyword in SQL? A) To create a backup of the database. B) To enhance the performance of queries by allowing faster data retrieval. C) To define a new table in a database. D) To delete records from a table. Show Answer Correct Answer: B) To enhance the performance of queries by allowing faster data retrieval. 18. The ..... clause allows us to select only those rows in the result which that satisfy a specified condition/predicate. A) Having. B) Select. C) Where. D) From. Show Answer Correct Answer: C) Where. 19. In the figure below, the patient must be either an outpatient or a resident patient. This is an example of the ..... rule. A) Specialization. B) Generalization. C) Disjoint. D) Overlap. Show Answer Correct Answer: C) Disjoint. 20. What ensures foreign keys match with primary keys or are NULL? A) Domain Constraint. B) Referential Integrity. C) Atomic Constraint. D) Entity Integrity. Show Answer Correct Answer: B) Referential Integrity. 21. An attribute of the supertype that determines the target subtype(s) is called the: A) Subtype decision. B) Disjoint indicator. C) Determinant. D) Subtype discriminator. Show Answer Correct Answer: D) Subtype discriminator. 22. What is the result of a union operation in relational algebra? A) Finds common records. B) Combines two relations. C) Renames a relation. D) Subtracts one relation from another. Show Answer Correct Answer: B) Combines two relations. 23. What is the main purpose of AJAX in web development? A) Encrypt web traffic. B) Load data asynchronously without reloading the page. C) Validate form data. D) Improve website aesthetics. Show Answer Correct Answer: B) Load data asynchronously without reloading the page. 24. Microsoft Access is most commonly used by which of the following? A) Large retail chains. B) Small businesses. C) Airlines. D) E-commerce websites. Show Answer Correct Answer: B) Small businesses. 25. ..... :Protecting personal and sensitive data. A) Encryption. B) Privacy. C) Authentication. D) Backup. Show Answer Correct Answer: B) Privacy. 26. What does ER stand for in ER Model? A) Entity Report. B) Entity Relationship. C) Entity Real. D) Entity Relation. Show Answer Correct Answer: B) Entity Relationship. 27. What do relational databases tend to have in common? A) Fields. B) Indexes. C) Records. D) Primary keys. Show Answer Correct Answer: D) Primary keys. 28. The model that uses tables with rows and columns is called: A) Object-Oriented Model. B) Relational Model. C) Hierarchical Model. D) Network Model. Show Answer Correct Answer: B) Relational Model. 29. Which of the following is NOT a feature of a DBMS? A) Hardware management. B) User authentication. C) Network configuration. D) Data encryption. Show Answer Correct Answer: A) Hardware management. 30. In E-R diagram an entity set is represented by a A) Circle. B) Rectangle. C) Ellipse. D) Diamond box. Show Answer Correct Answer: B) Rectangle. 31. What is the main advantage of using a DBMS? A) Higher costs. B) Centralized data management. C) Manual data processing. D) Increased data redundancy. Show Answer Correct Answer: B) Centralized data management. 32. What transforms raw data into meaningful information? A) Computational processing. B) Contextualisation and analysis. C) Storage techniques. D) Database design. Show Answer Correct Answer: B) Contextualisation and analysis. 33. The following figure is an example of total specialization. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 34. What is the result of the following SQL statement? SELECT * FROM employees WHERE age > 30; A) All employees. B) Employees older than 30. C) Employees younger than 30. D) All employees exactly 30 years old. Show Answer Correct Answer: B) Employees older than 30. 35. A collection of related data. A) Database. B) Information. C) Metadata. D) Valuable information. Show Answer Correct Answer: A) Database. 36. Define primary key in a relational database. A) A primary key is a unique identifier for a record in a relational database table. B) A primary key is an optional field in a database table. C) A primary key is a foreign key in another table. D) A primary key can contain duplicate values. Show Answer Correct Answer: A) A primary key is a unique identifier for a record in a relational database table. 37. What is the purpose of the TRUNCATE statement in SQL? A) To update existing records in a table. B) To create a new table in the database. C) To delete a specific record from a table. D) To remove all records from a table without logging individual row deletions. Show Answer Correct Answer: D) To remove all records from a table without logging individual row deletions. 38. Which of the following is a common use of a database index? A) To increase data redundancy. B) To store large amounts of data. C) To manage user permissions. D) To speed up data retrieval. Show Answer Correct Answer: D) To speed up data retrieval. 39. A company restricts salary updates to managers only. Which feature ensures this? A) Metadata. B) Authorization. C) Normalization. D) Indexing. Show Answer Correct Answer: B) Authorization. 40. Which language is used for defining and manipulating data in a relational database? A) Python. B) C++. C) SQL. D) Java. Show Answer Correct Answer: C) SQL. 41. List three advantages of using a DBMS. A) High cost, complex data management, and data inconsistency. B) Data security, data integrity, and efficient data retrieval. C) Data duplication, slow data retrieval, and data insecurity. D) Limited storage capacity, data redundancy, and slow data processing. Show Answer Correct Answer: B) Data security, data integrity, and efficient data retrieval. 42. In a car rental system, a CUSTOMER can rent many CARS, and a CAR can be rented by many CUSTOMERS. Which relationship best shows this? A) A one-to-one relationship between CUSTOMER and RENTAL. B) A one-to-many relationship between CAR and RENTAL. C) A one-to-many relationship between CUSTOMER and RENTAL. D) A many-to-many relationship between CUSTOMER and CAR. Show Answer Correct Answer: D) A many-to-many relationship between CUSTOMER and CAR. 43. As the number of files increases in a file system, what happens to system administration? A) It becomes easier. B) It remains unchanged. C) It becomes more complex and difficult. D) It eliminates the need for report generation. Show Answer Correct Answer: C) It becomes more complex and difficult. 44. Which DBMS is used by Spotify to store and retrieve music metadata quickly? A) PostgreSQL. B) SAP HANA. C) Microsoft SQL Server. D) HBase. Show Answer Correct Answer: D) HBase. 45. What is the full form of DBMS? A) Data of Binary Management System. B) Database Management System. C) Data Backup Management System. D) Database Management Service. Show Answer Correct Answer: B) Database Management System. 46. ..... is a set of one or more attributes taken collectively to uniquely identify a row/record in a table. A) Primary Key. B) Foreign key. C) Super key. D) Candidate key. Show Answer Correct Answer: A) Primary Key. 47. If you were collecting and storing information about your music collection, an album would be considered a(n) ..... A) Entity. B) Attribute. C) Relation. D) Instance. Show Answer Correct Answer: A) Entity. 48. Why should Students and Courses be in separate tables? A) To avoid repeating course names for every student. B) To reduce number of tables. C) To remove primary keys. D) To allow redundancy. Show Answer Correct Answer: A) To avoid repeating course names for every student. 49. Which type of architecture is best for large-scale web applications? A) 1-Tier. B) Single User. C) 2-Tier. D) 3-Tier. Show Answer Correct Answer: D) 3-Tier. 50. In packaged data models, strong entities always have ..... between them. A) 1:M relationships. B) 1:1 relationships. C) Weak entities. D) M:N relationships. Show Answer Correct Answer: D) M:N relationships. 51. The USE command? A) Is used to load code from another file. B) Has been deprecated and should be avoided for security reasons. C) Is a pseudo name for the SELECT command. D) Should be used to choose the database you want to use once you've connected to MySQL. Show Answer Correct Answer: D) Should be used to choose the database you want to use once you've connected to MySQL. 52. Identify the encryption type that uses the same key for both encryption and decryption. A) Public-key encryption. B) Hashing. C) Symmetric encryption. D) Asymmetric encryption. Show Answer Correct Answer: C) Symmetric encryption. 53. Graph databases are ideal for handling many-to-many relationships. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 54. In the relational database model, data is organized into: A) Objects. B) Tables. C) Records. D) Hierarchies. Show Answer Correct Answer: B) Tables. 55. How do document stores like MongoDB organize data? A) In columns. B) In key-value pairs. C) In JSON-like documents. D) In tables. Show Answer Correct Answer: C) In JSON-like documents. 56. What year is considered the beginning of DBMS history? A) 1955. B) 1980. C) 1975. D) 1960. Show Answer Correct Answer: D) 1960. 57. Which file organization method stores data in a random order? A) Indexed. B) Hashed. C) Heap. D) Sequential. Show Answer Correct Answer: C) Heap. 58. How do you write a basic SELECT statement in SQL? A) FROM table name SELECT column1, column2;. B) SELECT * FROM table name;. C) SELECT column1, column2 FROM table name;. D) SELECT column1, column2 WHERE table name;. Show Answer Correct Answer: C) SELECT column1, column2 FROM table name;. 59. Which of the following is NOT Advantages of DBMS A) Improved data security. B) Increase data isolation. C) Increased data consistency. D) Reduced data redundancy. Show Answer Correct Answer: B) Increase data isolation. 60. Name one type of DBMS. A) Hierarchical Database Management System. B) Object-Oriented Database Management System. C) NoSQL Database System. D) Relational Database Management System (RDBMS). Show Answer Correct Answer: D) Relational Database Management System (RDBMS). Next →Related QuizzesScience QuizzesClass 12 QuizzesClass 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 9 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books