This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 85 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 85 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What is the repetition of data indicative of? A) Dependance. B) Redundancy. C) Inconsistency. D) Isolation. Show Answer Correct Answer: B) Redundancy. 2. A data lake is composed of ..... A) Historical data from legacy systems. B) Raw unstructured and structured data that has not been analyzed. C) Internal and external data sources. D) Historic and current internal data. Show Answer Correct Answer: B) Raw unstructured and structured data that has not been analyzed. 3. What is a view in a database? A) A type of database. B) A subset of the database. C) A way to delete data. D) A method to store data. Show Answer Correct Answer: B) A subset of the database. 4. To be in 3NF: A) Records do not depend on anything other than the table's PK. B) The PK is not added. C) The FKs are limited to one only. D) The tables all relate to one another. Show Answer Correct Answer: A) Records do not depend on anything other than the table's PK. 5. Data models are used to ..... A) Write programs. B) Design databases. C) Store hardware details. D) Control networks. Show Answer Correct Answer: B) Design databases. 6. Which condition is necessary for a distributed database? A) It must be connected to the internet. B) It must be located in one city. C) It must be stored on a single server. D) It must be managed by one person. Show Answer Correct Answer: A) It must be connected to the internet. 7. Which diagram is used to visually represent database relationships? A) Entity-Relationship (E-R) Diagram. B) Gantt Chart. C) Flowchart. D) Bar Graph. Show Answer Correct Answer: A) Entity-Relationship (E-R) Diagram. 8. A foreign key in a database is used to: A) Increase data storage capacity. B) Enforce referential integrity between two tables. C) Serve as a primary key in the same table. D) Improve data retrieval speed. Show Answer Correct Answer: B) Enforce referential integrity between two tables. 9. What is the difference between TRUNCATE and DELETE in SQL? A) TRUNCATE removes rows one by one and logs each removal, while DELETE removes all rows at once without logging. B) DELETE can remove specific rows based on a condition, while TRUNCATE removes all rows without conditions and is faster. C) TRUNCATE can remove rows based on conditions, but DELETE cannot. D) TRUNCATE cannot be rolled back, but DELETE can. Show Answer Correct Answer: B) DELETE can remove specific rows based on a condition, while TRUNCATE removes all rows without conditions and is faster. 10. Which transaction command to undo changes? A) ROLLBACK. B) COMMIT. C) SAVEPOINT. D) DELETE. Show Answer Correct Answer: A) ROLLBACK. 11. What are some popular big data technologies? A) Microsoft Excel, Google Sheets, Tableau. B) Apache Hadoop, Apache Spark, Apache Kafka, NoSQL databases (e.g., MongoDB, Cassandra), Apache Flink, and Apache Storm. C) Apache Tomcat, Apache Ant, Apache Maven. D) MySQL databases (e.g., PostgreSQL, SQLite). Show Answer Correct Answer: B) Apache Hadoop, Apache Spark, Apache Kafka, NoSQL databases (e.g., MongoDB, Cassandra), Apache Flink, and Apache Storm. 12. A set of one (1) or more computer programs that serves as an intermediary between the user and the DBMS. A) Database Application. B) Database Software. C) Database Integration. D) Database System. Show Answer Correct Answer: A) Database Application. 13. Dalam struktur database 'Kasir' yang ditunjukkan, tabel 'nota ..... penjualan' memiliki kolom 'id ..... pelanggan'. Kolom ini kemungkinan besar berfungsi sebagai apa? A) Primary Key. B) Foreign Key. C) Unique Key. D) Index. Show Answer Correct Answer: B) Foreign Key. 14. A key that consists of more than one attribute (e.g. (studentId, courseCode)) is called a: A) Candidate key. B) Composite key. C) Superkey. D) Secondary key. Show Answer Correct Answer: B) Composite key. 15. Which is NOT a problem of file systems? A) Data redundancy. B) Data inconsistency. C) Data sharing. D) Poor security. Show Answer Correct Answer: C) Data sharing. 16. Which of the following is an example of information? A) 45, 60, 75. B) Numbers only. C) Average = 60, Result = Pass. D) Raw data. Show Answer Correct Answer: C) Average = 60, Result = Pass. 17. Explain the concept of 'JOIN' in SQL and provide an example. A) The 'JOIN' clause in SQL is used to combine rows from two or more tables based on a related column between them. B) The 'JOIN' clause in SQL is used to delete rows from a table based on a condition. C) The 'JOIN' clause in SQL is used to update rows in a table based on a condition. D) The 'JOIN' clause in SQL is used to sort the data in descending order. Show Answer Correct Answer: A) The 'JOIN' clause in SQL is used to combine rows from two or more tables based on a related column between them. 18. Why are databases at risk in networked environments? A) Vulnerable components in the system may be exploited for attacks. B) They lack online indexing capabilities. C) They are isolated from monitoring tools in a networked environment. D) None of the above. Show Answer Correct Answer: A) Vulnerable components in the system may be exploited for attacks. 19. Field A) Categories for the details describing each record. B) A type of database management system. C) A method for sorting data records. D) A programming language used for data analysis. Show Answer Correct Answer: A) Categories for the details describing each record. 20. What do you mean by one to many relationships? A) One class may have many teaches. B) One teacher can have many classes. C) Many classes may have many teachers. D) Many teachers may have many classes. Show Answer Correct Answer: B) One teacher can have many classes. 21. Which of the following is a benefit of the three-level database architecture? A) Improved transaction speed. B) Data independence. C) Simplified data entry. D) Automated indexing. Show Answer Correct Answer: B) Data independence. 22. What is the advantage of using a DBMS? A) Data sharing. B) Data security. C) Data complexity. D) Data performance. Show Answer Correct Answer: A) Data sharing. 23. What is the purpose of database management? A) To create new data. B) To organize and store information efficiently. C) To delete old records. D) To print documents. Show Answer Correct Answer: B) To organize and store information efficiently. 24. Information is processed data, it has meaning or context. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 25. What is the relationship between fields and records? A) Fields are created from records. B) Fields are the rows of a record. C) Records are made up of multiple fields. D) Records are stored inside fields. Show Answer Correct Answer: C) Records are made up of multiple fields. ← 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