This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 61 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 61 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What is a query in a database? A) A column in a table. B) A row in a table. C) A request for data. D) A type of report. Show Answer Correct Answer: C) A request for data. 2. Kemar is organizing a library database and needs to ensure each book can be uniquely identified. Which field should he use to uniquely identify a record in the table? A) Primary key. B) Foreign key. C) Duplicate key. D) Search key. Show Answer Correct Answer: A) Primary key. 3. Which of the following is a guideline for naming tables? A) Use only numbers. B) Use spaces. C) Use letters, numbers, and underscores. D) Use lowercase letters only. Show Answer Correct Answer: C) Use letters, numbers, and underscores. 4. Which type of database designer focuses on conceptual and logical design? A) Physical Database Designer. B) Application Designer. C) Logical Database Designer. D) System Designer. Show Answer Correct Answer: C) Logical Database Designer. 5. What is the first step in using a database? A) Generating reports. B) Creating its structure. C) Importing data. D) Running queries. Show Answer Correct Answer: B) Creating its structure. 6. Which architecture uses a single database on a single server? A) Distributed DBMS. B) Centralized DBMS. C) Client/Server DBMS. D) Cloud DBMS. Show Answer Correct Answer: B) Centralized DBMS. 7. The SERIAL keyword in PostgreSQL is used for: A) String concatenation. B) Auto-increment integer values. C) Setting default values. D) Creating foreign keys. Show Answer Correct Answer: B) Auto-increment integer values. 8. DBMS is mainly used to ..... A) Design hardware. B) Manage databases. C) Control operating systems. D) Compile programs. Show Answer Correct Answer: B) Manage databases. 9. What is the main purpose of a Transaction Processing System (TPS)? A) To analyze data. B) To provide information for managing organizations. C) To support decision-making. D) To handle daily transactions of an organization. Show Answer Correct Answer: D) To handle daily transactions of an organization. 10. The status of a relational database in which entities do not contain repeated groups of attributes. A) Second normal form (2NF). B) Third normal form (3NF). C) First normal form (1NF). D) Boyce-Codd normal form (BCNF). Show Answer Correct Answer: C) First normal form (1NF). 11. Given a table "students" with columns "id", "name", and "age", which is the correct syntax to insert a new record? A) INSERT INTO students VALUES (1, 'Alice', 20);. B) INSERT students (id, name, age) VALUES (1, 'Alice', 20);. C) ADD INTO students (id, name, age) VALUES (1, 'Alice', 20);. D) INSERT students (1, 'Alice', 20);. Show Answer Correct Answer: A) INSERT INTO students VALUES (1, 'Alice', 20);. 12. What is the main advantage of using a relational database over a flat file database? A) Lower cost of implementation. B) Simplicity in data management. C) Easier to create. D) Support for complex relationships. Show Answer Correct Answer: D) Support for complex relationships. 13. What is the purpose of a query processor in a DBMS? A) To design data models. B) To process and execute queries. C) To manage data dictionary entries. D) To create databases. Show Answer Correct Answer: B) To process and execute queries. 14. The underlying software that implement DBMS function is called data ..... A) Base. B) Constraint. C) Engine. D) Type. Show Answer Correct Answer: C) Engine. 15. In a three-tier architecture, which tier is responsible for business logic? A) Presentation Tier. B) Data Tier. C) Application Tier. D) Client Tier. Show Answer Correct Answer: C) Application Tier. 16. The Chen Notation ER model uses this symbol to represent weak entity set? A) Dotted rectangle. B) Diamond. C) Doubly outlined rectangle. D) None of these. Show Answer Correct Answer: C) Doubly outlined rectangle. 17. What is used if a postcode needs to have particular format, such as LL09 0LL? A) Input mask. B) Range check. C) Value lookup. D) Presence check. Show Answer Correct Answer: A) Input mask. 18. Ankit is designing a table in MS Access. Each column in his table is referred to as a: A) Field. B) Record. C) Query. D) Report. Show Answer Correct Answer: A) Field. 19. When data is sorted in ascending order, which value would appear first for age? A) 35. B) 20. C) 65. D) 50TagsDOK Level 2:Skill/Concept. Show Answer Correct Answer: B) 20. 20. How does a database management system (DBMS) improve data integrity? A) By allowing anyone to modify the data. B) By using complex algorithms to store data. C) By enforcing rules and constraints on the data entered. D) By storing data in a single locationTagsDOK Level 3:Strategic Thinking. Show Answer Correct Answer: C) By enforcing rules and constraints on the data entered. 21. Which type of entity cannot exist in the database unless another type of entity also exists in the database, but does not require that the identifier of that other entity be included as part of its own identifier? A) Weak entity X. B) Strong entity X. C) O ID-dependent entity X. D) ID-independent entity. Show Answer Correct Answer: A) Weak entity X. 22. Which aggregate function calculates average values? A) SUM(). B) AVG(). C) COUNT(). D) MAX(). Show Answer Correct Answer: B) AVG(). 23. Which model is faster to access data? A) ER model. B) Object. C) Relational model. D) Network database model. Show Answer Correct Answer: D) Network database model. 24. Define the term 'primary key' in a database. A) A primary key is a unique identifier for a record in a database table. B) A primary key is a type of foreign key in a database. C) A primary key is used to store large binary data in a database. D) A primary key can contain duplicate values in a table. Show Answer Correct Answer: A) A primary key is a unique identifier for a record in a database table. 25. Referring to the ER diagram, what is a "relationship" ? A) A relationship involves two or more entities and is used to represent an interaction or association. B) A unique identity for each instance of the entity. C) The minimum number of attributes combined to achieve this goal. D) The rules and restrictions that apply to the data. Show Answer Correct Answer: A) A relationship involves two or more entities and is used to represent an interaction or association. ← 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