This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 81 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 81 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Which of the following is a characteristic of a foreign key? A) It must be unique within its table. B) It can be null. C) It is used to link two tables together. D) It is always a number. Show Answer Correct Answer: C) It is used to link two tables together. 2. In SQL, which command is used to update existing row in a table? A) Insert. B) Delete. C) Update. D) None of the above. Show Answer Correct Answer: C) Update. 3. Which of the following is NOT a way to speed up a relational database? A) Storing everything in a single table. B) Using data normalization. C) Limiting the number of results in a query. D) Creating an optimized database structure. Show Answer Correct Answer: A) Storing everything in a single table. 4. In a relational database, what does normalization help to achieve? A) Increase redundancy. B) Improve performance. C) Reduce data anomalies. D) Simplify queries. Show Answer Correct Answer: C) Reduce data anomalies. 5. Which type of schedule may cause cascading aborts? A) Strict schedule. B) Serial schedule. C) Recoverable schedule. D) Non-recoverable schedule. Show Answer Correct Answer: D) Non-recoverable schedule. 6. Jahmar is designing a database for his school project. Which view should he use to create a primary key? A) Design View. B) Datasheet View. C) Print View. D) Query View. Show Answer Correct Answer: A) Design View. 7. Three-schema architecture improves: A) Redundancy. B) Data independence. C) Data inconsistency. D) Query speed. Show Answer Correct Answer: B) Data independence. 8. In a one-to-many relationship, the entity that is on the one side of the relationship is called a(n) entity. A) Parent. B) Child. C) Instance. D) Subtype. Show Answer Correct Answer: A) Parent. 9. Which normal form is achieved when a table is in 2NF and no non-prime attribute is transitively dependent on the primary key? A) First Normal Form (1NF). B) Second Normal Form (2NF). C) Third Normal Form (3NF). D) None of the above. Show Answer Correct Answer: C) Third Normal Form (3NF). 10. ..... is used to store a logically related data. A) File. B) Database. C) Data model. D) DBMS. Show Answer Correct Answer: B) Database. 11. Number of rows in a relation is called its ..... A) Degree. B) Cardinality. C) Attribute. D) None of these. Show Answer Correct Answer: B) Cardinality. 12. The language used in application programs to request data from the DBMS is referred to as the A) DML. B) DDL. C) DCL. D) None of the above. Show Answer Correct Answer: A) DML. 13. Which of the following is an example of an aggregate function in SQL? A) SELECT. B) JOIN. C) COUNT. D) INSERT. Show Answer Correct Answer: C) COUNT. 14. .... is never directly stored in the database. A) Data. B) Information. C) Software. D) Table. Show Answer Correct Answer: A) Data. 15. Indicate whether the statement is true or false:Relational DBMSs use key field rules to ensure that relationships between coupled tables remain consistent. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 16. What is a characteristic of a distributed database? A) It consists of multiple databases connected across locations. B) It is stored in a single location. C) It cannot be accessed remotely. D) It is only used by small organizations. Show Answer Correct Answer: A) It consists of multiple databases connected across locations. 17. Help Priya to display sname and sales of east and west areas A) Select sname, sales from Salesman where area="East" and area="West";. B) Select sname, sales from Salesman where area="East" or area="West";. C) Select sname, sales from Salesman where area in "East" and "West";. D) Select sname, sales from Salesman where area="East" , "West";. Show Answer Correct Answer: B) Select sname, sales from Salesman where area="East" or area="West";. 18. What is a foreign key and how is it used? A) A foreign key is a type of index that speeds up queries. B) A foreign key is a field in one table that links to the primary key of another table, establishing a relationship between the two. C) A foreign key is a unique identifier for a table. D) A foreign key is a field that contains only numeric values. Show Answer Correct Answer: B) A foreign key is a field in one table that links to the primary key of another table, establishing a relationship between the two. 19. Which model is typically associated with the conceptual level of a database? A) Physical Data Model. B) Relational Data Model. C) View Data Model. D) Schema Model. Show Answer Correct Answer: B) Relational Data Model. 20. Which of the following would most likely occur at the conceptual level of database design? A) Optimization of disk I/O access patterns. B) Defining user permissions for individual columns. C) Describing logical structure of the entire database independent of physical considerations. D) Writing SQL queries to display data. Show Answer Correct Answer: C) Describing logical structure of the entire database independent of physical considerations. 21. Which database object is used to create a user-friendly interface for entering and viewing data? A) Query. B) Table. C) Form. D) Report. Show Answer Correct Answer: C) Form. 22. If a database administrator needs to delete a specific student's record, why is a relational database more reliable than a flat-file database? A) Relational databases prevent any data from being deleted by mistake. B) Data is stored in one place, so it is less likely to be overlooked or require multiple deletions. C) Relational databases automatically back up data before every deletion. D) Flat-file databases do not support the deletion of individual rows. Show Answer Correct Answer: B) Data is stored in one place, so it is less likely to be overlooked or require multiple deletions. 23. The column which has unique values in all the rows but is not a primary key is called ..... key. A) Candidate. B) Alternate. C) Composite. D) Foreign. Show Answer Correct Answer: B) Alternate. 24. How is the result set sorted in ascending order using a SELECT statement? A) ASC. B) DESC. C) ORDER BY. D) SORT ASCENDING. Show Answer Correct Answer: C) ORDER BY. 25. Which database system is ideal for graph-based applications? A) Relational DBMS. B) Document-based DBMS. C) Graph DBMS. D) Hierarchical DBMS. Show Answer Correct Answer: C) Graph DBMS. ← 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