This quiz works best with JavaScript enabled. Home > Cbse > Class 12 > Science > Computer Science > Class 12 Computer Science Chapter 3 Database Management Systems – Quiz 14 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 12 Computer Science Chapter 3 Database Management Systems Quiz 14 (60 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. In a database, what is the 'instance' at any given point in time? A) The set of schema definitions and constraints. B) The snapshot/collection of data stored in the database. C) The software that manages the database system. D) The physical hardware where the database resides. Show Answer Correct Answer: B) The snapshot/collection of data stored in the database. 2. Which key can include additional, unnecessary attributes? A) Candidate Key. B) Composite Key. C) Primary Key. D) Super Key. Show Answer Correct Answer: D) Super Key. 3. What is one advantage of using a database system? A) Improved data accessibility. B) Increased data redundancy. C) More complex management. D) Higher costs. Show Answer Correct Answer: A) Improved data accessibility. 4. Which of the following is NOT an application of databases? A) Booking a holiday. B) Watching movies. C) Purchasing groceries. D) Using the local library. Show Answer Correct Answer: B) Watching movies. 5. Rollforward:Redoing changes made by ..... transactions. A) Failed. B) Uncommitted. C) Committed. D) Aborted. Show Answer Correct Answer: C) Committed. 6. Sistem ..... yang menangani kondisi malfunction (crash) baik pada hardware ataupun software, juga mengandung security Protection yang menangani pengaksesan oleh user terlarang A) Proteksi. B) Reset. C) Maintain. D) Format. Show Answer Correct Answer: A) Proteksi. 7. What is a key consideration when implementing a database management system in a healthcare setting? A) Ensure that all data is stored in plain text for easy access. B) Allow patients to edit their own medical records. C) Provide open access to all hospital staff. D) Implement strong security measures to protect patient data. Show Answer Correct Answer: D) Implement strong security measures to protect patient data. 8. Which is a set of entities of the same type that share the same properties, or attributes. A) Relation set. B) Entity set. C) Attribute set. D) Entity model. Show Answer Correct Answer: B) Entity set. 9. 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. 10. Database Recovery:Restoring the database to a correct state after ..... A) Update. B) Failure. C) Shutdown. D) Backup. Show Answer Correct Answer: B) Failure. 11. 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. 12. A client-server architecture for databases means: A) The database resides on the client system. B) Each client has its own separate database. C) Clients request services from a central database server. D) The database is distributed among clients. Show Answer Correct Answer: C) Clients request services from a central database server. 13. How does a DBMS address the issue of data redundancy? A) By compressing the data. B) By storing data in a single file. C) By storing data in separate linked tables. D) By encrypting the data. Show Answer Correct Answer: C) By storing data in separate linked tables. 14. 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) Cannot divide by zero. B) Compilation error. C) 10. D) 0. Show Answer Correct Answer: A) Cannot divide by zero. 15. 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. 16. Which SQL command is used to retrieve data? A) DELETE. B) INSERT. C) SELECT. D) UPDATE. Show Answer Correct Answer: C) SELECT. 17. 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. 18. Which tag is used to define an image in an HTML document? A) . B) . C) . D) . Show Answer Correct Answer: A) . 19. 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. 20. Standalone Architecture:Database and application on ..... computer. A) One. B) Shared. C) Remote. D) Two. Show Answer Correct Answer: A) One. 21. A ..... is a property of the entire relation, rather than of the individual tuples in which each tuple is unique. A) Key. B) Attribute. C) Rows. D) Field. Show Answer Correct Answer: C) Rows. 22. Which DBMS does Square use to store financial transaction data? A) Firebase. B) Teradata. C) Snowflake. D) MySQL. Show Answer Correct Answer: C) Snowflake. 23. Which of the following is NOT a component of a database system? A) People. B) Software. C) Network cables. D) Hardware. Show Answer Correct Answer: C) Network cables. 24. Juan needs to create a database of all his friends. In a table, what is all the information about one friend considered? A) Entry. B) Table. C) Record. D) Field. Show Answer Correct Answer: C) Record. 25. What are the different types of data integrity? A) Data Compression. B) Data Encryption. C) Data Redundancy. D) Entity Integrity, Referential Integrity, Domain Integrity, User-Defined Integrity. Show Answer Correct Answer: D) Entity Integrity, Referential Integrity, Domain Integrity, User-Defined Integrity. 26. Object-Oriented Programming is differ from any other programing by its building blocks of: A) Static development. B) Encapsulation. C) Functionality. D) Java language. Show Answer Correct Answer: B) Encapsulation. 27. 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. 28. What is the importance of data in computing? A) Data is irrelevant in programming. B) Data is only useful when stored in text files. C) Data does not influence decision-making processes. D) Data serves as input that is processed by a computer to generate output. Show Answer Correct Answer: D) Data serves as input that is processed by a computer to generate output. 29. To write programs using Java, which Java IDE is widely used for development? A) IDLE. B) CMD prompt. C) NetBeans. D) Anaconda. Show Answer Correct Answer: C) NetBeans. 30. Which ACID property ensures that committed transaction changes are permanent? A) Consistency. B) Isolation. C) Durability. D) Atomicity. Show Answer Correct Answer: C) Durability. 31. Which of the following is a type of query in MS Access? A) Data Control Language (DCL). B) Data Query Language (DQL). C) Select Query. D) Data Definition Language (DDL). Show Answer Correct Answer: C) Select Query. 32. ..... Key uniquely identifies each record in table. A) Primary. B) Record. C) Row. D) Fields. Show Answer Correct Answer: A) Primary. 33. What does the WHERE clause do in an SQL statement? A) Limits the number of rows returned. B) Specifies the conditions for data retrieval. C) Orders the result set. D) Groups rows that have the same values. Show Answer Correct Answer: B) Specifies the conditions for data retrieval. 34. What are the types of data integrity constraints? A) Data Encryption. B) Data Normalization. C) Data Redundancy. D) Entity Integrity, Referential Integrity, Domain Integrity, User-Defined Integrity. Show Answer Correct Answer: D) Entity Integrity, Referential Integrity, Domain Integrity, User-Defined Integrity. 35. ..... is a database that supports data distributed across several different sites A) Distributed database. B) Enterprise database. C) Centralized database. D) Discipline specific database. Show Answer Correct Answer: A) Distributed database. 36. Which of the following is not a database programs? A) MySQL. B) OObase. C) Writer. D) Oracle. Show Answer Correct Answer: C) Writer. 37. A Teacher can handle many Subjects, while a Subject can also be handled by many Teachers. Which ERD correctly shows this relationship? A) Teacher-One-to-One-Section. B) Teacher-Recursive. C) Teacher-One-to-Many-Subject. D) Teacher-Many-to-Many-Subject. Show Answer Correct Answer: D) Teacher-Many-to-Many-Subject. 38. What is a disadvantage of database systems? A) Enhanced data integrity. B) Reduced data redundancy. C) Improved data sharing. D) Increased costs. Show Answer Correct Answer: D) Increased costs. 39. Which of the following is an advantage of using a DBMS over a traditional file system? A) Improved data security. B) Increased data redundancy. C) Manual data backup. D) Higher data inconsistency. Show Answer Correct Answer: A) Improved data security. 40. What functions can be performed on a database? A) Queries and Updates. B) Queries and Deletions. C) Updates and Inserts. D) Queries, Updates, and Deletes. Show Answer Correct Answer: D) Queries, Updates, and Deletes. 41. A deadlock exists in the system if and only if the wait-for graph contains a ..... A) Cycle. B) Bi-direction. C) Direction. D) Rotation. Show Answer Correct Answer: A) Cycle. 42. Which of the following is a characteristic of the Object-Oriented DBMS? A) Does not support relationships. B) Is based on a hierarchical structure. C) Supports complex data types and inheritance. D) Uses tables to store data. Show Answer Correct Answer: C) Supports complex data types and inheritance. 43. The ..... rule specifies that an entity can be a member of only one subtype at a time. A) Disjoint. B) Removal. C) Inclusion. D) Exclusion. Show Answer Correct Answer: A) Disjoint. 44. In the relation model, the relation are generally termed as ..... A) Attributes. B) Rows. C) Tuples. D) Tables. Show Answer Correct Answer: D) Tables. 45. Which of the following is a benefit of using a cloud database? A) Higher maintenance costs. B) Limited access to data. C) Scalability and flexibility. D) Increased physical storage requirements. Show Answer Correct Answer: C) Scalability and flexibility. 46. What is the purpose of a view in SQL? A) To provide a virtual table based on the result set of a query. B) To create a new database. C) To insert records into a table. D) To delete records from a table. Show Answer Correct Answer: A) To provide a virtual table based on the result set of a query. 47. If a website developer wants to create a form where users can input their email and submit it, then which HTML tag should he/she use? A) . B) . C) . D) . Show Answer Correct Answer: A) . 48. Which of the following best describes a relational database? A) Data is stored in a flat file. B) Data is stored in a tree structure. C) Data is stored in a single file. D) Data is organized in tables with relationships. Show Answer Correct Answer: D) Data is organized in tables with relationships. 49. How do you update a record in SQL? A) INSERT INTO table name VALUES (value1, value2);. B) UPDATE table name SET column1 = value1, column2 = value2 WHERE condition;. C) SELECT * FROM table name WHERE condition;. D) DELETE FROM table name WHERE condition;. Show Answer Correct Answer: B) UPDATE table name SET column1 = value1, column2 = value2 WHERE condition;. 50. What is a performance-related disadvantage of a DBMS? A) Optimal performance for all applications. B) Increased concurrency control. C) Improved data accessibility and responsiveness. D) Decreased speed for some applications. Show Answer Correct Answer: D) Decreased speed for some applications. 51. What is a view in SQL and how is it different from a table? A) A view is a physical table that stores data permanently. B) A view is a type of database index that speeds up queries. C) A view can only be created from a single table. D) A view is a virtual table based on a SELECT query, while a table is a physical storage of data. Show Answer Correct Answer: D) A view is a virtual table based on a SELECT query, while a table is a physical storage of data. 52. Which of the following types of database users interacts directly with the database? A) End users. B) Database administrators. C) System analysts. D) Application programmers. Show Answer Correct Answer: A) End users. 53. In the ..... normal form, a composite attribute is converted to individual attributes A) Third Normal Form. B) Second Normal Form. C) First Normal Form. D) Fourth Normal Form. Show Answer Correct Answer: C) First Normal Form. 54. What is the primary function of the storage manager in a DBMS? A) To enforce data security. B) To create user interfaces. C) To process user queries. D) To manage data storage and retrieval. Show Answer Correct Answer: D) To manage data storage and retrieval. 55. What is a safe expression in relational calculus? A) Generates infinite relations. B) Is always true. C) Uses only known values. D) Has no variables. Show Answer Correct Answer: C) Uses only known values. 56. What is the output when the data "FOREIGN key' is set to the text format > in Access? A) Foreign key. B) Foreign key. C) FOREIGN KEY. D) Foreign Key. Show Answer Correct Answer: C) FOREIGN KEY. 57. When subtypes are overlapping, an additional field must be added to the supertype to act as a discriminator. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 58. What is the purpose of SQL in database management? A) The purpose of SQL in database management is to manage and manipulate relational databases. B) To visualize data in spreadsheets. C) To create non-relational databases. D) To perform statistical analysis on data. Show Answer Correct Answer: A) The purpose of SQL in database management is to manage and manipulate relational databases. 59. In a database for a hospital, there are separate tables for 'Patients', 'Doctors', and 'Appointments'. If a query is run to find a patient's diagnosis, what type of database architecture component is being used to retrieve that specific information for the user? A) A conceptual schema. B) An external schema. C) The internal schema. D) A database instance. Show Answer Correct Answer: B) An external schema. 60. What does a composite key consist of? A) A single value. B) Two or more columns. C) No columns. D) One column. Show Answer Correct Answer: B) Two or more columns. ← PreviousNext →Related QuizzesScience QuizzesClass 12 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 8 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books