This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 58 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 58 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Notasi usecase dilambangkan dengan symbol ..... A) Triangle. B) Oval. C) Parallelogram. D) Square. E) Circle. Show Answer Correct Answer: B) Oval. 2. The properties of entities that are used to differentiate one entity from the other entity is called: A) Attributes. B) Database. C) Relationship. D) Entity. Show Answer Correct Answer: A) Attributes. 3. Describe the importance of data governance in databases. A) Data governance is irrelevant to data analysis and reporting. B) Data governance is crucial for maintaining data quality, security, compliance, and effective decision-making in databases. C) Data governance is only necessary for large organizations. D) Data governance focuses solely on data storage efficiency. Show Answer Correct Answer: B) Data governance is crucial for maintaining data quality, security, compliance, and effective decision-making in databases. 4. Section A:True or False (5 marks)-Write True or False beside each statement. One advantage of a database is that it reduces data duplication. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 5. Which of the following is an example of information derived from data? A) A list of student names. B) The total number of students in a class. C) The raw scores of a test. D) A report showing average test scores per subject. Show Answer Correct Answer: D) A report showing average test scores per subject. 6. What is the purpose of a data dictionary? A) To store large amounts of data. B) To decide what data is going to be stored in each table of a database. C) To delete unnecessary data. D) To encrypt data. Show Answer Correct Answer: B) To decide what data is going to be stored in each table of a database. 7. ..... is a way to display only the data that meets certain criteria, like students over a certain grade. A) Filtering. B) Sorting. C) Grouping. D) Highlighting. Show Answer Correct Answer: A) Filtering. 8. Apa peran utama dari DBMS (Database Management System) A) Akses informasi internet. B) Membuat aplikasi multimedia. C) Mengelola dokumen tertulis. D) Mengelola akses pengguna dan menjaga integritas data. Show Answer Correct Answer: D) Mengelola akses pengguna dan menjaga integritas data. 9. What is the definition of a data type in database design? A) A type of report format. B) A category that defines what kind of data a field can store. C) A code for accessing tables. D) A printing template. Show Answer Correct Answer: B) A category that defines what kind of data a field can store. 10. The importance of data models lies in ..... A) Hardware configuration. B) Data representation and relationships. C) Program execution. D) File storage. Show Answer Correct Answer: B) Data representation and relationships. 11. Which of the following best describes a one-to-one relationship between two tables? A) Each record in one table can be related to multiple records in the other table. B) Each record in one table is related to exactly one record in the other table. C) Each record in one table can be related to multiple records in multiple tables. D) None of the above. Show Answer Correct Answer: B) Each record in one table is related to exactly one record in the other table. 12. A student wants to store multiple values of the same data type in each row using a lookup field in MS Access. Which feature should they use? A) Complex lookup field via Lookup Wizard. B) Attachment data type. C) Hyperlink data type. D) Calculated data type. Show Answer Correct Answer: A) Complex lookup field via Lookup Wizard. 13. Schemas define the ..... of a database. A) Structure. B) Transactions. C) Queries. D) Reports. Show Answer Correct Answer: A) Structure. 14. How does data replication work in distributed systems? A) Data replication requires a central server to manage all data transactions. B) Data replication involves compressing data to save space on a single node. C) Data replication is the process of deleting old data to improve performance. D) Data replication works by copying data across multiple nodes to ensure consistency and availability in distributed systems. Show Answer Correct Answer: D) Data replication works by copying data across multiple nodes to ensure consistency and availability in distributed systems. 15. Can you use ORDER BY with more than one column? A) Yes, you can use ORDER BY with more than one column. B) No, you cannot use ORDER BY with more than one column. C) All the above. D) None of the above. Show Answer Correct Answer: A) Yes, you can use ORDER BY with more than one column. 16. SELECT A) An SQL command used to retrieve data. B) An SQL command used to insert data. C) An SQL command used to update data. D) An SQL command used to delete data. Show Answer Correct Answer: A) An SQL command used to retrieve data. 17. What type of key should 'StudentID' be in the Students table? A) Foreign Key. B) Secondary Key. C) Primary Key. D) Composite Key. Show Answer Correct Answer: C) Primary Key. 18. What type of data is numerical in nature? A) Descriptive data. B) Qualitative data. C) Statistical data. D) Quantitative data. Show Answer Correct Answer: D) Quantitative data. 19. The conceptual level describes: A) Physical file structure. B) Hardware configurations. C) Entire database logically. D) User-specific view. Show Answer Correct Answer: C) Entire database logically. 20. When must a developer use the ROLLBACK TRANSACTION command? A) At the beginning of every stored procedure to clear old data. B) After a COMMIT to save a backup copy of the changes. C) After a BEGIN TRANSACTION when a business rule is violated or an error occurs. D) Instead of a BEGIN CATCH block for faster error handling. Show Answer Correct Answer: C) After a BEGIN TRANSACTION when a business rule is violated or an error occurs. 21. Which of the following queries correctly uses a subquery to return all employees earning more than the average salary? A) SELECT * FROM employees WHERE salary > (SELECT salary FROM employees);. B) SELECT * FROM employees WHERE salary > (SELECT AVG(salary) FROM employees);. C) SELECT * FROM employees WHERE salary = (SELECT MAX(salary) FROM employees);. D) SELECT * FROM employees WHERE salary > (SELECT MIN(salary) FROM employees);. Show Answer Correct Answer: B) SELECT * FROM employees WHERE salary > (SELECT AVG(salary) FROM employees);. 22. What does an entity relationship diagram (ERD) illustrate? A) The structure of a database table. B) The relationships between two entities in a relational database. C) The primary and foreign keys in a table. D) The format control for data entry. Show Answer Correct Answer: B) The relationships between two entities in a relational database. 23. Which type of entity is related to two or more associated entities that each contain specialized attributes that apply to some but not all of the instances of the entity? A) Supertype entity. B) Subtype entity. C) Archetype entity. D) Instance entity. Show Answer Correct Answer: B) Subtype entity. 24. What does the DISTINCT keyword do? A) Sorts the data. B) Removes duplicate rows. C) Counts rows. D) Filters null values. Show Answer Correct Answer: B) Removes duplicate rows. 25. What is the primary function of a database management system? A) To create and manage spreadsheets. B) To create, organize, and maintain databases. C) To design websites. D) To manage email communications. Show Answer Correct Answer: B) To create, organize, and maintain databases. ← 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