This quiz works best with JavaScript enabled. Home > Class 12 > Class 12 Computer Science Chapter 3 Database Management Systems – Quiz 60 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 12 Computer Science Chapter 3 Database Management Systems Quiz 60 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Transaction transparency ensures that distributed transactions are treated as centralized transactions. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 2. Growing Phase:Phase where a transaction acquires locks but ..... none. A) Releases. B) Acquires. C) Holds. D) Shares. Show Answer Correct Answer: A) Releases. 3. How can you prevent SQL injection attacks? A) By disabling all database access. B) By using prepared statements and parameterized queries. C) By allowing all user inputs without validation. D) By using only stored procedures. Show Answer Correct Answer: B) By using prepared statements and parameterized queries. 4. Which of the following is not an example of DBMS? A) MySQL. B) Microsoft Acess. C) IBM DB2. D) MS-Excel. Show Answer Correct Answer: D) MS-Excel. 5. What are the types of information systems? A) Transaction Processing Systems, Management Information Systems, Decision Support Systems. B) File-based systems, paper-based systems. C) Data storage systems, text file systems. D) None of the above. Show Answer Correct Answer: A) Transaction Processing Systems, Management Information Systems, Decision Support Systems. 6. What does the DBMS use if user A1 is authorized to request a logical record? A) Physical Record Interface. B) Logical Record Interface. C) Conceptual Record Interface. D) External Record Interface. Show Answer Correct Answer: B) Logical Record Interface. 7. Which of the following is not a valid aggregate function? A) COUNT. B) MIN. C) MAX. D) COMPUTE. Show Answer Correct Answer: D) COMPUTE. 8. Mainframe Architecture:Centralized database accessed by ..... users. A) Many. B) Few. C) Single. D) Remote. Show Answer Correct Answer: A) Many. 9. Which DBMS does Tesla use for monitoring data in real-time? A) Couchbase. B) SQLite. C) Snowflake. D) InfluxDB. Show Answer Correct Answer: D) InfluxDB. 10. Which company uses Microsoft SQL Server to handle data from millions of user interactions? A) Stack Overflow. B) NASA. C) American Airlines. D) Snapchat. Show Answer Correct Answer: A) Stack Overflow. 11. What is a database management system's role in data security? A) A DBMS is primarily used for data visualization. B) A DBMS only stores data without any security features. C) A DBMS does not allow user access management. D) A DBMS secures data by enforcing access controls, encryption, and auditing. Show Answer Correct Answer: D) A DBMS secures data by enforcing access controls, encryption, and auditing. 12. What is a rollback in the context of transactions? A) A rollback is the process of reverting a transaction to its previous state. B) A rollback is a method for permanently saving a transaction. C) A rollback is a technique for analyzing transaction data. D) A rollback is the process of enhancing a transaction's performance. Show Answer Correct Answer: A) A rollback is the process of reverting a transaction to its previous state. 13. What does a DBMS help minimize in data management? A) Data inconsistency. B) Data sharing. C) Data integration. D) End-user productivity. Show Answer Correct Answer: A) Data inconsistency. 14. Which of the following is NOT a type of NoSQL database? A) MongoDB. B) Cassandra. C) Redis. D) MySQL. Show Answer Correct Answer: D) MySQL. 15. Which of these is a popular relational database system? A) MongoDB. B) Google Docs. C) MySQL. D) Netflix Recommendations. Show Answer Correct Answer: C) MySQL. 16. Which of the following is an example of a field in a file record? A) LastName. B) EmployeeNumber. C) Department. D) ProjectCode. Show Answer Correct Answer: A) LastName. 17. Physical Data Independence is best described as: A) Immunity of the external model to changes in the conceptual model. B) Immunity of an application to changes in the internal storage model and access strategy. C) Immunity of the conceptual model to changes in the external model. D) Immunity of the database to changes in user queries. Show Answer Correct Answer: B) Immunity of an application to changes in the internal storage model and access strategy. 18. What is required for translating a relationship set into a table? A) No attributes needed. B) Primary key and descriptive attributes. C) Descriptive attributes only. D) Only primary key attributes. Show Answer Correct Answer: B) Primary key and descriptive attributes. 19. ..... exists when different versions of the same data appear in different places A) Data integrity. B) Data anomaly. C) Data redundancy. D) Data inconsistency. Show Answer Correct Answer: D) Data inconsistency. 20. What is a key advantage of using a database approach? A) Improved data accessibility. B) Increased data redundancy. C) More complex management. D) Higher costs. Show Answer Correct Answer: A) Improved data accessibility. 21. American Airlines uses Teradata to improve what? A) Transaction speeds. B) Customer service operations. C) Advertising efficiency. D) Email marketing. Show Answer Correct Answer: B) Customer service operations. 22. Which component of the SQL environment processes SQL commands? A) Client application. B) Database server. C) Network. D) Development tool. Show Answer Correct Answer: B) Database server. 23. What is a transaction in database management? A) A transaction is a backup of database data. B) A transaction is a sequence of operations treated as a single unit of work in a database. C) A transaction is a type of database query. D) A transaction is a method for deleting records from a database. Show Answer Correct Answer: B) A transaction is a sequence of operations treated as a single unit of work in a database. 24. What does improved data integrity refer to in the context of a DBMS? A) Ignoring constraints for data items. B) Allowing unauthorized users to modify data. C) Ensuring data is inconsistent across records. D) Defining consistency rules for the database. Show Answer Correct Answer: D) Defining consistency rules for the database. 25. What is the main advantage of using polymorphism in Java? A) It allows methods to be overloaded and overridden for flexibility. B) It forces all methods to have the same name. C) It eliminates the need for classes. D) It prevents code reuse. Show Answer Correct Answer: A) It allows methods to be overloaded and overridden for flexibility. ← 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