This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 21 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 21 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Define an attribute and provide an example. A) An example of an attribute is 'size' in a clothing item. B) An example of an attribute is 'color' in a car object. C) An example of an attribute is 'speed' in a bicycle object. D) An example of an attribute is 'brand' in a smartphone object. Show Answer Correct Answer: B) An example of an attribute is 'color' in a car object. 2. What type of software is Microsoft Access? A) Spreadsheet software. B) Database software. C) Presentation software. D) Image editing software. Show Answer Correct Answer: B) Database software. 3. What is the smallest piece of information for an entity in a database? A) Record. B) Field. C) Query. D) Form. Show Answer Correct Answer: B) Field. 4. Which normal form removes duplicate groups of data? A) First Normal Form (1NF). B) Second Normal Form (2NF). C) Third Normal Form (3NF). D) Fourth Normal Form (4NF). Show Answer Correct Answer: A) First Normal Form (1NF). 5. Which of the following describes a composite key? A) A single attribute that uniquely identifies a record. B) A combination of two or more attributes that uniquely identifies a record. C) A key used to establish a relationship between two tables. D) A key that cannot be null. Show Answer Correct Answer: B) A combination of two or more attributes that uniquely identifies a record. 6. What is an Entity-Relationship Diagram (ERD) used for? A) To visualize the relationships between tables in a database. B) To encrypt sensitive information in a database. C) To perform complex calculations. D) To define data types for fields in a database. Show Answer Correct Answer: A) To visualize the relationships between tables in a database. 7. In an UPDATE statement, which clause is used to specify the records that should be modified? A) SET. B) WHERE. C) ORDER BY. D) GROUP BY. Show Answer Correct Answer: B) WHERE. 8. What language is primarily used for interacting with databases? A) Java. B) SQL. C) Python. D) HTML. Show Answer Correct Answer: B) SQL. 9. Setiap perintah SQL dalam video diakhiri dengan karakter apa? A) . (titik). B) , (koma). C) ; (titik koma). D) :(titik dua). Show Answer Correct Answer: C) ; (titik koma). 10. An attribute is represented by what in a database? A) Table. B) Row. C) Column. D) Cell. Show Answer Correct Answer: C) Column. 11. To create a relationship between two tables, what database element is placed in the child table referencing the parent's key? A) A foreign key column. B) A stored procedure. C) A calculated field. D) A unique index. Show Answer Correct Answer: A) A foreign key column. 12. In a library database, what would a single book most likely represent? A) A table. B) A field. C) A record. D) A database. Show Answer Correct Answer: C) A record. 13. Data independence refers to: A) The ability to run queries without a database. B) The ability to change the database schema without affecting the application. C) The ability to use multiple database types. D) The independence of data from the user interface. Show Answer Correct Answer: B) The ability to change the database schema without affecting the application. 14. What is a trigger in a database? A) A type of database. B) A rule activated by updates. C) A way to delete data. D) A method to store data. Show Answer Correct Answer: B) A rule activated by updates. 15. Purpose of a foreign key A) To create a link between two tables. B) To store data in a single table. C) To delete records from a database. D) To increase the speed of data retrieval. Show Answer Correct Answer: A) To create a link between two tables. 16. In a database, what is a unique identifier for each record in a table called? A) Primary key. B) Secondary key. C) Foreign key. D) Index key. Show Answer Correct Answer: A) Primary key. 17. Why might Excel NOT be the best choice for managing a school library system compared to a database? A) Excel cannot format tables. B) Excel cannot store numerical data. C) Excel is less efficient for large amounts of related records. D) Excel does not support ASCII. Show Answer Correct Answer: C) Excel is less efficient for large amounts of related records. 18. Dalam basis data relasional, sebuah kueri digunakan untuk: A) Menghapus tabel. B) Menghubungkan dua basis data. C) Memindahkan data dari satu server ke server lain. D) Mengambil, memodifikasi, atau menambahkan data. E) Membuat cadangan data. Show Answer Correct Answer: D) Mengambil, memodifikasi, atau menambahkan data. 19. In which of the following can many entity instances of one type be related to many entity instances of another type? A) One-to-One Relationship. B) One-to-Many Relationship. C) Many-to-Many Relationship. D) Composite Relationship. Show Answer Correct Answer: C) Many-to-Many Relationship. 20. What is the benefit of using forms for less-experienced users? A) Prevents changing vital table settings. B) Increases internet speed. C) Enhances video quality. D) Improves sound clarity. Show Answer Correct Answer: A) Prevents changing vital table settings. 21. Which of the following best describes a database? A) It is an electronic filing cabinet. B) It is a tool used for creating spreadsheets. C) It is used only for storing pictures. D) It is a program for designing websites. Show Answer Correct Answer: A) It is an electronic filing cabinet. 22. How can you define relationships between entities? A) By analyzing the color of the entities. B) Through random selection of entities. C) By measuring the size of the entities. D) Relationships between entities can be defined by identifying the entities, their interactions, and categorizing the types of relationships. Show Answer Correct Answer: D) Relationships between entities can be defined by identifying the entities, their interactions, and categorizing the types of relationships. 23. Object-Oriented Structure A) A database structure that stores data as objects. B) A method for organizing data in a linear format. C) A technique for encrypting data in databases. D) A way to visualize data relationships in spreadsheets. Show Answer Correct Answer: A) A database structure that stores data as objects. 24. The RDBMS terminology for a row is A) Tuple. B) Relation. C) Attribute. D) Degree. Show Answer Correct Answer: A) Tuple. 25. What does the UPDATE command do in a database? A) Inserts new rows into a table. B) Retrieves data from the table. C) Modifies existing records in a table. D) Removes rows from a table. Show Answer Correct Answer: C) Modifies existing records in a 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