This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 28 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 28 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Which of the following is not a function of a database system? A) Storing data securely. B) Retrieving data efficiently. C) Managing user permissions. D) Providing user interface design. Show Answer Correct Answer: D) Providing user interface design. 2. What is the purpose of a report in MS Access? A) To edit table data. B) To display and print data in a structured format. C) To create new tables. D) To establish table relationships. Show Answer Correct Answer: B) To display and print data in a structured format. 3. Which of the following describes a many-to-many relationship? A) One record in the first table relates to multiple records in the second table. B) Multiple records in the first table relate to multiple records in the second table. C) One record in the first table relates to one record in the second table. D) Multiple records in the first table relate to one record in the second table. Show Answer Correct Answer: B) Multiple records in the first table relate to multiple records in the second table. 4. Why is it important to create an appropriate database structure? A) It is important to create an appropriate database structure to ensure data integrity, optimize performance, and facilitate efficient data retrieval. B) To make the database visually appealing. C) To reduce the size of the database files. D) To ensure all data is stored in a single table. Show Answer Correct Answer: A) It is important to create an appropriate database structure to ensure data integrity, optimize performance, and facilitate efficient data retrieval. 5. Describe the difference between a database and a data warehouse. A) A database is used for data backup, while a data warehouse is for data entry. B) A database is for real-time transactions, while a data warehouse is for analytical processing of historical data. C) A database stores only historical data, while a data warehouse handles real-time transactions. D) A database is a type of data warehouse that focuses on big data analysis. Show Answer Correct Answer: B) A database is for real-time transactions, while a data warehouse is for analytical processing of historical data. 6. Which of the following actions can be performed when modifying a table structure? A) Adding or deleting fields. B) Changing field definitions. C) Establishing a primary key. D) All of the above. Show Answer Correct Answer: D) All of the above. 7. What is the main function of update operations in a database? A) To delete data. B) To modify existing data. C) To retrieve data. D) To create new data. Show Answer Correct Answer: B) To modify existing data. 8. What is one advantage of using the database approach? A) Increased redundancy in data storage. B) Limited access to data. C) Higher costs for data management. D) Easier data sharing among multiple users. Show Answer Correct Answer: D) Easier data sharing among multiple users. 9. The collection of information that describes tables, attributes, constraints, indexes and other database objects is called: A) Application log. B) Metadata (data dictionary / system catalog). C) Transaction file. D) Shadow copy. Show Answer Correct Answer: B) Metadata (data dictionary / system catalog). 10. A foreign key: A) References a primary key in another table. B) Is used to delete tables. C) Can only contain unique values. D) Cannot store numerical values. Show Answer Correct Answer: A) References a primary key in another table. 11. Which of the following is NOT a purpose of a DBMS in a business setting? A) To better serve customers. B) To make better decisions. C) To improve business processes. D) To store information about social media users. Show Answer Correct Answer: D) To store information about social media users. 12. Which ACID property ensures that once a transaction is committed, it will remain so even in the event of power loss or system failure? A) Atomicity. B) Consistency. C) Isolation. D) Durability. Show Answer Correct Answer: D) Durability. 13. In a database of students, which of the following could be a suitable primary key? A) Student name. B) Student ID number. C) Student's favorite subject. D) Student's birthdateTagsLO3. Show Answer Correct Answer: B) Student ID number. 14. What is the purpose of SQL in databases? A) To retrieve information efficiently. B) To create databases. C) To secure data. D) To manage user access. Show Answer Correct Answer: A) To retrieve information efficiently. 15. Consider a table with attributes A, B, C, D, E and the following functional dependencies:A$\rightarrow$B, B$\rightarrow$C, C$\rightarrow$D, and A$\rightarrow$E. Which normal form is the table currently in? A) 1NF. B) 2NF. C) 3NF. D) BCNF. Show Answer Correct Answer: A) 1NF. 16. Which of the following is an example of selecting different queries in a database? A) Choosing between SELECT, UPDATE, and DELETE statements. B) Changing the data type of a column. C) Adding a new user to the database. D) Backing up the database. Show Answer Correct Answer: A) Choosing between SELECT, UPDATE, and DELETE statements. 17. What is a relationship in database applications? A) An automatic check for data entry. B) A feature for linking tables together. C) A diagram representing database structure. D) A table of data items. Show Answer Correct Answer: B) A feature for linking tables together. 18. Juvante is managing a library database. What is the purpose of a query in this database? A) To delete records permanently. B) To ask questions and retrieve specific information from a table. C) To create new tables automatically. D) To back up the database. Show Answer Correct Answer: B) To ask questions and retrieve specific information from a table. 19. Which SQL command is used to remove a record from a table? A) DELETE. B) TRUNCATE. C) DROP. D) REMOVE. Show Answer Correct Answer: A) DELETE. 20. Which SQL statement correctly performs an inner join between Customer (alias c) and Order (alias o) on customerId? A) SELECT * FROM Customer c, Order o;. B) SELECT * FROM Customer c INNER JOIN Order o;. C) SELECT * FROM Customer c INNER JOIN Order o ON c.customerId = o.customerId;. D) SELECT * FROM Customer c NATURAL JOIN;. Show Answer Correct Answer: C) SELECT * FROM Customer c INNER JOIN Order o ON c.customerId = o.customerId;. 21. A transaction reads a row. Another transaction modifies and commits a change to that same row. When the first transaction reads the row again, it gets a different value. What is this phenomenon called? A) Dirty Read. B) Non-Repeatable Read. C) Phantom Read. D) Deadlock. Show Answer Correct Answer: B) Non-Repeatable Read. 22. In a client/server DBMS, the server is responsible for: A) Processing business logic. B) Handling user input. C) Managing database storage and queries. D) Running applications. Show Answer Correct Answer: C) Managing database storage and queries. 23. In the context of data mining, the term associations refers to ..... A) Events linked over time. B) Patterns that describe a group to which an item belongs. C) Occurrences linked to a single event. D) Undiscovered groupings. Show Answer Correct Answer: C) Occurrences linked to a single event. 24. What is the role of a foreign key in a database? A) To uniquely identify rows. B) To store encrypted values. C) To link related tables. D) To back up primary keys. Show Answer Correct Answer: C) To link related tables. 25. What does a relationship in a database do? A) Connects two entities. B) Stores data. C) Deletes data. D) Creates a new database. Show Answer Correct Answer: A) Connects two entities. ← 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