This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 88 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 88 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What does "normalization" aim to achieve in a database? A) Speed up data retrieval. B) Organize data to reduce redundancy and improve integrity. C) Create relationships between databases. D) Combine multiple columns into one. Show Answer Correct Answer: B) Organize data to reduce redundancy and improve integrity. 2. ..... refers to the data about data. A) Instance. B) Schema. C) Metadata. D) Relation. Show Answer Correct Answer: C) Metadata. 3. Which function returns the current system date? A) TODAY(). B) SYSDATE(). C) CURRENT(). D) DATE(). Show Answer Correct Answer: B) SYSDATE(). 4. In an E-R diagram that uses Chen Notation attributes are represented by A) Rectangle. B) Square. C) Ellipse. D) Triangle. Show Answer Correct Answer: C) Ellipse. 5. Which SQL keyword is used to filter records before an aggregation is performed? A) GROUP BY. B) WHERE. C) HAVING. D) DISTINCT. Show Answer Correct Answer: B) WHERE. 6. Apa fungsi CRUD dalam sebuah basis data? A) Proses pencadangan data. B) Operasi dasar pada data (Buat, Baca, Perbarui, Hapus). C) Proses migrasi data. D) Proses normalisasi basis data. E) Menghapus data dari basis data. Show Answer Correct Answer: B) Operasi dasar pada data (Buat, Baca, Perbarui, Hapus). 7. If we delete all rows from a table but keep its columns, what remains? A) Tuple. B) Domain. C) Schema. D) Instance. Show Answer Correct Answer: C) Schema. 8. Which of the following is an example of a field in a student database? A) Student ID. B) A list of all students. C) A table of student grades. D) A query to find students with grades above 90. Show Answer Correct Answer: A) Student ID. 9. What is the purpose of the 'Check' constraint? A) To enforce a condition on a column's values. B) To prevent null values. C) To define a foreign key. D) None of the above. Show Answer Correct Answer: A) To enforce a condition on a column's values. 10. Jenis hubungan manakah yang merupakan tipe hubungan dalam ERD? A) Satu-ke-Satu, Satu-ke-Banyak, Banyak-ke-Banyak. B) Satu-ke-Satu, Satu-ke-Satu, Banyak-ke-Satu. C) Banyak-ke-Banyak, Satu-ke-Satu, Dua-ke-Dua. D) Satu-ke-Banyak, Dua-ke-Banyak, Banyak-ke-Banyak. E) Dua-ke-Satu, Satu-ke-Dua, Banyak-ke-Banyak. Show Answer Correct Answer: A) Satu-ke-Satu, Satu-ke-Banyak, Banyak-ke-Banyak. 11. What is a field in a database table? A) A set of related fields. B) A single type of data. C) A field used to uniquely identify any record. D) A complete set of related records. Show Answer Correct Answer: B) A single type of data. 12. Which data type is used to store true/false values? A) BIT. B) BOOLEAN. C) LOGICAL. D) BOOL. Show Answer Correct Answer: B) BOOLEAN. 13. Which term describes a single piece of information within a record? A) File. B) Field. C) Attribute. D) Composite key. Show Answer Correct Answer: B) Field. 14. Explain the concept of data encryption in databases. A) Data encryption in databases makes data more accessible to unauthorized users. B) Data encryption in databases protects sensitive information by converting it into a coded format that is unreadable without the proper decryption key. C) Data encryption in databases is used to speed up data retrieval. D) Data encryption in databases involves storing data in plain text format. Show Answer Correct Answer: B) Data encryption in databases protects sensitive information by converting it into a coded format that is unreadable without the proper decryption key. 15. Which of the following is a characteristic of a "Many to Many" relationship in databases? A) Each table has only one record. B) Each record in one table can relate to multiple records in another table. C) Each record in one table relates to only one record in another table. D) There are no relationships between tables. Show Answer Correct Answer: B) Each record in one table can relate to multiple records in another table. 16. Perintah yang digunakan untuk menampilkan struktur table adalah ..... A) Select nama table;. B) Show databases nama table ;. C) Show tables nama table ;. D) Desc nama table:. E) Desc nama table ;. Show Answer Correct Answer: E) Desc nama table ;. 17. Which of the following is not considered a core element of an enterprise database system? A) Users. B) Database applications. C) DBMS. D) COBOL programs. Show Answer Correct Answer: D) COBOL programs. 18. What happens in the DBLC design phase? A) Analyze budget. B) Write code. C) Create logical/physical structure. D) Launch website. Show Answer Correct Answer: C) Create logical/physical structure. 19. What is "embedded SQL" ? A) SQL written by users in SQL Developer. B) SQL included within a GUI application and executed via code. C) SQL stored in a stored procedure. D) SQL used by the Oracle server to create indexes. Show Answer Correct Answer: B) SQL included within a GUI application and executed via code. 20. The SQL statement 'select round (1047.785, 2) from dual' will display 1047.78 A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 21. In the relational model, a tuple represents: A) A column. B) A row. C) A relation. D) A primary key. Show Answer Correct Answer: B) A row. 22. Which of the following is NOT a feature of a primary key? A) Uniqueness. B) Allowing null values. C) Identifying records. D) Being a candidate key. Show Answer Correct Answer: B) Allowing null values. 23. Which of the following is an example of a data model? A) SQL. B) HTML. C) Relational Model. D) Python. Show Answer Correct Answer: C) Relational Model. 24. Views constructed from SQL SELECT statements that conform to the SQL-92 standard may not contain: A) GROUP BY X. B) WHERE X. C) ORDER BY. D) FROM. Show Answer Correct Answer: C) ORDER BY. 25. In a student database, which of these would most likely be a field? A) The entire student body. B) A single student. C) The student's age. D) The school building. Show Answer Correct Answer: C) The student's age. ← 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