This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 15 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 15 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Segala pengguna software aplikasi (user) adalah ..... A) Relationship. B) Use case. C) Note. D) Use case subject. E) Actor. Show Answer Correct Answer: E) Actor. 2. Querying A) Retrieving specific data from a database. B) Storing data in a database. C) Deleting data from a database. D) Modifying the structure of a database. Show Answer Correct Answer: A) Retrieving specific data from a database. 3. Which of the following is the default view when a new table is created in Access? A) Layout View. B) Datasheet View. C) Form View. D) Design View. Show Answer Correct Answer: B) Datasheet View. 4. Perintah yang digunakan untuk menampilkan tabel yang telah di buat adalah ..... A) Select nama table;. B) Show databases;. C) Show tables;. D) Show table;. E) Desc table;. Show Answer Correct Answer: C) Show tables;. 5. Malachi is designing a database for a car rental company. Why is a license plate number suitable as a primary key? A) It is always unique. B) It can be duplicated in different states. C) It is a number field. D) It is easy to remember. Show Answer Correct Answer: A) It is always unique. 6. The virtual table that its created by data from the result of an SQL 'Select' statement is called ..... A) View. B) Synonym. C) Sequence. D) Transaction. Show Answer Correct Answer: A) View. 7. Define the term 'field' in a database context. A) A field is a type of database that contains multiple tables. B) A field is a column in a database table that stores individual data attributes for records. C) A field is a graphical interface for database management. D) A field is a database command used to retrieve data. Show Answer Correct Answer: B) A field is a column in a database table that stores individual data attributes for records. 8. Which of the following is the BEST example of symbolic data? A) January. B) 24567. C) @#$ %. D) A12345. Show Answer Correct Answer: C) @#$ %. 9. The cardinality ratio of a relationship describes: A) The physical storage size of data. B) The number of attributes in a table. C) The number of instances of one entity that can or must be associated with instances of another entity. D) The speed of data retrieval. Show Answer Correct Answer: C) The number of instances of one entity that can or must be associated with instances of another entity. 10. Who is primarily responsible for producing the high-level data model that describes entities, relationships and constraints for the entire organization? A) Data entry clerk. B) Database administrator. C) Conceptual database designer. D) Physical database designer. Show Answer Correct Answer: C) Conceptual database designer. 11. Which of the following views is used to set field properties such as field size and caption? A) Report View. B) Form View. C) Datasheet View. D) Design View. Show Answer Correct Answer: D) Design View. 12. What is the role of SQL Server in database management? A) To create spreadsheets. B) To administer databases. C) To design user interfaces. D) To manage email servers. Show Answer Correct Answer: B) To administer databases. 13. In a "One to Many" relationship, which table is considered the parent? A) The table with fewer records. B) The table on the right. C) The table on the left. D) The table with more records. Show Answer Correct Answer: C) The table on the left. 14. Which of the following best describes a database system? A) A programming language for databases. B) A collection of unrelated data. C) An organization of components that manage data. D) A single table of data. Show Answer Correct Answer: C) An organization of components that manage data. 15. What does data architecture describe? A) The access methods of the data assets. B) The flow and structure of data assets. C) The network layout used to transfer data. D) None of the above. Show Answer Correct Answer: B) The flow and structure of data assets. 16. Which of the following is NOT a valid secondary key in a database? A) A customer's name. B) A product's name. C) An order's date. D) A student's last name. Show Answer Correct Answer: B) A product's name. 17. The join operation ..... A) Combines relational tables to provide the user with more information than is otherwise available. B) Identifies the table from which the columns will be selected. C) Creates a subset consisting of columns in a table. D) Organizes elements into segments. Show Answer Correct Answer: A) Combines relational tables to provide the user with more information than is otherwise available. 18. What does the self-describing nature of databases provide? A) Automatic data entry. B) User authentication. C) Complete description of database structure stored in system catalog. D) Data encryption. Show Answer Correct Answer: C) Complete description of database structure stored in system catalog. 19. Which view allows you to see the structure of a table and set field names, data types, and sizes? A) Form View. B) Datasheet View. C) Design View. D) Query View. Show Answer Correct Answer: C) Design View. 20. A relationship between two tables is established using which key? A) Primary Key. B) Candidate Key. C) Foreign Key. D) Unique Key. Show Answer Correct Answer: C) Foreign Key. 21. In a database, how is a many-to-many (N:N) relationship between two entities typically resolved? A) By creating a composite entity (junction table) with foreign keys to both entities. B) By combining the attributes of both entities into a single entity. C) By denormalizing the database structure for better performance. D) By using a one-to-many (1:N) relationship between the entities. Show Answer Correct Answer: A) By creating a composite entity (junction table) with foreign keys to both entities. 22. What is a composite key? A) A type of data. B) Multiple fields combined to identify a record. C) A method of data storage. D) A single field that identifies a record. Show Answer Correct Answer: B) Multiple fields combined to identify a record. 23. Describe the process of de-normalization. A) De-normalization is the process of introducing redundancy into a database schema to improve read performance. B) De-normalization is the process of removing redundancy from a database schema. C) De-normalization is the process of optimizing a database for write performance. D) De-normalization is used to ensure data integrity in a database. Show Answer Correct Answer: A) De-normalization is the process of introducing redundancy into a database schema to improve read performance. 24. What is a database index and why is it used? A) A database index is a data structure that improves the speed of data retrieval operations. B) A database index is a method for encrypting data. C) A database index is a type of database backup. D) A database index is used to store data permanently. Show Answer Correct Answer: A) A database index is a data structure that improves the speed of data retrieval operations. 25. In a one-to-one relationship: A) One record in table A has at most one matching record in table B. B) A record in table A can have multiple matches in table B. C) Tables do not need relationships. D) It is not commonly used in databases. Show Answer Correct Answer: A) One record in table A has at most one matching record in table B. ← 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