This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 84 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 84 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Which of the following is true about a "primary key" ? A) A primary key can be duplicated across multiple records. B) A primary key must always be a composite key. C) A primary key uniquely identifies each record in a table. D) A primary key must be a foreign key. Show Answer Correct Answer: C) A primary key uniquely identifies each record in a table. 2. This is a collection of programs that enables users to create and maintain databases and control all access to them. A) Data. B) Database. C) Database Administrator. D) Database Management System. Show Answer Correct Answer: D) Database Management System. 3. Which of the following best describes NoSQL databases? A) They are always centralized. B) They are designed for unstructured data. C) They require SQL for queries. D) They are only used for small applications. Show Answer Correct Answer: B) They are designed for unstructured data. 4. What does the 'select' clause do in an SQL query? A) Defines the tables to be used. B) Creates a new table. C) Filters the results. D) Specifies the attributes to be returned. Show Answer Correct Answer: D) Specifies the attributes to be returned. 5. What is the most essential element of a database? A) Table. B) Query. C) Form. D) Report. Show Answer Correct Answer: A) Table. 6. A ..... is an organised collection of structured data. A) Information. B) File. C) Database. D) DBMS. Show Answer Correct Answer: C) Database. 7. What do reports provide in a database? A) Printable summaries of information. B) Music playlists. C) Video tutorials. D) Art designs. Show Answer Correct Answer: A) Printable summaries of information. 8. Why are key-value databases useful for tasks that need quick data access? A) They use complex data models. B) They cannot grow quickly. C) They are difficult to understand. D) They have a flexible structure. Show Answer Correct Answer: D) They have a flexible structure. 9. What is a 'relation' in a relational data model? A) A relation is a collection of unrelated data points. B) A relation is a single row in a database table. C) A relation is a table consisting of rows and columns in a relational data model. D) A relation is a set of functions in programming. Show Answer Correct Answer: C) A relation is a table consisting of rows and columns in a relational data model. 10. In a library database, the "MemberID" field in the "Issue Table" refers to "MemberID" in the "Members Table." This is a: A) Foreign Key. B) Primary Key. C) Alternate Key. D) Domain Key. Show Answer Correct Answer: A) Foreign Key. 11. Explain the difference between an entity and an attribute in the context of the entity-relationship model. A) An attribute is a type of entity. B) An entity is a type of attribute. C) An entity and an attribute are the same thing. D) An entity represents a real-world object or concept, while an attribute represents a property or characteristic of that entity. Show Answer Correct Answer: D) An entity represents a real-world object or concept, while an attribute represents a property or characteristic of that entity. 12. Microsoft releases MS access, a custom DBMS that replaces all other custom DBMS products A) 1990. B) 1992. C) 1991. D) 1993. E) 1994. Show Answer Correct Answer: C) 1991. 13. What does the SQL UPDATE command do? A) Creates a new database. B) Deletes existing data. C) Modifies existing data. D) Renames a table. Show Answer Correct Answer: C) Modifies existing data. 14. Relational Algebra is used to query the database tables using A. B. C. D. A) Dbase. B) SQL. C) ER Model. D) Relational model. Show Answer Correct Answer: B) SQL. 15. What data type is used to store 248999, such as whole numbers and decimal numbers? A) Text. B) Date/Time. C) Large Number. D) Number. Show Answer Correct Answer: D) Number. 16. Which database model uses a tree-like structure with parent-child relationships? A) Relational Model. B) Hierarchical Model. C) Network Model. D) Object-Oriented Model. Show Answer Correct Answer: B) Hierarchical Model. 17. What is a unique identifier for a record in a table? A) Index key. B) Foreign key. C) Secondary key. D) Primary key. Show Answer Correct Answer: D) Primary key. 18. Sort A) To organize data alphabetically or in numerical order. B) To randomly arrange data without any order. C) To delete data that is not needed. D) To combine multiple datasets into one. Show Answer Correct Answer: A) To organize data alphabetically or in numerical order. 19. What is the cardinality of a relationship that is one-to-many? A) 1:m. B) M:1. C) M:m. D) 0:1. Show Answer Correct Answer: A) 1:m. 20. Which of the following can database software allow you to create? A) Tables, forms, and reports. B) Only spreadsheets. C) Only images. D) Only emails. Show Answer Correct Answer: A) Tables, forms, and reports. 21. What is an indexed field in a database? A) A field used to speed up searches. B) A field that is automatically updated. C) A field that allows duplicate values. D) A field that stores only numbers. Show Answer Correct Answer: A) A field used to speed up searches. 22. To resize a column in Access, one should: A) Use the View button. B) Click and drag the column border. C) Use Field Templates. D) Press Shift + Enter. Show Answer Correct Answer: B) Click and drag the column border. 23. In a "Students" table, the field "Admission Number" uniquely identifies every student. It is a: A) Foreign Key. B) Primary Key. C) Alternate Key. D) Candidate Key. Show Answer Correct Answer: B) Primary Key. 24. Which of the following is NOT a type of database constraint? A) Primary key constraint. B) Foreign key constraint. C) Unique key constraint. D) Data type constraint. Show Answer Correct Answer: D) Data type constraint. 25. A relational database is defined as a database that ..... A) Stores data in separate but related tables. B) Stores all information in one large table. C) Uses only one primary key per database. D) Cannot be modified once created. Show Answer Correct Answer: A) Stores data in separate but related tables. ← 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