This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 78 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 78 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. ..... is the process of ensuring that a program operates on clean, correct and useful data. A) Data consistency. B) Data concurrency. C) Data validation. D) Data verification. Show Answer Correct Answer: C) Data validation. 2. In a table of library books, each row represents a: A) Attribute. B) Tuple/Record. C) Schema. D) Domain. Show Answer Correct Answer: B) Tuple/Record. 3. Which of the following is NOT an advantage of using a database system? A) Increased data inconsistency. B) Secured data. C) Controlled data inconsistency. D) Reduced data redundancy. Show Answer Correct Answer: A) Increased data inconsistency. 4. What is a query in the context of a database? A) A query is a request for data or information from a database. B) A query is a graphical representation of database structure. C) A query is a method for deleting data from a database. D) A query is a type of database software. Show Answer Correct Answer: A) A query is a request for data or information from a database. 5. What is the Ribbon in MS Access? A) A type of field. B) A part of the database file. C) A menu that allows navigation. D) A tool used for printing. Show Answer Correct Answer: C) A menu that allows navigation. 6. Which of the following statements best defines the word 'database'? A) A database is a collection of data or information which is stored in a logical and structured way. B) A database is a collection of statistics stored only for computers. C) A database does not collect data or information. D) None of the above. Show Answer Correct Answer: A) A database is a collection of data or information which is stored in a logical and structured way. 7. Which SQL structure correctly deletes a record? A) DELETE FROM WHERE ;. B) REMOVE IF ;. C) DELETE RECORD = ;. D) CLEAR FROM WHEN ;. Show Answer Correct Answer: A) DELETE FROM WHERE ;. 8. Apa fungsi utama dari 'PRIMARY KEY' pada sebuah tabel database? A) Mengizinkan nilai duplikat dalam kolom. B) Memastikan setiap baris memiliki nilai unik untuk kolom tersebut. C) Mengatur urutan data dalam tabel. D) Menghubungkan dua tabel yang berbeda. Show Answer Correct Answer: B) Memastikan setiap baris memiliki nilai unik untuk kolom tersebut. 9. Suggest Suitable Basic Data Types:Which data type is suitable for storing names, addresses, or product descriptions in a database? A) Integer. B) Text/alphanumeric. C) Boolean. D) RealTagsLO2. Show Answer Correct Answer: B) Text/alphanumeric. 10. A field which has a unique value for each record of a table is called: A) Foreign key. B) Attribute. C) Data type. D) Primary key. Show Answer Correct Answer: D) Primary key. 11. Which of the following is a common database management system? A) MySQL. B) MongoDB. C) SQLite. D) PostgreSQL. Show Answer Correct Answer: A) MySQL. 12. A table in a database consists of: A) Images and text. B) Columns and rows. C) Only numbers. D) Only text. Show Answer Correct Answer: B) Columns and rows. 13. Dalam cardinality, apa itu relasi many to many A) Sebuah entitas dalam satu set hanya terkait dengan satu entitas di set lain. B) Sebuah entitas dapat terkait dengan banyak entitas di set lain, dan sebaliknya. C) Hanya hubungan satu arah yang diizinkan. D) Entitas dari tabel yang berbeda tidak dapat terkait. Show Answer Correct Answer: B) Sebuah entitas dapat terkait dengan banyak entitas di set lain, dan sebaliknya. 14. This is the language used to communicate with DBMS. A) Structured Query Language. B) Standard Query Language. C) Super Query Language. D) None of these. Show Answer Correct Answer: A) Structured Query Language. 15. A query retrieves specific data based on criteria from one or more tables. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 16. What is metadata in the context of databases? A) Data about users. B) Data about applications. C) Data about hardware. D) Data about data-describes structure, constraints, and properties. Show Answer Correct Answer: D) Data about data-describes structure, constraints, and properties. 17. Data about data is ..... A) Data Description. B) Metadata. C) Data redundancy. D) Data inconsistency. Show Answer Correct Answer: B) Metadata. 18. .... is the example for the DBMS . A) FoxPro. B) Excel. C) Java. D) Python. Show Answer Correct Answer: A) FoxPro. 19. What is the purpose of a foreign key? A) To create a relationship between two tables. B) To uniquely identify records in a table. C) To store secondary attributes. D) To sort data in ascending order. Show Answer Correct Answer: A) To create a relationship between two tables. 20. Why do relational databases improve data integrity? A) They allow inconsistent data to be stored. B) They duplicate fields across tables. C) They update related data automatically through relationships. D) They require more storage space. Show Answer Correct Answer: C) They update related data automatically through relationships. 21. Which of the following is a key characteristic of a database? A) Redundancy. B) Self-describing nature. C) Static content. D) Lack of data relationships. Show Answer Correct Answer: B) Self-describing nature. 22. A record is a group of related: A) Fields. B) Bytes. C) Tables. D) Attributes. Show Answer Correct Answer: A) Fields. 23. In file-based systems, data is: A) Managed by DBMS. B) Integrated and centralized. C) Independent of applications. D) Stored in separate files per application. Show Answer Correct Answer: D) Stored in separate files per application. 24. Which keyword is used to delete all rows from a table but keep its structure? A) DELETE. B) TRUNCATE. C) DROP. D) REMOVE. Show Answer Correct Answer: B) TRUNCATE. 25. What is the purpose of an entity in a database? A) To organize data in the database. B) To represent a real-world object or concept in the database. C) To store data in the database. D) To perform calculations in the database. Show Answer Correct Answer: B) To represent a real-world object or concept in the database. ← 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