This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 87 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 87 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What is an attribute in an ERD? A) A unique identifier for a record. B) A characteristic or property of an entity. C) A relationship between two entities. D) A field that contains a foreign key. Show Answer Correct Answer: B) A characteristic or property of an entity. 2. Which clause is used to sort the result set of a query? A) WHERE. B) GROUP BY. C) ORDER BY. D) SORT BY. Show Answer Correct Answer: C) ORDER BY. 3. What does DML stand for in databases? A) Data Migration Language. B) Database Management Language. C) Data Modeling Language. D) Data Manipulation Language. Show Answer Correct Answer: D) Data Manipulation Language. 4. Which set lists typical attributes for the Customer table in this schema? A) CustID, title, surname, email. B) ProductID, subject, level, price. C) SubID, startDate, endDate, price. D) OrderID, shipDate, warehouse, city. Show Answer Correct Answer: A) CustID, title, surname, email. 5. When using the Form Wizard, what is NOT a standard option? A) Selecting fields to include. B) Choosing a layout style. C) Creating automatic calculations. D) Selecting the data source. Show Answer Correct Answer: C) Creating automatic calculations. 6. Ava is working on a project where she needs to analyze sales data. What do queries allow her to do with her data? A) View related data and perform calculations. B) Create animations. C) Design websites. D) Write novels. Show Answer Correct Answer: A) View related data and perform calculations. 7. Which data model is used for conceptual database design? A) Relational. B) Network. C) ER model. D) Hierarchical. Show Answer Correct Answer: C) ER model. 8. Deadlock occurs when: A) Transactions execute serially. B) Two transactions wait for each other. C) Commit is delayed. D) DB crashes. Show Answer Correct Answer: B) Two transactions wait for each other. 9. A deletion anomaly occurs when: A) A foreign key is added. B) Deleting data unintentionally removes other related information. C) A table is updated. D) Relationships are removed. Show Answer Correct Answer: B) Deleting data unintentionally removes other related information. 10. Data redundancy leads to ..... A) Data consistency. B) Data inconsistency. C) Data independence. D) Data security. Show Answer Correct Answer: B) Data inconsistency. 11. How is data organized within a record? A) Data is stored as a single block within a record. B) Data is organized into fields within a record. C) Data is organized into tables within a record. D) Data is categorized by types within a record. Show Answer Correct Answer: B) Data is organized into fields within a record. 12. Information in Database A) Processed data that is meaningful and useful to users. B) Raw data that has not been analyzed. C) Data that is stored in a database without context. D) Information that is outdated and irrelevant. Show Answer Correct Answer: A) Processed data that is meaningful and useful to users. 13. Dalam video, kolom 'id ..... nama' pada tabel 'nama ..... siswa' menggunakan tipe data 'VARCHAR(40)'. Apa fungsi dari 'VARCHAR'? A) Menyimpan bilangan bulat. B) Menyimpan tanggal dan waktu. C) Menyimpan teks dengan panjang variabel. D) Menyimpan nilai boolean (benar/salah). Show Answer Correct Answer: C) Menyimpan teks dengan panjang variabel. 14. Which DBMS advantage helps in reducing storage costs and eliminating update anomalies? A) Controlling redundancy. B) Security control. C) Backup and recovery. D) Multiple user interfaces. Show Answer Correct Answer: A) Controlling redundancy. 15. Indicate whether the statement is true or false:A query is a request for data from a database. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 16. Which of the following refers to an entity in which the identifier of one entity includes the identifier of another entity? A) Weak entity. B) Strong entity. C) ID-dependent entity. D) ID-independent entity. Show Answer Correct Answer: C) ID-dependent entity. 17. What is a data model? A) A report. B) A conceptual blueprint. C) A table. D) A keyboard layout. Show Answer Correct Answer: B) A conceptual blueprint. 18. What SQL command is used to create a trigger? A) ADD TRIGGER. B) INSERT TRIGGER. C) MODIFY TRIGGER. D) CREATE TRIGGER. Show Answer Correct Answer: D) CREATE TRIGGER. 19. Which of the following options states the importance of data modeling? A) It helps in organizing and securing data. B) It ensures medical professionals are trained. C) It guarantees patient confidentiality. D) It reduces the need for technology. Show Answer Correct Answer: A) It helps in organizing and securing data. 20. What is the maximum size of a single BSON document in MongoDB? A) 1 MB. B) 16 MB. C) 32 MB. D) 64 MB. Show Answer Correct Answer: B) 16 MB. 21. What characterizes a flat-file database? A) It stores data using multiple linked tables. B) It stores all data items using one table. C) It involves a diagram illustrating relationships. D) It includes automatic validation checks. Show Answer Correct Answer: B) It stores all data items using one table. 22. Kemar is organizing his computer. What is the difference between a file and a folder? A) A file contains other files, while a folder stores data. B) A folder contains files, while a file stores specific data. C) A file is larger than a folder. D) A folder is always smaller than a file. Show Answer Correct Answer: B) A folder contains files, while a file stores specific data. 23. A school keeps a register where each student's name, roll number, and marks are written. This register is an example of a: A) Program. B) Database. C) Application. D) Spreadsheet. Show Answer Correct Answer: B) Database. 24. Why might Subscription include both startDate and endDate fields? A) Track the active period of a subscription. B) Store the customer's full legal name. C) Calculate the static product attributes. D) Hold the product's academic difficulty level. Show Answer Correct Answer: A) Track the active period of a subscription. 25. List one advantage of using Structured Query Language (SQL). A) SQL provides a standardized way to manage and query relational databases. B) SQL requires complex programming skills. C) SQL is limited to non-relational databases. D) SQL is only used for data visualization. Show Answer Correct Answer: A) SQL provides a standardized way to manage and query relational databases. ← 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