This quiz works best with JavaScript enabled. Home > Cbse > Class 12 > Science > Computer Science > Class 12 Computer Science Chapter 3 Database Management Systems – Quiz 7 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 12 Computer Science Chapter 3 Database Management Systems Quiz 7 (60 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. In a relational database, a tuple represents: A) A column in a table. B) A row in a table. C) A relationship between tables. D) A set of constraints. Show Answer Correct Answer: B) A row in a table. 2. What is a single row of a table called? A) Record. B) Attribute. C) Column. D) Tuple. Show Answer Correct Answer: D) Tuple. 3. What is one key advantage of a database? A) It slows down data retrieval. B) It enables fast retrieval of information. C) It requires a manual process to update data. D) It is only useful for small data sets. Show Answer Correct Answer: B) It enables fast retrieval of information. 4. Which of the following data independence types refers to immunity of application programs to changes in physical storage structure? A) Conceptual data independence. B) Physical data independence. C) External data independence. D) Logical data independence. Show Answer Correct Answer: B) Physical data independence. 5. ..... is a key uniquely identifies a record in a table. A) Primary key. B) Candidate key. C) Alternate key. D) None of the above. Show Answer Correct Answer: A) Primary key. 6. EBay uses Neo4j primarily for improving which of the following? A) Marketing automation. B) User security. C) Transactional speed. D) Product recommendations. Show Answer Correct Answer: D) Product recommendations. 7. What is a disadvantage of paper-based systems? A) Difficult to search B) Easy to store C) Low cost D) High durability A) Time-consuming to update. B) Highly accessible online. C) A) Difficult to search. D) Requires no physical space. Show Answer Correct Answer: C) A) Difficult to search. 8. What is the purpose of backup and recovery management in a DBMS? A) To enhance data redundancy. B) To ensure data safety and integrity. C) To manage hardware resources. D) To create user interfaces. Show Answer Correct Answer: B) To ensure data safety and integrity. 9. Jennifer is creating a database for several customers. How will she list the Customer ID? A) Number. B) Data. C) Currency. D) Yes/No. Show Answer Correct Answer: A) Number. 10. What must be common between two tables to create a relationship? A) Names. B) Files. C) Fields. D) Characters. Show Answer Correct Answer: C) Fields. 11. In a database system, the primary function of a DBMS is to: A) Create, modify, and delete data structures. B) Control concurrency of operations. C) Manage data storage and retrieval. D) Provide network services. Show Answer Correct Answer: C) Manage data storage and retrieval. 12. When primary key is made up of two or more columns then it is called ..... primary key. A) Reference. B) Composite. C) Compost. D) Mixed. Show Answer Correct Answer: B) Composite. 13. What is the difference between a primary key and a unique key? A) Both primary key and unique key are the same. B) A primary key can be composed of multiple columns, while a unique key cannot. C) A primary key uniquely identifies a record in a table, while a unique key ensures all values in a column are different. D) A primary key can accept null values, while a unique key cannot. Show Answer Correct Answer: C) A primary key uniquely identifies a record in a table, while a unique key ensures all values in a column are different. 14. Which type of data can be stored in the database? A) Image oriented data. B) Text, files containing data. C) Data in the form of audio or video. D) All of the above. Show Answer Correct Answer: D) All of the above. 15. What is a disadvantage of file-based systems? A) Data redundancy B) Easy access C) Low cost D) High performance A) User-friendly interface. B) Data integrity. C) A) Data redundancy. D) Centralized control. Show Answer Correct Answer: C) A) Data redundancy. 16. Which of the following is a key feature of a DBMS? A) Automatic software updates. B) File compression. C) Only storing unstructured data. D) Data integrity enforcement. Show Answer Correct Answer: D) Data integrity enforcement. 17. In MS Access, which feature helps generate printable summaries and formatted outputs of agricultural data? A) Queries. B) Tables. C) Relationships. D) Reports. Show Answer Correct Answer: D) Reports. 18. Where is DBMS commonly used? A) Banking systems B) Cooking recipes C) Painting D) Gardening A) G) Sports analytics. B) F) Fashion design. C) A) Banking systems. D) E) Video games. Show Answer Correct Answer: C) A) Banking systems. 19. Which component manages how data is physically stored and accessed? A) Query Processor. B) Transaction Manager. C) Storage Manager. D) Compiler. Show Answer Correct Answer: C) Storage Manager. 20. Which of the following best defines data integrity in a DBMS? A) Accuracy and consistency of data over its lifecycle. B) Ability to generate reports. C) A feature that prevents database updates. D) A function that speeds up queries. Show Answer Correct Answer: A) Accuracy and consistency of data over its lifecycle. 21. What does the DataGridView control do? A) Connects to a data source. B) Creates a new database. C) Displays data in a scrollable grid. D) Saves data to a file. Show Answer Correct Answer: C) Displays data in a scrollable grid. 22. Who is responsible for defining user access and recovery plans? A) Application Developer. B) Online User. C) Naive User. D) Database Administrator (DBA). Show Answer Correct Answer: D) Database Administrator (DBA). 23. What is the purpose of the CREATE TABLE statement in SQL? A) To retrieve data from a table. B) To modify an existing table's structure. C) To delete a table from the database. D) To define a new table and its structure in the database. Show Answer Correct Answer: D) To define a new table and its structure in the database. 24. In object oriented programming, which feature indicates the code reusability? A) Inheritance. B) Polymorphism. C) Encapsulation. D) Abstraction. Show Answer Correct Answer: A) Inheritance. 25. ..... specifies a search condition for a group or an aggregate. A) FROM clause. B) HAVING clause. C) GROUP BY Clause. D) WHERE clause. Show Answer Correct Answer: B) HAVING clause. 26. What is the main purpose of database testing? A) To increase data redundancy. B) To ensure data security. C) To validate data integrity and performance. D) To create new databases. Show Answer Correct Answer: C) To validate data integrity and performance. 27. What is the result of a query in MS Access? A) A form. B) A new table. C) A datasheet view. D) A report. Show Answer Correct Answer: C) A datasheet view. 28. Which of the following is NOT a type of database relationship? A) One-to-One. B) One-to-Many. C) Many-to-Many. D) One-to-None. Show Answer Correct Answer: D) One-to-None. 29. Before the used of database, organizations and individuals used ..... A) File Cabinets. B) File Systems. C) Filing Systems. D) Printed Forms. Show Answer Correct Answer: B) File Systems. 30. What does the GROUP BY clause do in SQL? A) It sorts the result set in ascending order. B) It groups rows that have the same values in specified columns into summary rows. C) It filters records based on specified conditions. D) It joins two or more tables together. Show Answer Correct Answer: B) It groups rows that have the same values in specified columns into summary rows. 31. A field which is ..... for each and every record is called Primary key. A) Common. B) Same. C) Unique. D) None of the above. Show Answer Correct Answer: C) Unique. 32. Which of the following is not valid field of table "Student" A) Salary. B) Fees. C) Admno. D) Name. Show Answer Correct Answer: A) Salary. 33. A completeness constraint may specify that each entity of the supertype must be a member of some subtype in the relationship. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 34. Which wildcard character matches any sequence of characters in SQL? A) . B) *. C) %. D) #. Show Answer Correct Answer: C) %. 35. What is the purpose of a data model in a database? A) To manage user permissions. B) To visualize data relationships. C) To encrypt sensitive information. D) To define how data is stored and accessed. Show Answer Correct Answer: D) To define how data is stored and accessed. 36. How do other data models differ from the relational model? A) Other data models use only flat files for storage. B) Other data models differ from the relational model in structure and data organization, such as using documents, key-value pairs, graphs, or columns instead of tables. C) Data models differ by using only spreadsheets for data management. D) Relational models are the only way to organize data. Show Answer Correct Answer: B) Other data models differ from the relational model in structure and data organization, such as using documents, key-value pairs, graphs, or columns instead of tables. 37. Consider attributes ID, CITY, and NAME. Which one if this can be considered as a primary key? A) ID. B) NAME. C) ID, NAME. D) CITY. Show Answer Correct Answer: A) ID. 38. Why is it important to use a DBMS to manage large sets of data? A) It makes data more secure, organized, and accessible. B) It creates faster internet speeds. C) It reduces the size of files on a computer. D) It helps design user interfaces for websites. Show Answer Correct Answer: A) It makes data more secure, organized, and accessible. 39. A single-user database that runs on a personal computer is called a(n) ..... database. A) Enterprise. B) Workgroup. C) Desktop. D) Distributed. Show Answer Correct Answer: C) Desktop. 40. If a business company wants its website to load faster by reducing image sizes, then what technique should they use? A) Remove all images from the website. B) Convert images to WebP format. C) Increase the image resolution. D) Use inline CSS for images. Show Answer Correct Answer: B) Convert images to WebP format. 41. Durability:Once a transaction commits, its changes ..... ? A) Are temporary. B) Can be reversed. C) Cannot be lost. D) May be lost. Show Answer Correct Answer: C) Cannot be lost. 42. NoSQL databases are less scalable than relational databases. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 43. The property by which subtype entities possess the values of all attributes of a supertype is called. A) Attribute inheritance. B) Class management. C) Multiple inheritance. D) Hierarchy reception. Show Answer Correct Answer: A) Attribute inheritance. 44. Which of the following best describes a homogeneous distributed database? A) A database system where different DBMSs are used across different sites. B) A system where database servers communicate via cloud computing. C) A database where data is stored in multiple backup locations. D) A distributed database where all sites use the same DBMS. Show Answer Correct Answer: D) A distributed database where all sites use the same DBMS. 45. What is a pitfall in relational database design? A) Unique data. B) Simple data. C) Complex data. D) Redundant data. Show Answer Correct Answer: D) Redundant data. 46. Data ..... helps ensure that an incorrect entry isn't made. A) Accuracy. B) Validation. C) Checks. D) Integrity. Show Answer Correct Answer: B) Validation. 47. A database can have only one table.(T/F) A) A. True. B) B. False. C) All the above. D) None of the above. Show Answer Correct Answer: B) B. False. 48. Which of the following is an example of a data integrity constraint? A) Data inconsistency. B) Foreign key. C) Data duplication. D) Data redundancy. Show Answer Correct Answer: B) Foreign key. 49. ..... :Data storage layer. A) Network Tier. B) Presentation Tier. C) Database Tier. D) Application Tier. Show Answer Correct Answer: C) Database Tier. 50. What is data independence in the context of DBMS? A) Data independence refers to the ability to access data without any restrictions. B) Data independence is the ability to change the database schema at one level without affecting other levels. C) Data independence is the process of securing data from unauthorized access. D) Data independence means having multiple copies of the same data. Show Answer Correct Answer: B) Data independence is the ability to change the database schema at one level without affecting other levels. 51. Why is it important to enforce data integrity in a database? A) It is important to enforce data integrity to maintain accuracy, consistency, and reliability of data in a database. B) Data integrity is irrelevant for temporary data storage. C) Enforcing data integrity slows down database performance. D) Data integrity is only important for large databases. Show Answer Correct Answer: A) It is important to enforce data integrity to maintain accuracy, consistency, and reliability of data in a database. 52. What does ER stand for in ER Diagrams? A) Entity Record. B) Entity Report. C) Entity Relation. D) Entity Relationship. Show Answer Correct Answer: D) Entity Relationship. 53. Which of the following is used in the application programs to request data from the database management system? A) Data Manipulation Language. B) Data Definition Language. C) Data Control Language. D) All of the above. Show Answer Correct Answer: A) Data Manipulation Language. 54. Which of the following is NOT a fundamental principle of database security? A) Encryption. B) Authorization. C) Normalization. D) Authentication. Show Answer Correct Answer: C) Normalization. 55. A Database Management System (DBMS) is A) Collection of interrelated data. B) Collection of programs to access data. C) Collection of data describing one particular enterprise. D) All of the above. Show Answer Correct Answer: D) All of the above. 56. What are the different types of DML commands? A) INSERT, UPDATE, DELETE, SELECT. B) CREATE, MODIFY, DROP, SELECT. C) INSERT, UPDATE, REPLACE, SELECT. D) INSERT, UPDATE, REMOVE, QUERY. Show Answer Correct Answer: A) INSERT, UPDATE, DELETE, SELECT. 57. Supertype/subtype relationships should not be used when the instances of a subtype participate in no relationships which are unique to that subtype. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 58. Which of the following database object produces the final result to present? A) Queries. B) Form. C) Table. D) Report. Show Answer Correct Answer: D) Report. 59. Which SQL statement is used to create a new database? A) CREATE DATABASE. B) NEW DATABASE. C) MAKE DATABASE. D) ADD DATABASE. Show Answer Correct Answer: A) CREATE DATABASE. 60. What does ACID stand for in the context of transactions? A) Accuracy, Clarity, Integrity, Dependability. B) Atomicity, Consistency, Isolation, Dependability. C) Atomicity, Concurrency, Isolation, Durability. D) Atomicity, Consistency, Isolation, Durability. Show Answer Correct Answer: D) Atomicity, Consistency, Isolation, Durability. ← 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 8Class 12 Computer Science Chapter 3 Database Management Systems Quiz 9 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books