This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 68 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 68 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. How does data integrity differ between relational and non-relational databases? A) Relational databases enforce data integrity through constraints, while non-relational databases may not have strict integrity rules. B) Relational databases do not support data integrity at all. C) Data integrity is not a concern in either type of database. D) Non-relational databases always ensure better data integrity than relational databases. Show Answer Correct Answer: A) Relational databases enforce data integrity through constraints, while non-relational databases may not have strict integrity rules. 2. Which SQL clause groups rows based on column values? A) ORDER BY. B) GROUP BY. C) HAVING. D) WHERE. Show Answer Correct Answer: B) GROUP BY. 3. All of the following meets database objectives except A) To control redundancy. B) To standardize data storage. C) To prevent sharing of data. D) To maintain data integrity. Show Answer Correct Answer: C) To prevent sharing of data. 4. Which of the following is NOT a type of database performance tuning technique? A) Indexing. B) Query optimization. C) Normalization. D) Data compression. Show Answer Correct Answer: C) Normalization. 5. Which command is used to insert new data into a table? A) DELETE. B) UPDATE. C) ADD. D) INSERT. Show Answer Correct Answer: D) INSERT. 6. Which of the following is an example of a foreign key in a database? A) A customer's name. B) An order's date. C) A student's last name. D) A product's name. Show Answer Correct Answer: C) A student's last name. 7. What is the best solution to data anomalies? A) Adding more tables. B) Database normalization. C) Deleting all duplicate records manually. D) Avoiding foreign keys. Show Answer Correct Answer: B) Database normalization. 8. When creating a foreign key relationship, which of the following statements is true? A) The foreign key must have the same name as the primary key in the referencing table. B) The foreign key and primary key must be of different data types. C) The foreign key must have a unique index applied to it. D) The foreign key can be null in the referencing table. Show Answer Correct Answer: A) The foreign key must have the same name as the primary key in the referencing table. 9. ..... managing the license keys managing user accounts and access etc. A) GIS. B) DBA. C) GAP. D) None of the these. Show Answer Correct Answer: B) DBA. 10. Which architecture involves multiple database servers? A) Client/Server. B) Centralized. C) Flat file. D) In-memory. Show Answer Correct Answer: A) Client/Server. 11. A group of columns serving as a primary key are known as ..... key A) Candidate. B) Composite. C) Alternate. D) Foreign. Show Answer Correct Answer: B) Composite. 12. Which data type can store up to 255 characters? A) Text. B) Date/Time. C) Long Text. D) Number. Show Answer Correct Answer: A) Text. 13. The relational model represents data in the form of ..... A) Trees. B) Graphs. C) Tables. D) Files. Show Answer Correct Answer: C) Tables. 14. A contains the smallest unit of meaningful data, so you might call it the basic building block for a data file. A) Record. B) Field. C) Table. D) None of the above. Show Answer Correct Answer: B) Field. 15. A database where the data items are linked by internal pointers. A) Relational database. B) Flat file database. C) Object-oriented database. D) Hierarchical database. Show Answer Correct Answer: A) Relational database. 16. What is the purpose of a NOT NULL constraint in a database? A) To allow fields to be left blank. B) To ensure a value must be entered into a field. C) To prevent duplicate records. D) To format data automatically. Show Answer Correct Answer: B) To ensure a value must be entered into a field. 17. A data structure built from one or more columns in a database table to speed up searching for data. A) Index (database). B) Table (database). C) View (database). D) Schema (database). Show Answer Correct Answer: A) Index (database). 18. Which operator is used for pattern matching in PostgreSQL? A) LIKE. B) MATCHES. C) PATTERN. D) CONTAINS. Show Answer Correct Answer: A) LIKE. 19. Which statement about tables in MS Access is correct? A) Tables can only contain text data. B) Tables are the fundamental building blocks of a database. C) Tables cannot be related to each other. D) Tables can only have 10 fields maximum. Show Answer Correct Answer: B) Tables are the fundamental building blocks of a database. 20. An ad hoc query is a ..... A) Pre-scheduled question. B) Spur-of-the-moment question. C) Pre-planned question. D) Question that will not return any results. Show Answer Correct Answer: B) Spur-of-the-moment question. 21. A database table has a field called "Grade" set as Number. Which of these values would cause an error? A) 95. B) 100. C) A+. D) 67. Show Answer Correct Answer: C) A+. 22. Which of the following is not a step in creating a file in MS Access? A) Opening the software. B) Clicking the "Create" button. C) Formatting text in bold. D) Entering data into fields. Show Answer Correct Answer: C) Formatting text in bold. 23. What are the three design levels of data modeling? A) Conceptual, Logical, Physical. B) Design, Implementation, Delivery. C) Input, Processing, Output. D) None of the above. Show Answer Correct Answer: A) Conceptual, Logical, Physical. 24. Which of the following operation is used if we are interested in only certain columns of a table? A) PROJECTION. B) SELECTION. C) UNION. D) JOIN. Show Answer Correct Answer: A) PROJECTION. 25. What is the purpose of data integrity in databases? A) To ensure accuracy and consistency of data. B) To simplify data storage. C) To increase data redundancy. D) To eliminate the need for keys. Show Answer Correct Answer: A) To ensure accuracy and consistency of 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