This quiz works best with JavaScript enabled. Home > Cbse > Class 12 > Science > Computer Science > Class 12 Computer Science Chapter 3 Database Management Systems – Quiz 16 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 12 Computer Science Chapter 3 Database Management Systems Quiz 16 (60 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What does the MIN function do? A) Sums values. B) Finds the maximum value. C) Finds the minimum value. D) Counts values. Show Answer Correct Answer: C) Finds the minimum value. 2. What does the LEFT JOIN do? A) Returns all records from the right table. B) Returns no records. C) Returns all records from the left table. D) Returns matching records only. Show Answer Correct Answer: C) Returns all records from the left table. 3. Which of the following is a benefit of using forms in a database? A) They simplify data entry. B) They increase data redundancy. C) They complicate data retrieval. D) They reduce data security. Show Answer Correct Answer: A) They simplify data entry. 4. Which key stoke moves the active cell towards left in Access table? A) Tab. B) F2. C) Shift + Tab. D) F5. Show Answer Correct Answer: C) Shift + Tab. 5. What is a primary use of a data warehouse? A) Managing daily transactions. B) Storing data for tactical or strategic decision-making. C) Handling customer service requests. D) Running payroll systems. Show Answer Correct Answer: B) Storing data for tactical or strategic decision-making. 6. Which SQL statement is used to create a view? A) CREATE VIEW. B) NEW VIEW. C) SELECT VIEW. D) MAKE VIEW. Show Answer Correct Answer: A) CREATE VIEW. 7. Which of the following is considered as DBMS? A) Oracle. B) FoxPro. C) Access. D) All of these. Show Answer Correct Answer: D) All of these. 8. Why do we convert many-to-many into one-to-many? A) To reduce tables. B) To avoid redundancy and improve relationships. C) To store more attributes. D) To simplify queries. Show Answer Correct Answer: B) To avoid redundancy and improve relationships. 9. What is the primary purpose of OLAP systems? A) To manage transactions. B) To provide cloud-based services. C) To analyze large volumes of data. D) To store unstructured data. Show Answer Correct Answer: C) To analyze large volumes of data. 10. What is the purpose of data constraints in a database? A) To increase data redundancy. B) To simplify data retrieval. C) To ensure data accuracy and reliability. D) To allow unlimited data entry. Show Answer Correct Answer: C) To ensure data accuracy and reliability. 11. Database management system is ..... software A) Relational. B) Application. C) Game. D) System. Show Answer Correct Answer: B) Application. 12. What is an ER diagram? A) A programming language. B) A file type. C) A type of database. D) A pictorial representation of data. Show Answer Correct Answer: D) A pictorial representation of data. 13. Which of the following software is appropriate to store data about school students? A) Impress. B) Calc. C) MS-Access. D) Writer. Show Answer Correct Answer: C) MS-Access. 14. MongoDB supports SQL queries. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 15. What is the purpose of a composite key in a relational schema? A) To define the structure of a table. B) To allow NULL values in a relation. C) To enforce referential integrity. D) To uniquely identify tuples using multiple attributes. Show Answer Correct Answer: D) To uniquely identify tuples using multiple attributes. 16. Which of the following is not involved in DBMS? A) HTML. B) Application Request. C) End Users. D) Data. Show Answer Correct Answer: A) HTML. 17. Which of the following is an example of a Data Definition Language (DDL) command? A) SELECT. B) INSERT. C) UPDATE. D) CREATE. Show Answer Correct Answer: D) CREATE. 18. Which is the example of File Based System? A) Using OpenOffice.org Base to create new table. B) Using MySQL to find specific data. C) Using MS Access to control users access. D) Using spreadsheet software to manage data of employee. Show Answer Correct Answer: D) Using spreadsheet software to manage data of employee. 19. The created database is listed using the ..... command. A) INSERT. B) USE. C) UPDATE. D) SHOW. Show Answer Correct Answer: D) SHOW. 20. What is the expansion of OLE in Access? A) Object linking and embedding. B) Object linking and encrypting. C) Object linking and editing. D) Object linking and encapsulation. Show Answer Correct Answer: A) Object linking and embedding. 21. What is the maximum length of the field name in Access? A) 32 characters. B) 128 characters. C) 16 characters. D) 64 characters. Show Answer Correct Answer: D) 64 characters. 22. This process of hiding the details of entities in the ER model is known as? A) Generalization. B) Abstraction. C) Specialization. D) None of these above. Show Answer Correct Answer: B) Abstraction. 23. In agricultural databases, which of the following data types would be suitable for soil pH values? A) Date/Time. B) Text. C) Memo. D) Number (Decimal). Show Answer Correct Answer: D) Number (Decimal). 24. Consider the following transactions with data items P and Q initialized to zero:T1:read (P) ; read (Q) ; if P = 0 then Q:= Q + 1 ; write (Q) ;T2:read (Q) ; read (P) ; if Q = 0 then P:= P + 1 ; write (P) ;Any non-serial interleaving of T1 and T2 for concurrent execution leads to A) A conflict serializable schedule. B) A schedule that is not conflict serializable. C) A schedule for which a precedence graph cannot be drawn. D) A serializable schedule. Show Answer Correct Answer: B) A schedule that is not conflict serializable. 25. Which DBMS does Adobe use to handle local data storage within its software? A) SQLite. B) IBM Db2. C) MongoDB. D) MySQL. Show Answer Correct Answer: A) SQLite. 26. ..... :Person responsible for technical management of databases. A) Database Administrator (DBA). B) Network Analyst. C) Software Engineer. D) System Operator. Show Answer Correct Answer: A) Database Administrator (DBA). 27. Which of the following is a disadvantage of the database approach? A) Increased concurrency. B) Complexity. C) Improved data integrity. D) Data consistency. Show Answer Correct Answer: B) Complexity. 28. Which database view is used by users who want to create tables and relationships between them? A) Physical view. B) Logical view. C) User view. D) None of the above. Show Answer Correct Answer: B) Logical view. 29. Which of the following is an example of an external database? A) Employee attendance records. B) B2B and B2C e-commerce catalogues. C) Internal payroll system. D) Personal email inbox. Show Answer Correct Answer: B) B2B and B2C e-commerce catalogues. 30. What is a primary role of a Database Administrator (DBA)? A) Performing data entry. B) Designing the database. C) Writing application programs. D) Managing the DBMS. Show Answer Correct Answer: D) Managing the DBMS. 31. What is the Alternate key? A) All the keys which are not primary key are called an alternate key. B) It is a candidate key which is currently not the primary key. C) A table may have single or multiple choices for the primary key. D) All of the above. Show Answer Correct Answer: D) All of the above. 32. Which of the following is a type of action query in MS Access? A) Crosstab Query. B) Select Query. C) Report Query. D) Append Query. Show Answer Correct Answer: D) Append Query. 33. What is a weak entity in an ER model? A) An entity that cannot be uniquely identified. B) An entity with multiple attributes. C) An entity that has no relationships. D) An entity with a primary key. Show Answer Correct Answer: A) An entity that cannot be uniquely identified. 34. In a relational database, each column represents a: A) Record. B) Key. C) Attribute. D) Tuple. Show Answer Correct Answer: C) Attribute. 35. What is the LAST step to request records or reports in a database management system? A) Download the report. B) Log in. C) Log out. D) Run a query. Show Answer Correct Answer: C) Log out. 36. Which of the following are ACID properties? A) Atomicity, Consistency, Isolation, and Durability. B) Availability, Consistency, Isolation, and Durability. C) Atomicity, Concurrency, Isolation, and Durability. D) Atomicity, Consistency, Integration, and Durability. Show Answer Correct Answer: A) Atomicity, Consistency, Isolation, and Durability. 37. What does the INNER JOIN do? A) Returns unique records. B) Returns matching records. C) Returns all records. D) Returns no records. Show Answer Correct Answer: B) Returns matching records. 38. What does the ROLLBACK command do? A) Undoes transactions that have not been committed. B) Saves all changes made to the database. C) Deletes a database. D) Creates a new database. Show Answer Correct Answer: A) Undoes transactions that have not been committed. 39. What does the term "atomic" mean in the context of database attributes? A) Attributes are indivisible. B) Attributes can have multiple values. C) Attributes can be divided. D) Attributes are composite. Show Answer Correct Answer: A) Attributes are indivisible. 40. What is structured query language (SQL)? A) A standard query language used within relational databases. B) A programming language used to query databases. C) A hardware device used to store data. D) A network protocol. Show Answer Correct Answer: A) A standard query language used within relational databases. 41. How does normalization improve database design? A) Normalization reduces redundancy and improves data integrity in database design. B) Normalization increases data duplication and decreases efficiency in database design. C) Normalization complicates the database structure and hinders performance. D) Normalization eliminates the need for indexing and slows down queries in database design. Show Answer Correct Answer: A) Normalization reduces redundancy and improves data integrity in database design. 42. How does a DBMS enable more information to be derived from the same amount of data? A) By restricting data sharing among users. B) By increasing data redundancy for backup purposes. C) By integrating operational data for cross-departmental use. D) By limiting access to data for security reasons. Show Answer Correct Answer: C) By integrating operational data for cross-departmental use. 43. What is 'data normalisation' in the context of databases? A) The process of encrypting data. B) The process of increasing data redundancy. C) The process of backing up data. D) The process of organising data to reduce redundancy. Show Answer Correct Answer: D) The process of organising data to reduce redundancy. 44. Which of the following is a common type of NoSQL database? A) Object-Oriented Database. B) Hierarchical Database. C) Relational Database. D) Document Store. Show Answer Correct Answer: D) Document Store. 45. What describes the structure of the whole database for a community of users? A) Internal or Physical level. B) Conceptual or Logical level. C) External or View level. D) None of the above. Show Answer Correct Answer: B) Conceptual or Logical level. 46. ..... :Law protecting healthcare information. A) ADA. B) OSHA. C) FERPA. D) HIPAA. Show Answer Correct Answer: D) HIPAA. 47. What is a key benefit of data integrity management? A) Higher costs. B) Minimized data inconsistency. C) More complex data access. D) Increased data redundancy. Show Answer Correct Answer: B) Minimized data inconsistency. 48. Which SQL statement is used to insert new data in database? A) UPDATE. B) INSERT NEW. C) INSERT INTO. D) ADD. Show Answer Correct Answer: C) INSERT INTO. 49. Which CSS property is used to change the text color of an element? A) Background-color. B) Text-color. C) Color. D) Font-color. Show Answer Correct Answer: C) Color. 50. Which of the following best describes a key-value store? A) Stores data as key-value pairs. B) Organizes data in a tree-like structure. C) Stores data in a structured format. D) Uses a graph structure for relationships. Show Answer Correct Answer: A) Stores data as key-value pairs. 51. What is an index in SQL and how does it improve query performance? A) An index in SQL is a command that compiles SQL queries into machine code. B) An index in SQL is used to delete records from a database. C) An index in SQL is a database object that enhances query performance by allowing faster data retrieval. D) An index in SQL is a type of data type that stores large amounts of data. Show Answer Correct Answer: C) An index in SQL is a database object that enhances query performance by allowing faster data retrieval. 52. When analog signal to another analog signal conversion is required? A) To extend the area coverage of wires signal. B) To transmit analog signal through cables. C) To extend network cable. D) To connect computer with connectivity devices. Show Answer Correct Answer: A) To extend the area coverage of wires signal. 53. ..... is used to eliminate duplicate rows A) UNIQUE. B) NO DUPLICATE. C) DISTINCT. D) None of these. Show Answer Correct Answer: C) DISTINCT. 54. What are cursors in SQL and when would you use them? A) Cursors are used in SQL to process individual rows returned by a query, allowing for row-by-row operations. B) Cursors are used to optimize query performance by executing multiple queries simultaneously. C) Cursors are used to create temporary tables for storing large datasets. D) Cursors are a type of SQL function that automatically updates all rows in a table at once. Show Answer Correct Answer: A) Cursors are used in SQL to process individual rows returned by a query, allowing for row-by-row operations. 55. What is the primary purpose of a database schema in a DBMS? A) To define the structure and organisation of data in the database. B) To display data in graphical form. C) To print documents. D) To connect to the internet. Show Answer Correct Answer: A) To define the structure and organisation of data in the database. 56. What are the main components of a database system structure? A) Database backup system. B) Network configuration tools. C) Data visualization software. D) The main components of a database system structure are the database engine, database schema, query processor, and user interface. Show Answer Correct Answer: D) The main components of a database system structure are the database engine, database schema, query processor, and user interface. 57. What is an essential feature of a database management system to ensure that patient data is not lost? A) Manual data entry. B) Regular data backups. C) Store data in plain text. D) Open access to all users. Show Answer Correct Answer: B) Regular data backups. 58. What is the primary purpose of using SELECT, INSERT, UPDATE, and DELETE commands in SQL? A) To modify the SQL software. B) To control user access and permissions. C) To manage data in a database. D) To configure network settings. Show Answer Correct Answer: C) To manage data in a database. 59. Which activity is part of the group task related to database systems? A) Creating a database for banking systems. B) Comparing the ease of access, security, and cost of paper-based and digital systems. C) Designing a Netflix recommendation system. D) Calculating grades using Excel. Show Answer Correct Answer: B) Comparing the ease of access, security, and cost of paper-based and digital systems. 60. Which SQL clause is used to combine the result sets of two or more SELECT statements? A) UNION. B) MERGE. C) LINK. D) JOIN. Show Answer Correct Answer: A) UNION. ← 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