This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 34 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 34 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What is the purpose of a Secondary Key in a database table? A) To uniquely identify each record in a table. B) To allow the database to be searched quickly. C) To store data in a hierarchical format. D) To encrypt database information. Show Answer Correct Answer: B) To allow the database to be searched quickly. 2. What type of lock allows multiple transactions to read but prevents any write operations? A) Exclusive Lock. B) Shared Lock. C) Read Lock. D) Deadlock. Show Answer Correct Answer: B) Shared Lock. 3. Which SQL keyword is used to remove a record from a table? A) SELECT. B) UPDATE. C) DELETE. D) DROP. Show Answer Correct Answer: C) DELETE. 4. Berikan contoh tag HTML untuk membuat tautan (link) ke halaman lain. A) Teks Tautan. B) Teks Tautan. C) Teks Tautan. D) Teks Tautan. Show Answer Correct Answer: A) Teks Tautan. 5. What is the main advantage of using forms in a database? A) They allow for easier data entry and viewing. B) They automatically create tables. C) They compress the database size. D) They encrypt the data. Show Answer Correct Answer: A) They allow for easier data entry and viewing. 6. What is the main advantage of using NewSQL? A) It is a type of NoSQL database. B) It does not support transactions. C) Combines reliability of SQL with speed of NoSQL. D) It is only for small datasets. Show Answer Correct Answer: C) Combines reliability of SQL with speed of NoSQL. 7. In a network model, a child can: A) Have only one parent. B) Have multiple parent records. C) Not have any parents. D) Only be linked to leaf nodes. Show Answer Correct Answer: B) Have multiple parent records. 8. A database ..... is the snapshot/state of a database at any given time. A) Instance. B) Schema. C) Metadata. D) Relation. Show Answer Correct Answer: A) Instance. 9. The "father" of MySQL is ..... A) Michael Widenius. B) Bill Joy. C) Bill Gates. D) Stephanie Wall. E) Sigmund Velin. Show Answer Correct Answer: A) Michael Widenius. 10. Which of the following is not a problem of file systems? A) Data redundancy. B) Limited data sharing. C) Complex backup. D) Easy multi-user access. Show Answer Correct Answer: D) Easy multi-user access. 11. ..... shape represents the entities in ER diagrams. A) Circle. B) Square. C) Diamond. D) Rectangle. Show Answer Correct Answer: D) Rectangle. 12. A table TEST ..... COUNT has 10 number values as 3, 32, 1, 1, null, 24, 12, null, 32, null Predict the output of the below query:SELECT COUNT(*) FROM test ..... count; A) 7. B) 6. C) 10. D) Throws exception because COUNT function doesn't work with NULL values. Show Answer Correct Answer: C) 10. 13. Why might a Composite Key be necessary in a database table? A) When the table requires faster query processing. B) When no single field contains unique values. C) When the database is normalized to the third normal form. D) When the table needs to be linked to multiple foreign keys. Show Answer Correct Answer: B) When no single field contains unique values. 14. Define the term 'tuple' in the context of a relational database. A) A tuple is a collection of tables in a database. B) A tuple is a type of database query. C) A tuple is a unique identifier for a database record. D) A tuple is a single row of data in a relational database table. Show Answer Correct Answer: D) A tuple is a single row of data in a relational database table. 15. For each attribute of a relation, there is a set of permitted values, called the ..... of that attribute. A) Relation. B) Domain. C) Set. D) Schema. Show Answer Correct Answer: B) Domain. 16. Which one of the following cannot be taken as a primary key? A) ID. B) RegistrationNo. C) DepartmentID. D) Street. Show Answer Correct Answer: D) Street. 17. What is the relationship between DOCTOR table and PATIENT table? A) 1:1. B) M:M. C) 1:M. D) M:N. Show Answer Correct Answer: C) 1:M. 18. Which of the following is an example of a physical database? A) A spreadsheet file saved on a computer. B) A collection of books in a library. C) A cloud storage service. D) A website that displays information. Show Answer Correct Answer: B) A collection of books in a library. 19. Which of these is an advantage of storing data in fields with the correct data type? A) Data looks more polished. B) The database automatically fixes spelling errors. C) Searching and sorting becomes more reliable. D) ASCII is no longer required. Show Answer Correct Answer: C) Searching and sorting becomes more reliable. 20. Which command is used to create a new table in a database? A) ADD TABLE. B) INSERT TABLE. C) MAKE TABLE. D) CREATE TABLE. Show Answer Correct Answer: D) CREATE TABLE. 21. Meera wants to store student information like name, roll number, and contact in an organized way. What should she use? A) Spreadsheet. B) Database. C) Presentation. D) Drawing tool. Show Answer Correct Answer: B) Database. 22. What does ETL stand for in data processing? A) Extract, Transform, Load. B) Extract, Transfer, Link. C) Evaluate, Test, Load. D) Evaluate, Transform, Load. Show Answer Correct Answer: A) Extract, Transform, Load. 23. The OR operator combines two relational expressions where only one must be true to provide a true result A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 24. Javell is organizing his music collection on his computer. Each song's title, artist, and album information is stored in a table. Which term refers to a single piece of data in this table? A) Field. B) Record. C) Query. D) File. Show Answer Correct Answer: A) Field. 25. Which SQL command is used to remove a table from the database? A) CLEAR table. B) DELETE table. C) DROP table. D) REMOVE table. Show Answer Correct Answer: C) DROP table. ← 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