This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 86 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 86 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What is the role of database transactions in ensuring data integrity? A) Database transactions have no impact on data integrity. B) Database transactions ensure data consistency, isolation, durability, and atomicity, thereby maintaining data integrity. C) Database transactions are only used for data deletion in a database. D) Database transactions are not relevant in ensuring data integrity. Show Answer Correct Answer: B) Database transactions ensure data consistency, isolation, durability, and atomicity, thereby maintaining data integrity. 2. What is the purpose of a relationship in a database? A) To link tables together. B) To delete redundant records. C) To store multimedia files. D) To create queries automatically. Show Answer Correct Answer: A) To link tables together. 3. Which of the following statements about foreign keys is true? A) A foreign key must reference a primary key in the same table. B) A foreign key establishes a relationship between two tables. C) A foreign key can only reference a composite key. D) A foreign key is used to enforce unique constraints on the referenced column. Show Answer Correct Answer: B) A foreign key establishes a relationship between two tables. 4. How do you change the name of a table in SQL? A) RENAME TABLE employees TO staff;. B) ALTER TABLE employees TO staff;. C) UPDATE TABLE employees SET name = staff;. D) RENAME employees AS staff;. Show Answer Correct Answer: A) RENAME TABLE employees TO staff;. 5. Which of the following is not one of the benefits of a blockchain database? A) It enables the ability to use relational databases. B) It prevents data from being altered retroactively. C) It allows administrators to manage data more effectively. D) It enables firms to create and verify transactions on a network very rapidly. Show Answer Correct Answer: A) It enables the ability to use relational databases. 6. What does the ASCII character set do? A) It processes binary numbers into text. B) It assigns a binary code to each letter, number, or symbol. C) It organizes large amounts of data into databases. D) It helps format Excel tables. Show Answer Correct Answer: B) It assigns a binary code to each letter, number, or symbol. 7. True or False:In the Courses table, the column CourseName is an attribute, and values like 'Data Structures', 'Algorithms' are part of its domain. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 8. Which system stores data in separate application files? A) DBMS. B) Database system. C) File system. D) Data model. Show Answer Correct Answer: C) File system. 9. In the context of a university database, what does the 'Exams Table' contain? A) Student ID, Course ID, Score, Grade. B) Lecturer ID, Name, Department. C) Course ID, Course Name, Lecturer. D) Student ID, Name, Age. Show Answer Correct Answer: A) Student ID, Course ID, Score, Grade. 10. A form is used to view and enter data into a database table. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 11. Which one of the following is an example for RDBMS? A) Dbase. B) FoxPro. C) Oracle. D) All the above. Show Answer Correct Answer: C) Oracle. 12. What is a composite attribute? A) An attribute with multiple values. B) An attribute that is derived from others. C) An attribute composed of multiple sub-parts. D) None of the above. Show Answer Correct Answer: C) An attribute composed of multiple sub-parts. 13. What data type is used to store numeric data that is larger than 8 bytes, such as currency values? A) Currency. B) Number. C) Large Number. D) Date/Time. Show Answer Correct Answer: C) Large Number. 14. What is normalization? A) Organizing data into multiple related tables. B) Deleting all redundant data. C) Adding more data to a table. D) Changing data formats. Show Answer Correct Answer: A) Organizing data into multiple related tables. 15. How does a foreign key differ from a primary key? A) A primary key is optional; a foreign key is always required in a table. B) A primary key uniquely identifies records; a foreign key links to a primary key in another table. C) A primary key can be null; a foreign key must always be unique. D) A primary key can link to multiple tables; a foreign key is unique to one table. Show Answer Correct Answer: B) A primary key uniquely identifies records; a foreign key links to a primary key in another table. 16. Which feature helps in creating a basic form quickly? A) Query Wizard. B) Form Wizard. C) Table Wizard. D) Report Wizard. Show Answer Correct Answer: B) Form Wizard. 17. Which type of data is best stored in a relational database? A) Random data. B) Structured data. C) Semi-structured data. D) Non-structured data. Show Answer Correct Answer: B) Structured data. 18. Which SQL statement would you use to remove a student from a database? A) UPDATE. B) DELETE. C) INSERT. D) SELECT. Show Answer Correct Answer: B) DELETE. 19. Two-phase locking protocol ensures: A) Deadlock freedom. B) Serializability. C) Durability. D) Atomicity. Show Answer Correct Answer: B) Serializability. 20. The statement in SQL which changes the definition of a table A) Alter. B) Update. C) Create. D) Select. Show Answer Correct Answer: A) Alter. 21. In a database, what is a record? A) A unit of information consisting of a set of fields. B) A collection of database files. C) The software used to create a database. D) A method to search data in a database. Show Answer Correct Answer: A) A unit of information consisting of a set of fields. 22. Collection of multipleinterconnected databases, spread physically across various locations. A) Centralized Database System. B) Distributed Database System. C) Centered Database System. D) Distribution Database System. Show Answer Correct Answer: B) Distributed Database System. 23. Which of the following best describes MongoDB? A) Relational database. B) Document-oriented NoSQL database. C) Graph database. D) Key-value store. Show Answer Correct Answer: B) Document-oriented NoSQL database. 24. A database is a collection of ..... that can be organized, sorted, and searched. A) Fields. B) Records. C) Data. D) Tables. Show Answer Correct Answer: C) Data. 25. What is the difference between data validation and data verification? A) Validation is done periodically, verification is done once. B) Both processes are the same. C) Validation checks entered data, verification checks original data. D) Validation checks original data, verification checks entered data. Show Answer Correct Answer: C) Validation checks entered data, verification checks original data. ← PreviousNext →Related QuizzesClass 11 Computer Science Chapter 7 Database Concepts Quiz 1Class 11 Computer Science Chapter 7 Database Concepts Quiz 2Class 11 Computer Science Chapter 7 Database Concepts Quiz 3Class 11 Computer Science Chapter 7 Database Concepts Quiz 4Class 11 Computer Science Chapter 7 Database Concepts Quiz 5Class 11 Computer Science Chapter 7 Database Concepts Quiz 6Class 11 Computer Science Chapter 7 Database Concepts Quiz 7Class 11 Computer Science Chapter 7 Database Concepts Quiz 8Class 11 Computer Science Chapter 7 Database Concepts Quiz 9Class 11 Computer Science Chapter 7 Database Concepts Quiz 10 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books