This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 39 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 39 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. The default ..... id field in MongoDB is of type: A) Integer. B) String. C) ObjectId. D) UUID. Show Answer Correct Answer: C) ObjectId. 2. Which schedule allows commit only after all dependent transactions commit? A) Recoverable schedule. B) Non-recoverable schedule. C) Cascading abort schedule. D) Strict schedule. Show Answer Correct Answer: A) Recoverable schedule. 3. Which type of data includes measurable facts like test scores or visitor numbers? A) Alphabetic. B) Alphanumeric. C) Numerical. D) Symbolic. Show Answer Correct Answer: C) Numerical. 4. Which of the following can be stored in a database? A) Text and numbers. B) Images and audio. C) Videos and documents. D) All of the above. Show Answer Correct Answer: D) All of the above. 5. DML is used for: A) Defining schemas. B) Manipulating data. C) Granting permissions. D) Creating constraints. Show Answer Correct Answer: B) Manipulating data. 6. In an ER model, what does an "entity" typically represent? A) A file system. B) A real-world object like a student or course. C) A field in a record. D) A computer program. Show Answer Correct Answer: B) A real-world object like a student or course. 7. Design view A) A view that allows users to only view data without making changes. B) A view in which you can add, edit, and delete fields from the table, change field types and descriptions, set a primary key, and more. C) A view that displays data in a graphical format without any editing options. D) A view used exclusively for printing reports and summaries. Show Answer Correct Answer: B) A view in which you can add, edit, and delete fields from the table, change field types and descriptions, set a primary key, and more. 8. Which of the following correctly defines a field? A) A request for data from the database. B) A summary of data. C) A collection of related fields in a row. D) A single piece of information in a database. Show Answer Correct Answer: D) A single piece of information in a database. 9. Which of the following best describes a flat file system? A) Hierarchical data storage. B) Simple text-based storage without relations. C) Stores data in a relational manner. D) Uses tables with foreign keys. Show Answer Correct Answer: B) Simple text-based storage without relations. 10. In a table of employees, "Department" field can take only values "HR, " "Finance, " "IT." This set of allowed values is called a: A) Attribute. B) Domain. C) Relation. D) Tuple. Show Answer Correct Answer: B) Domain. 11. What does a column in a database table represent? A) A collection of tables. B) A specific piece of data. C) A group of related fields. D) A single record. Show Answer Correct Answer: B) A specific piece of data. 12. Raw facts which people gather is referred to as ..... A) Information. B) Data. C) Knowledge. D) Wisdom. Show Answer Correct Answer: B) Data. 13. ..... allows multiple users to work on it. A) Normalization. B) Security. C) DBMS. D) None of the above. Show Answer Correct Answer: C) DBMS. 14. Which of the following best describes an entity in an Entity Relationship Diagram (ERD)? A) A relationship between two tables. B) A unique attribute of a table. C) An object or concept about which data is stored. D) A field that contains a foreign key. Show Answer Correct Answer: C) An object or concept about which data is stored. 15. What is the primary function of a DBMS (Database Management System)? A) To perform data analysis. B) To manage the interaction between users and databases. C) To display web content. D) To optimize system hardware. Show Answer Correct Answer: B) To manage the interaction between users and databases. 16. A structured collection of data items that can be accessed by different application programs. A) Database. B) Spreadsheet. C) Text file. D) Data warehouse. Show Answer Correct Answer: A) Database. 17. Fill in the blank: ..... is a non-key attribute, whose values are derived from the primary key of some other table. A) Primary Key. B) Foreign Key. C) Candidate Key. D) Alternate Key. Show Answer Correct Answer: B) Foreign Key. 18. What does atomicity mean in database transactions? A) Breaking transactions into small parts. B) Using atomic data types. C) A transaction should be completed entirely or not at all. D) Processing one transaction at a time. Show Answer Correct Answer: C) A transaction should be completed entirely or not at all. 19. What are the benefits of using forms for data entry? A) Forms eliminate the need for any data validation. B) Forms are only useful for collecting payments. C) Using forms slows down the data entry process. D) Benefits of using forms for data entry include improved data accuracy, consistency, user guidance, and efficiency. Show Answer Correct Answer: D) Benefits of using forms for data entry include improved data accuracy, consistency, user guidance, and efficiency. 20. What does ACID stand for in the context of databases? A) Aggregation, Consistency, Indexing, Data. B) Atomicity, Consistency, Isolation, Durability. C) Access, Change, Integration, Data. D) Analysis, Control, Input, Data. Show Answer Correct Answer: B) Atomicity, Consistency, Isolation, Durability. 21. Why is storage method selection critical in database systems? A) Facilitates the database design process. B) Ensures compatibility with presentation layers. C) Impacts performance, reliability, and cost. D) None of the above. Show Answer Correct Answer: C) Impacts performance, reliability, and cost. 22. What does a one-to-many relationship in a relational database describe? A) A single record in one table is linked to multiple records in another table. B) Multiple records in one table are linked to a single record in another table. C) All records in one table are linked to all records in another table. D) No records are linked between tables. Show Answer Correct Answer: A) A single record in one table is linked to multiple records in another table. 23. What are the four core functions of a DBMS? A) Creating, Deleting, Updating, Viewing. B) Reading, Writing, Storing, Processing. C) Input, Output, Storage, Control. D) Defining, Constructing, Manipulating, Sharing. Show Answer Correct Answer: D) Defining, Constructing, Manipulating, Sharing. 24. ..... is the presence of duplicate data in multiple data files so that the same data are stored in more than one place or location. A) Batch processing. B) Data redundancy. C) Data independence. D) Online processing. Show Answer Correct Answer: B) Data redundancy. 25. What is the meaning of LIKE '%0%0%' A) Feature begins with two 0's. B) Feature ends with two 0's. C) Feature has more than two 0's. D) Feature has two 0's in it, at any position. Show Answer Correct Answer: D) Feature has two 0's in it, at any position. ← 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