This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 54 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 54 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Which of these is not a basic building block of a data model? A) Entity. B) Attribute. C) Table. D) Relationship. Show Answer Correct Answer: C) Table. 2. Sebuah program komputer yang disalin untuk mengelola basis data sebagai kumpulan data yang disimpan secara terstruktur dan melakukan operasi pada data atas permintaan pengguna didefinisikan sebagai ..... A) SQL. B) DB2. C) DDL. D) DBMS. E) ORACLE. Show Answer Correct Answer: D) DBMS. 3. What is an alternate key in a database? A) An alternate key is a primary key that allows duplicate values. B) An alternate key is a unique identifier for a record that is not the primary key. C) An alternate key is a foreign key that links two tables together. D) An alternate key is a temporary identifier used during data entry. Show Answer Correct Answer: B) An alternate key is a unique identifier for a record that is not the primary key. 4. How would you retrieve the total number of distinct job roles in the 'employees' table? A) SELECT DISTINCT job role FROM employees;. B) SELECT job role FROM employees WHERE DISTINCT;. C) SELECT COUNT(DISTINCT job role) FROM employees;. D) SELECT COUNT(job role) FROM employees WHERE DISTINCT;. Show Answer Correct Answer: C) SELECT COUNT(DISTINCT job role) FROM employees;. 5. Database is a collection of related data. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 6. In the context of multiple views, why do different user groups need different perspectives of the same data? A) To confuse users. B) To increase storage costs. C) Different information needs, security requirements, and simplified interaction. D) To slow down the system. Show Answer Correct Answer: C) Different information needs, security requirements, and simplified interaction. 7. A student claims productID should be stored in the Customer table instead of Subscription. What is the best response? A) It prevents duplicate customer records entirely. B) It would incorrectly tie one customer to one product. C) It allows faster joins across three tables. D) It enforces stronger primary key uniqueness. Show Answer Correct Answer: B) It would incorrectly tie one customer to one product. 8. Why is it important to define data types when creating a table? A) It is important to define data types to ensure data consistency, optimize storage, and enforce data integrity. B) Data types should be defined to improve the speed of data retrieval and display. C) Defining data types helps in creating visually appealing tables and layouts. D) It is crucial to define data types to enhance user experience and interface design. Show Answer Correct Answer: A) It is important to define data types to ensure data consistency, optimize storage, and enforce data integrity. 9. What is a Student Table in MS Access used for? A) Entering and storing student-related data. B) Creating a new software program. C) Formatting images. D) Deleting databases. Show Answer Correct Answer: A) Entering and storing student-related data. 10. What is the purpose of a database trigger? A) To automatically execute a procedure when a certain event occurs. B) To improve the speed of data retrieval. C) To increase the size of the database. D) To make the database more complex. Show Answer Correct Answer: A) To automatically execute a procedure when a certain event occurs. 11. Which of these best explains why records must be accurate in a database? A) Inaccurate records make ASCII unreadable. B) Inaccurate records make reports unreliable. C) Inaccurate records delete tables automatically. D) Inaccurate records prevent formatting into Excel. Show Answer Correct Answer: B) Inaccurate records make reports unreliable. 12. Which object is best suited to extract specific data based on criteria in MS Access? A) Table. B) Report. C) Query. D) Field. Show Answer Correct Answer: C) Query. 13. Which of the following is an advantage of using forms instead of directly entering data in a table? A) Forms can be printed. B) Forms allow for a more user-friendly data entry process. C) Forms store data more securely. D) Forms can only display one record at a time. Show Answer Correct Answer: B) Forms allow for a more user-friendly data entry process. 14. ..... is a bottom up process in EERD. It combines lower level entities into one that is a higher level. Example:Apple, Banana, Grapes when generalized can be called as "FRUITS" . A) Specialization. B) Generalization. C) Association. D) Aggregation. Show Answer Correct Answer: B) Generalization. 15. When printing forms in MS Access, what option is available? A) Print only selected records. B) Print in 3D format. C) Print to multiple printers simultaneously. D) Print with animation effects. Show Answer Correct Answer: A) Print only selected records. 16. What is a junction table used for? A) Storing unrelated data. B) Connecting two tables in a many-to-many relationship. C) Eliminating relationships between tables. D) Deleting redundant records. Show Answer Correct Answer: B) Connecting two tables in a many-to-many relationship. 17. Which component of a DBMS is responsible for managing physical storage? A) Query Processor. B) Storage Manager. C) Data Dictionary. D) Transaction Manager. Show Answer Correct Answer: B) Storage Manager. 18. .... is a way of combining two relations. A) Intersection. B) Cross product. C) Union. D) None of these. Show Answer Correct Answer: B) Cross product. 19. What are columns in a database table? A) Columns in a database table are the vertical sections that define the attributes of the data. B) Columns represent the rows in a database table. C) Columns are the unique identifiers for each record in a table. D) Columns are the horizontal sections that contain the data. Show Answer Correct Answer: A) Columns in a database table are the vertical sections that define the attributes of the data. 20. Which of the following statements is FALSE about keys in a relational database? A) Any candidate key is eligible to become a primary key. B) A primary key uniquely identifies the tuples in a relation. C) A candidate key that is not a primary key is a foreign key. D) A foreign key is an attribute whose value is derived from the primary key of another relation. Show Answer Correct Answer: C) A candidate key that is not a primary key is a foreign key. 21. What are the 2 types of tools used in Database application? A) Left-end tool and Right-end tool. B) Front-end tool and back-end tool. C) Front-end tool and Right-end tool. D) Bottom-end tool and top-end tool. Show Answer Correct Answer: B) Front-end tool and back-end tool. 22. How can you enter data into a table in Access? A) Use SQL queries to add data to the table. B) Enter data by importing from an Excel file. C) Create a new table and copy data from another database. D) Open the table in Datasheet View and enter data directly into the cells. Show Answer Correct Answer: D) Open the table in Datasheet View and enter data directly into the cells. 23. In a database table, each row stores complete information about one student. What is this row called? A) Field. B) Record. C) Column. D) Header. Show Answer Correct Answer: B) Record. 24. Berikut ini yang bukan merupakan siklus penggembangan perangkat lunak (SDLC)adalah ..... A) Perencanaan system. B) Analisis system. C) Perancangan system. D) Implementasi system. E) System Documentation. Show Answer Correct Answer: E) System Documentation. 25. Which is NOT a type of DBMS? A) Hierarchical. B) Network. C) Distributed. D) Sequential. Show Answer Correct Answer: D) Sequential. ← 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