This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 13 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 13 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What is a row in a database? A) A single file. B) A single image. C) A single folder. D) A single unit of data. Show Answer Correct Answer: D) A single unit of data. 2. Can a database have multiple primary keys? A) Yes, a database can have multiple primary keys. B) No, a database cannot have multiple primary keys. C) A primary key can be composed of multiple columns in a database. D) A database can have one primary key per table. Show Answer Correct Answer: B) No, a database cannot have multiple primary keys. 3. Which of the following database structures uses a tree-like format to store data? A) Hierarchical database. B) Network database. C) Relational database. D) Graph database. Show Answer Correct Answer: A) Hierarchical database. 4. Which of the following statements about big data is not true? A) Big data refers solely to data in the petabyte range. B) Big data can reveal more patterns and interesting relationships than smaller data sets. C) Big data are produced in much larger quantities and much more rapidly than traditional data. D) Big data is finding many uses in the public sector. Show Answer Correct Answer: A) Big data refers solely to data in the petabyte range. 5. Which SQL command delete all the records and does not remove the structure? A) Drop. B) Insert. C) Truncate. D) None of the above. Show Answer Correct Answer: C) Truncate. 6. Thierry is designing a database for a school project. He needs to decide how many Primary keys a table can have. How many can he choose? A) Only 1. B) Only 2. C) Depends on number of columns. D) Depends on DBA. Show Answer Correct Answer: A) Only 1. 7. A report is needed to display student names, class names, and their assigned teachers. What must be done first? A) Create a query joining Students, Classes, and Teachers tables. B) Create a new table for reports. C) Enter the data manually. D) Print each table separately. Show Answer Correct Answer: A) Create a query joining Students, Classes, and Teachers tables. 8. How can graphics be added to a form in MS Access? A) Through the Form Wizard only. B) Using the Insert Image control. C) By copying from Excel only. D) Through query design. Show Answer Correct Answer: B) Using the Insert Image control. 9. What is the main function of reports in a database? A) To automate tasks. B) To present data in different views and formats. C) To change data. D) To retrieve data. Show Answer Correct Answer: B) To present data in different views and formats. 10. What is a "column" in the context of a table? A) A vertical set of data representing an attribute. B) A foreign key. C) A SQL query. D) A relationship between two tables. Show Answer Correct Answer: A) A vertical set of data representing an attribute. 11. Which of the following describes a "row" in a relational database? A) A unique identifier for a table. B) A single, complete set of related data in a table. C) A query that selects specific records. D) A command used to create a database schema. Show Answer Correct Answer: B) A single, complete set of related data in a table. 12. Data cleansing not only corrects errors but also ..... A) Establishes logical relationships between data. B) Structures data. C) Normalizes data. D) Enforces consistency among different sets of data that originated in a separate information system. Show Answer Correct Answer: D) Enforces consistency among different sets of data that originated in a separate information system. 13. When each entity in the entity set may not occur in at least one relationship in that relationship set, is called: A) Partial Participation. B) Total Participation. C) Conditional Participation. D) Relational Participation. Show Answer Correct Answer: A) Partial Participation. 14. This is a software that controls the storage, organization, and retrieval of data. A) Database. B) DBMS. C) Data. D) Information. Show Answer Correct Answer: B) DBMS. 15. What is the purpose of normalization in databases? A) The goal of normalization is to enhance data retrieval speed and reduce storage. B) Normalization is used to simplify database design and eliminate all relationships. C) Normalization aims to increase data duplication and decrease integrity. D) The purpose of normalization is to reduce data redundancy and improve data integrity. Show Answer Correct Answer: D) The purpose of normalization is to reduce data redundancy and improve data integrity. 16. What is metadata? A) Raw data collected. B) Data about data. C) Data that is processed. D) Data stored in a database. Show Answer Correct Answer: B) Data about data. 17. What is a data dictionary? A) A control for formatting data input. B) A table that represents the structure of a database table at the design stage. C) An automatic check to reduce errors. D) A primary key in another table. Show Answer Correct Answer: B) A table that represents the structure of a database table at the design stage. 18. What data type is used to store 09/11/2023 values? A) Date/Time Extended. B) Currency. C) Date/Time. D) Number. Show Answer Correct Answer: C) Date/Time. 19. Which key is selected from a set of candidate keys to uniquely identify a record? A) Composite key. B) Primary key. C) Foreign key. D) Secondary key. Show Answer Correct Answer: B) Primary key. 20. What is the purpose of data modeling? A) To help programmers and others understand the complex flow of data within an organization. B) To create new programming languages. C) To manage network security. D) To design hardware components. Show Answer Correct Answer: A) To help programmers and others understand the complex flow of data within an organization. 21. How would you sort the results of a query in descending order by the column "score" ? A) ORDER BY score ASC. B) ORDER BY score DESC. C) SORT score DESCENDING. D) GROUP BY score DESC. Show Answer Correct Answer: B) ORDER BY score DESC. 22. A ..... database is designed for handling large-scale and unstructured data. A) NoSQL. B) Relational. C) Hierarchical. D) Network. Show Answer Correct Answer: A) NoSQL. 23. Berikut ini perintah yang ada pada Data Control Language adalah ..... A) Grant. B) Revoke. C) Truncate. D) Grant and Revoke. E) Revoke and Truncate. Show Answer Correct Answer: D) Grant and Revoke. 24. What does the LIKE operator do in a query? A) Searches for a specific pattern in a field. B) Deletes records. C) Sorts data in descending order. D) Adds new records automatically. Show Answer Correct Answer: A) Searches for a specific pattern in a field. 25. What does normalization aim to achieve? A) Combine all data into one table. B) Increase data complexity. C) Maximize data storage. D) Minimize redundancy and dependency. Show Answer Correct Answer: D) Minimize redundancy and dependency. ← 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