This quiz works best with JavaScript enabled. Home > Class 12 > Class 12 Computer Science Chapter 3 Database Management Systems – Quiz 34 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 12 Computer Science Chapter 3 Database Management Systems Quiz 34 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What is the purpose of the transaction log file in SQL Server? A) To define the structure of the database. B) To keep a log of all operations performed on the database. C) To store user interface designs. D) To store backup copies of the database. Show Answer Correct Answer: B) To keep a log of all operations performed on the database. 2. Database Recovery:Restoring the database to a correct state after ..... A) Failure. B) Backup. C) Update. D) Shutdown. Show Answer Correct Answer: A) Failure. 3. How does the centralization of resources in a DBMS impact its vulnerability? A) Decreases the impact of system failures. B) Increases the likelihood of system failures. C) Ensures all users have separate resources. D) Reduces the need for backup and recovery services. Show Answer Correct Answer: B) Increases the likelihood of system failures. 4. A client-server architecture for databases means: A) The database resides on the client system. B) The database is distributed among clients. C) Clients request services from a central database server. D) Each client has its own separate database. Show Answer Correct Answer: C) Clients request services from a central database server. 5. How does a DBMS address the issue of data redundancy? A) By storing data in separate linked tables. B) By storing data in a single file. C) By encrypting the data. D) By compressing the data. Show Answer Correct Answer: A) By storing data in separate linked tables. 6. Given the following Java code, what will be printed?public class Test \{ public static void main(String[] args) \{ int x = 10; int y = 0; try \{ System.out.println(x / y); \} catch (ArithmeticException e) \{ System.out.println("Cannot divide by zero"); \} \}\} A) 10. B) 0. C) Cannot divide by zero. D) Compilation error. Show Answer Correct Answer: C) Cannot divide by zero. 7. What is the purpose of the database design phase? A) Enter data into the database. B) Create a backup of the database. C) Organize and structure data for efficient storage and retrieval. D) Delete unnecessary records from the database. Show Answer Correct Answer: C) Organize and structure data for efficient storage and retrieval. 8. Which SQL command is used to retrieve data? A) DELETE. B) UPDATE. C) INSERT. D) SELECT. Show Answer Correct Answer: D) SELECT. 9. Which of the following best describes data integrity in the context of a DBMS? A) The speed at which data is processed. B) The accuracy and consistency of data stored in the database. C) The amount of storage space used. D) The number of users accessing the database. Show Answer Correct Answer: B) The accuracy and consistency of data stored in the database. 10. To remove duplicate rows from the result set of a select use the following keyword(s). A) NO DUPLICATES. B) DISTINCT. C) UNIQUE. D) None of the above. Show Answer Correct Answer: B) DISTINCT. 11. Which tag is used to define an image in an HTML document? A) . B) . C) . D) . Show Answer Correct Answer: A) . 12. In data concurrency, what problem might arise without proper management? A) Increased processing speed. B) Data integrity and consistency issues. C) Reduced storage requirements. D) Enhanced security. Show Answer Correct Answer: B) Data integrity and consistency issues. 13. Standalone Architecture:Database and application on ..... computer. A) One. B) Two. C) Remote. D) Shared. Show Answer Correct Answer: A) One. 14. A ..... is a property of the entire relation, rather than of the individual tuples in which each tuple is unique. A) Rows. B) Key. C) Attribute. D) Field. Show Answer Correct Answer: A) Rows. 15. What is the primary purpose of a primary key in a database? A) To establish relationships between tables. B) To encrypt sensitive information. C) To uniquely identify a record in a table. D) To store large amounts of data. Show Answer Correct Answer: C) To uniquely identify a record in a table. 16. Which DBMS does Square use to store financial transaction data? A) Snowflake. B) Teradata. C) MySQL. D) Firebase. Show Answer Correct Answer: A) Snowflake. 17. Which of the following is NOT a component of a database system? A) Hardware. B) Software. C) People. D) Network cables. Show Answer Correct Answer: D) Network cables. 18. What is the primary function of a Database Management System (DBMS)? A) To manage large amounts of structured data. B) To write code for websites. C) To connect users to the internet. D) To edit videos and images. Show Answer Correct Answer: A) To manage large amounts of structured data. 19. Juan needs to create a database of all his friends. In a table, what is all the information about one friend considered? A) Field. B) Record. C) Table. D) Entry. Show Answer Correct Answer: B) Record. 20. What are the different types of data integrity? A) Data Redundancy. B) Entity Integrity, Referential Integrity, Domain Integrity, User-Defined Integrity. C) Data Compression. D) Data Encryption. Show Answer Correct Answer: B) Entity Integrity, Referential Integrity, Domain Integrity, User-Defined Integrity. 21. Object-Oriented Programming is differ from any other programing by its building blocks of: A) Static development. B) Encapsulation. C) Java language. D) Functionality. Show Answer Correct Answer: B) Encapsulation. 22. What defines the transformation of data into information? A) Storage technique. B) Computational power. C) Contextualisation and meaningful interpretation. D) Database design. Show Answer Correct Answer: C) Contextualisation and meaningful interpretation. 23. What is the importance of data in computing? A) Data serves as input that is processed by a computer to generate output. B) Data is irrelevant in programming. C) Data is only useful when stored in text files. D) Data does not influence decision-making processes. Show Answer Correct Answer: A) Data serves as input that is processed by a computer to generate output. 24. To write programs using Java, which Java IDE is widely used for development? A) IDLE. B) Anaconda. C) NetBeans. D) CMD prompt. Show Answer Correct Answer: C) NetBeans. 25. Which ACID property ensures that committed transaction changes are permanent? A) Atomicity. B) Consistency. C) Isolation. D) Durability. Show Answer Correct Answer: D) Durability. ← 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