This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 18 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 18 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Which command is used to query the table in a database? A) CHANGE. B) SELECT. C) MODIFY. D) UPDATE. Show Answer Correct Answer: B) SELECT. 2. What does the GROUP BY clause do in a query? A) Groups records with similar values together. B) Deletes duplicate records. C) Formats query results. D) Creates new tables. Show Answer Correct Answer: A) Groups records with similar values together. 3. Bahasa pemodelan berbasis berupa grafis/gambar (Notasi grafis) yang sering digunakan dalam sistem disebut ..... A) Unified Modeling League. B) Unit Modeling Language. C) Unified Modeling Language. D) United Modeling Language. E) Unit Model Lang. Show Answer Correct Answer: C) Unified Modeling Language. 4. Which tab on the Ribbon should be used to create a new table? A) File. B) Insert. C) Create. D) View. Show Answer Correct Answer: C) Create. 5. Which of these is NOT a type of database interface? A) Graphical user interface. B) Query language interface. C) Speech-based interface. D) File system interface. Show Answer Correct Answer: D) File system interface. 6. Untuk mengaktifkan database, dapat menggunakan perintah ..... A) START. B) SHOW. C) DESC. D) ACTIVE. E) USE. Show Answer Correct Answer: E) USE. 7. Which of the following is a conceptual model of a database? A) Hierarchical Model. B) Entity-Relationship (ER) Model. C) Relational Model. D) Physical Storage Model. Show Answer Correct Answer: B) Entity-Relationship (ER) Model. 8. Apa tujuan utama dari database? A) Menyimpan data tanpa hubungan. B) Mengelola dokumen. C) Mengorganisir dan mengelola data terkait secara efektif. D) Mempercepat akses internet. Show Answer Correct Answer: C) Mengorganisir dan mengelola data terkait secara efektif. 9. Apa yang dimaksud dengan redundansi dalam basis data? A) Menggunakan data yang sama untuk tujuan yang berbeda. B) Menyimpan data secara berulang dalam basis data. C) Menyimpan data hanya sekali tanpa duplikat. D) Menggabungkan beberapa basis data menjadi satu sistem. Show Answer Correct Answer: B) Menyimpan data secara berulang dalam basis data. 10. What is a field in a database table that is used to establish a link between two tables? A) Primary Key. B) Index. C) Unique Key. D) Foreign Key. Show Answer Correct Answer: D) Foreign Key. 11. What are integrity rules in a database? A) Integrity rules are methods for data encryption. B) Integrity rules are guidelines for database design. C) Integrity rules are only applicable to user permissions. D) Integrity rules in a database are constraints that maintain data accuracy and consistency. Show Answer Correct Answer: D) Integrity rules in a database are constraints that maintain data accuracy and consistency. 12. How can you retrieve specific data from a database using a query? A) Using the SELECT statement with appropriate conditions in SQL. B) Using the DELETE statement with appropriate conditions in SQL. C) Using the UPDATE statement with appropriate conditions in SQL. D) Using the INSERT statement with appropriate conditions in SQL. Show Answer Correct Answer: A) Using the SELECT statement with appropriate conditions in SQL. 13. What is data independence in database systems? A) The ability to easily change the structure of the database without affecting the application. B) The ability to store data separately from metadata. C) The ability to manage data without a DBMS. D) The ability to recover data in case of failure. Show Answer Correct Answer: A) The ability to easily change the structure of the database without affecting the application. 14. Explain the role of ACID properties in ensuring data integrity in database transactions. A) ACID properties have no impact on data integrity in database transactions. B) ACID properties ensure data consistency, isolation, durability, and atomicity in database transactions, thereby maintaining data integrity. C) ACID properties only focus on data redundancy in database transactions. D) ACID properties are not relevant in database transactions. Show Answer Correct Answer: B) ACID properties ensure data consistency, isolation, durability, and atomicity in database transactions, thereby maintaining data integrity. 15. In a database, data is stored in A) Queries. B) Forms. C) Reports. D) Tables. Show Answer Correct Answer: D) Tables. 16. Which of the following is a benefit of using a relational database? A) Increased data redundancy. B) Easier data retrieval and management. C) More complex data structures. D) Limited data integrity. Show Answer Correct Answer: B) Easier data retrieval and management. 17. In a school database, why are 'Forename' and 'Surname' typically unsuitable to serve as primary keys? A) They are alphanumeric, and primary keys must always be numeric. B) They take up too much internal memory compared to IDs. C) Multiple people can have the same name, which violates the requirement for unique data. D) Access only allows IDs like 'Teacher ID' to be used as keys. Show Answer Correct Answer: C) Multiple people can have the same name, which violates the requirement for unique data. 18. Which of the following is an example of a candidate key in a database? A) A customer's name. B) A student's last name. C) A product's name. D) An order's date. Show Answer Correct Answer: B) A student's last name. 19. Explain the concept of a join in SQL. A) A join in SQL combines rows from two or more tables based on a related column. B) A join in SQL is a method to sort data within a single table. C) A join in SQL is used to create new tables from existing ones. D) A join in SQL deletes rows from one table based on another. Show Answer Correct Answer: A) A join in SQL combines rows from two or more tables based on a related column. 20. PostgreSQL is an example of: A) NoSQL database. B) Relational database. C) Graph database. D) Document database. Show Answer Correct Answer: B) Relational database. 21. In a database system, what is a "file" ? A) A collection of related records. B) A single record in a table. C) A data type. D) A software program used for database management. Show Answer Correct Answer: A) A collection of related records. 22. What is an advantage of placing computations in SQL views? A) To save users from having to write an expression. B) To ensure that the results are consistent. C) To accomplish both of the above. D) None of the above is correct-computations cannot be placed in a view. Show Answer Correct Answer: C) To accomplish both of the above. 23. UML A) A visual language used to design and represent database systems. B) A programming language for web development. C) A markup language for creating web pages. D) A database management system. Show Answer Correct Answer: A) A visual language used to design and represent database systems. 24. Which of the following commands will delete the table from MYSQL database? A) DELETE TABLE. B) DROP TABLE. C) REMOVE TABLE. D) ALTER TABLE. Show Answer Correct Answer: B) DROP TABLE. 25. When all non-key attributes are fully functionally dependent on the primary key, a table is in A) First Normal Form (1NF). B) Second Normal Form (2NF). C) Third Normal Form (3NF). D) None of these. Show Answer Correct Answer: B) Second Normal Form (2NF). ← 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