This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 12 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 12 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What is the primary purpose of a database? A) To create beautiful presentations. B) To organize and manage large amounts of information. C) To play video games. D) To send emails. Show Answer Correct Answer: B) To organize and manage large amounts of information. 2. Perintah SQL yang digunakan untuk menghapus tabel bernama 'nama ..... siswa' adalah ..... A) REMOVE TABLE nama siswa;. B) ERASE TABLE nama siswa;. C) DELETE TABLE nama siswa;. D) DROP TABLE nama siswa;. Show Answer Correct Answer: D) DROP TABLE nama siswa;. 3. What is Data Definition Language (DDL)? A) Data Definition Language (DDL) is a language used to define and manage database structures. B) Data Definition Language (DDL) is a protocol for securing data access. C) Data Definition Language (DDL) is a tool for visualizing database queries. D) Data Definition Language (DDL) is a method for analyzing data trends. Show Answer Correct Answer: A) Data Definition Language (DDL) is a language used to define and manage database structures. 4. Which of the following is an example of a DBMS A) SQL. B) Microsoft Office. C) PHP. D) Oracle. Show Answer Correct Answer: D) Oracle. 5. Which of the following is NOT a type of database? A) NoSQL Database. B) Static Database. C) Object-Oriented Database. D) Relational Database. Show Answer Correct Answer: B) Static Database. 6. Which of the following is a characteristic of metadata? A) It is raw data. B) It describes data characteristics. C) It is only used for storage. D) It is not related to end user data. Show Answer Correct Answer: B) It describes data characteristics. 7. What is data about data called? A) Data Description. B) Metadata. C) Data redundancy. D) Data inconsistency. Show Answer Correct Answer: B) Metadata. 8. Which of the following is a benefit of using indexes in a database? A) They prevent data duplication. B) They slow down data retrieval. C) They increase storage requirements. D) They speed up data retrieval. Show Answer Correct Answer: D) They speed up data retrieval. 9. Which of the following is a Data Definition Language (DDL) command? A) Delete. B) Insert. C) Drop. D) Merge. Show Answer Correct Answer: C) Drop. 10. What is the first step in creating a database file in MS Access? A) Click "Create". B) Open the software. C) Change the file name. D) Enter data. Show Answer Correct Answer: B) Open the software. 11. True or False:When multiple people want to access "the data" at the same time, does this pose a challenge for databases? A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 12. Define a view in SQL and its purpose. A) A view in SQL is a command used to delete records from a table. B) A view in SQL is a physical table that stores data permanently. C) A view in SQL is a type of index that speeds up queries. D) A view in SQL is a virtual table that represents the result of a stored query. Show Answer Correct Answer: D) A view in SQL is a virtual table that represents the result of a stored query. 13. What does DML stand for and what does it include? A) Data Manipulation Language; it includes SELECT, INSERT, UPDATE, DELETE. B) Data Management Language; it includes CREATE, ALTER, DROP. C) Data Modeling Language; it includes SELECT, INSERT, UPDATE, DELETE. D) Data Mining Language; it includes SELECT, INSERT, UPDATE, DELETE. Show Answer Correct Answer: A) Data Manipulation Language; it includes SELECT, INSERT, UPDATE, DELETE. 14. Indicate whether the statement is true or false:An unnormalized relation contains repeating groups. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 15. Sebuah kumpulan data yang saling terkait yang disimpan dalam perangkat keras komputer dan digunakan oleh perangkat lunak untuk memanipulasinya adalah definisi dari ..... A) Databes. B) Basis Data. C) Database. D) Databese. E) Databeses. Show Answer Correct Answer: C) Database. 16. An ER diagram shows relationships between: A) Tables in a relational database. B) Rows in a relational database. C) Records with foreign keys. D) Two items about which there is data kept. Show Answer Correct Answer: A) Tables in a relational database. 17. Which property is important in order to reduce and improve data integrity? A) Data storage. B) Data access. C) Database distribution. D) Database normalization. Show Answer Correct Answer: B) Data access. 18. What is the purpose of data integrity? A) To ensure data is always deleted. B) To maintain the accuracy and consistency of data. C) To create new data entries. D) To ignore outdated data. Show Answer Correct Answer: B) To maintain the accuracy and consistency of data. 19. To be in 2NF: A) Each non-key field relates to the primary key. B) There are multiple entries in the same field. C) There are no foreign keys. D) All numbers are in decimal form. Show Answer Correct Answer: A) Each non-key field relates to the primary key. 20. Which of the following is one of the basic types of joins in DB? A) Outer join. B) Self-join. C) Equi-join. D) All of the above. Show Answer Correct Answer: D) All of the above. 21. Which level of data abstraction describes what data is stored and the relationships among data? A) External level. B) Conceptual level. C) Internal level. D) Physical level. Show Answer Correct Answer: B) Conceptual level. 22. An entity that is related with it is known as ..... A) Binary relationship. B) Recursive relationship. C) Ternary relationship. D) None of the above. Show Answer Correct Answer: A) Binary relationship. 23. What is a stored procedure? A) A stored procedure is a temporary table used for data storage. B) A stored procedure is a precompiled collection of SQL statements stored in a database. C) A stored procedure is a single SQL statement executed on demand. D) A stored procedure is a type of database index. Show Answer Correct Answer: B) A stored procedure is a precompiled collection of SQL statements stored in a database. 24. Which function returns the minimum value in a column? A) COUNT(). B) MIN(). C) SUM(). D) AVG(). Show Answer Correct Answer: B) MIN(). 25. In what scenario would sorting data in ascending order be particularly useful? A) When you need to find the most recent entry quickly. B) When you want to display records from oldest to newest. C) When the data does not have a natural ordering. D) When you are looking for the highest value onlyTagsDOK Level 3:Strategic Thinking. Show Answer Correct Answer: B) When you want to display records from oldest to newest. ← 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