This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 38 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 38 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What is ETL in the context of data warehousing? A) ETL refers to a programming language for data analysis. B) ETL is a process in data warehousing that involves Extracting data from sources, Transforming it into a usable format, and Loading it into a data warehouse. C) ETL is a method for archiving data in cloud storage. D) ETL is a framework for real-time data streaming. Show Answer Correct Answer: B) ETL is a process in data warehousing that involves Extracting data from sources, Transforming it into a usable format, and Loading it into a data warehouse. 2. What is the purpose of a Database Management System (DBMS) in relation to a file-based approach? A) To improve data security. B) To create data dependencies. C) To decrease data inconsistency. D) To increase data redundancy. Show Answer Correct Answer: C) To decrease data inconsistency. 3. What type of database follows a table-based structure? A) NoSQL. B) Document-based. C) Relational. D) Key-value. Show Answer Correct Answer: C) Relational. 4. How do you create a database using MySQL? A) CREATE DATABASE database name;. B) SELECT DATABASE database name;. C) ALTER DATABASE database name;. D) DROP DATABASE database name;. Show Answer Correct Answer: A) CREATE DATABASE database name;. 5. Which one of th following is a type of Data Manipulation command? A) Create. B) Alter. C) Delete. D) All of the above. Show Answer Correct Answer: C) Delete. 6. Which of the following is NOT a type of database security measure? A) Access control. B) Encryption. C) Data mining. D) Backup and recovery. Show Answer Correct Answer: C) Data mining. 7. What is the primary purpose of database systems? A) To provide a platform for social networking. B) To create complex algorithms for data analysis. C) To store, manage, and retrieve data efficiently. D) To ensure data is visually appealing and colorful. Show Answer Correct Answer: C) To store, manage, and retrieve data efficiently. 8. Perintah SQL yang digunakan untuk menampilkan daftar semua database yang ada adalah ..... A) SHOW TABLES;. B) LIST DATABASES;. C) SHOW DATABASE;. D) SHOW DATABASES;. Show Answer Correct Answer: D) SHOW DATABASES;. 9. Which of the following is an example of a field in a database table? A) A single row in a table. B) A single column in a table. C) A collection of records. D) The relationship between two tables. Show Answer Correct Answer: B) A single column in a table. 10. Manakah dari berikut ini yang BUKAN contoh dari relasi one to many A) Departemen yang diisi oleh berbagai karyawan. B) Negara dan kota. C) Dosen yang mengajar beberapa mata pelajaran. D) Hubungan suami dan istri. Show Answer Correct Answer: D) Hubungan suami dan istri. 11. Which level in the ANSI-SPARC architecture represents user views? A) External. B) Conceptual. C) Internal. D) Logical. Show Answer Correct Answer: A) External. 12. When values in one or more attributes are used as foreign keys, they must exist in another set of one or more attributes in another table, we have created a: A) Transitive dependency. B) Insert anomaly. C) Referential integrity constraint. D) Normalization form. Show Answer Correct Answer: C) Referential integrity constraint. 13. How can you ensure data integrity using primary keys? A) Allow duplicate values in the primary key column for flexibility. B) Use foreign keys to link tables without defining primary keys. C) Define a primary key for each table to uniquely identify records and enforce uniqueness and non-null constraints. D) Set primary keys to nullable to accommodate missing data. Show Answer Correct Answer: C) Define a primary key for each table to uniquely identify records and enforce uniqueness and non-null constraints. 14. What does the BETWEEN keyword do in a query? A) Selects records within a given range. B) Deletes records that fall within a range. C) Formats records for display. D) Groups records together. Show Answer Correct Answer: A) Selects records within a given range. 15. Perintah SQL yang digunakan untuk memperbarui data pada kolom 'nama' di tabel 'pelanggan' adalah ..... A) ALTER pelanggan SET nama = 'John' WHERE id = 1;. B) UPDATE pelanggan SET nama = 'John' WHERE id = 1;. C) MODIFY pelanggan SET nama = 'John' WHERE id = 1;. D) CHANGE pelanggan SET nama = 'John' WHERE id = 1;. Show Answer Correct Answer: B) UPDATE pelanggan SET nama = 'John' WHERE id = 1;. 16. What are the benefits of using views in database management? A) Views are used to increase data redundancy. B) Views help in improving the performance of database queries by allowing the database to quickly locate specific rows in a table. C) Views are only used for data deletion in a database. D) Views have no impact on database performance. Show Answer Correct Answer: B) Views help in improving the performance of database queries by allowing the database to quickly locate specific rows in a table. 17. What is the main function of tables in a database? A) To store information. B) To send emails. C) To create graphics. D) To browse the internet. Show Answer Correct Answer: A) To store information. 18. Information is obtained after ..... of data. A) Collection. B) Storage. C) Processing. D) Duplication. Show Answer Correct Answer: C) Processing. 19. The database language that allows us to access data in a database is called: A) DCL. B) DML. C) DDL. D) None Of Above. Show Answer Correct Answer: A) DCL. 20. What is a DBMS and its primary function? A) A DBMS is a cloud service for file sharing. B) A DBMS is a type of hardware used for data storage. C) A DBMS is software that manages databases, allowing for data creation, retrieval, updating, and management. D) A DBMS is a programming language for data analysis. Show Answer Correct Answer: C) A DBMS is software that manages databases, allowing for data creation, retrieval, updating, and management. 21. What challenges are associated with distributed databases? A) Uniform data storage across all nodes. B) High availability and redundancy. C) Simple query execution. D) Challenges include data consistency, network latency, partition tolerance, and complex query processing. Show Answer Correct Answer: D) Challenges include data consistency, network latency, partition tolerance, and complex query processing. 22. Mismatched redundant copies of data is known as data ..... A) Dependance. B) Redundancy. C) Inconsistency. D) Isolation. Show Answer Correct Answer: C) Inconsistency. 23. A ..... database allows access from any location with an internet connection. A) Cloud. B) Local. C) Desktop. D) Offline. Show Answer Correct Answer: A) Cloud. 24. Which of the followings are correct in relational databases? A) A relational database has one table only. B) Each attribute is shown in row in a table. C) Each record is shown in column in a table. D) Tables in relational database are referred to as relations. Show Answer Correct Answer: D) Tables in relational database are referred to as relations. 25. Suppose a change is made in the storage structure of the database files (e.g., changing from magnetic disks to SSDs). Which level of the ANSI-SPARC architecture does this affect directly? A) External level. B) Conceptual level. C) Logical level. D) Internal level. Show Answer Correct Answer: D) Internal level. ← 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