This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 20 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 20 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Dalam perintah SQL, apa fungsi dari 'JOIN'? A) Menampilkan struktur tabel. B) Membuat salinan tabel baru. C) Menghapus data dari tabel. D) Menggabungkan dua atau lebih tabel berdasarkan kolom yang terkait. Show Answer Correct Answer: D) Menggabungkan dua atau lebih tabel berdasarkan kolom yang terkait. 2. Imagine you are designing a database for a library. Which type of database would be most suitable and why? A) Flat-file database, because it is easier to set up. B) Relational database, because it allows for complex relationships between books, borrowers, and loans. C) Flat-file database, because it supports larger data sets. D) Relational database, because it is faster for simple queriesTagsDOK Level 3:Strategic Thinking. Show Answer Correct Answer: B) Relational database, because it allows for complex relationships between books, borrowers, and loans. 3. Which validation method checks that a field is not left blank? A) Range Check. B) Type Check. C) Presence Check. D) Lookup Check. Show Answer Correct Answer: C) Presence Check. 4. A 2NF table can exhibit ..... dependency. A) Partial. B) Complete. C) Transitive. D) Indirect. Show Answer Correct Answer: C) Transitive. 5. Which of the following constraints ensures that a column cannot have NULL values, but does not imply uniqueness? A) UNIQUE. B) PRIMARY KEY. C) NOT NULL. D) CHECK. Show Answer Correct Answer: C) NOT NULL. 6. A database ..... is a sketch of design of a planned data. A) Instance. B) Schema. C) Metadata. D) Relation. Show Answer Correct Answer: B) Schema. 7. ASSERTION:-Primary Key is a set of attributes (or attribute) which uniquely identify the tuples in relation or table. REASON:-There may be more than one primary key in a table. A) Both A and R are true and R is the correct explanation for A. B) Both A and R are true and R is not the correct explanation for A. C) A is True but R is False. D) A is false but R is True. Show Answer Correct Answer: C) A is True but R is False. 8. Which of the following best describes data integrity? A) The speed at which data can be accessed. B) The overall completeness, accuracy, and consistency of data. C) The ability to recover data after a system crash. D) The process of organizing data into tables. Show Answer Correct Answer: B) The overall completeness, accuracy, and consistency of data. 9. Importance of data types in table design A) Data types specify the kind of data that can be stored and affect storage requirements. B) Data types are irrelevant to table design. C) Data types only affect the visual representation of data. D) Data types determine the speed of data retrieval. Show Answer Correct Answer: A) Data types specify the kind of data that can be stored and affect storage requirements. 10. Which type of serializability depends on conflict rules? A) Conflict serializability. B) View serializability. C) Cascaded. D) Recoverable. Show Answer Correct Answer: A) Conflict serializability. 11. Dibawah ini perintah yang digunakan untuk membuat database PTS adalah ..... A) Create PTS;. B) Database PTS;. C) Create database PTS;. D) Create databases PTS;. E) Create database PTS:. Show Answer Correct Answer: C) Create database PTS;. 12. Define a field in a database. A) A field is a column in a database table that stores a specific attribute of the data. B) A field is a command used to query data from a database. C) A field is a type of database that stores entire datasets. D) A field is a row in a database table that contains multiple attributes. Show Answer Correct Answer: A) A field is a column in a database table that stores a specific attribute of the data. 13. What is the purpose of a DBMS in a school setting? A) To store student information. B) To track student attendance. C) To track student grades. D) All of the above. Show Answer Correct Answer: D) All of the above. 14. What distinguishes a primary key from a regular field? A) A primary key is unique and identifies records, while a regular field can have duplicate values. B) A primary key is used for indexing, while a regular field is not. C) A primary key is a type of regular field that can be null. D) A primary key can have duplicate values, while a regular field is always unique. Show Answer Correct Answer: A) A primary key is unique and identifies records, while a regular field can have duplicate values. 15. What is the main issue with a file-based approach to data management? A) It requires less storage space. B) It can lead to data integrity problems. C) It allows for easy data sharing. D) It is always more secure than databases. Show Answer Correct Answer: B) It can lead to data integrity problems. 16. Primary Key A) A unique identifier for each record in a table. B) A field that can contain duplicate values. C) A field that is not indexed. D) A field that can be left empty. Show Answer Correct Answer: A) A unique identifier for each record in a table. 17. Which data model uses records and sets to define multiple relationships? A) Relational. B) Object-oriented. C) Hierarchical. D) Network. Show Answer Correct Answer: D) Network. 18. In an input mask, what does the character '0' represent? A) User must enter a digit (0 to 9). B) User can enter a digit (0 to 9). C) User must enter either a character or a space. D) User can enter a letter or a digit. Show Answer Correct Answer: A) User must enter a digit (0 to 9). 19. Tujuan penggunaan basis data adalah, kecuali ..... A) Kecepatan. B) Akurasi. C) Berbagi. D) Kekuatan. E) Keamanan. Show Answer Correct Answer: D) Kekuatan. 20. Which of these is a correct rule for designing a database? A) Always enter duplicate records. B) Use calculated fields whenever possible. C) Use dropdown lists instead of repeated values. D) Combine multiple values in a single field. Show Answer Correct Answer: C) Use dropdown lists instead of repeated values. 21. What does the term 'normalization' refer to in database design? A) The process of creating a database. B) The process of organizing data to reduce redundancy. C) The process of querying data. D) The process of backing up data. Show Answer Correct Answer: B) The process of organizing data to reduce redundancy. 22. The first phase of DBLC is: A) Design. B) Maintenance. C) Implementation. D) Initial Study. Show Answer Correct Answer: D) Initial Study. 23. What is a set of rules that define valid data called? A) Constraints. B) Data dictionary. C) Query. D) All of these. Show Answer Correct Answer: A) Constraints. 24. Apa itu tag dalam HTML dan bagaimana cara menggunakannya? A) Tag digunakan untuk membuat gambar di halaman web. B) Tag digunakan untuk membuat formulir di halaman web. C) Tag digunakan untuk membuat daftar di halaman web. D) Tag dalam HTML digunakan untuk membuat tabel di halaman web. Untuk menggunakan tag, kita harus menuliskan tag diikuti dengan tag untuk baris, tag untuk sel data, dan tag untuk sel header. Show Answer Correct Answer: D) Tag dalam HTML digunakan untuk membuat tabel di halaman web. Untuk menggunakan tag, kita harus menuliskan tag diikuti dengan tag untuk baris, tag untuk sel data, dan tag untuk sel header. 25. What is the difference between importing and entering data? A) Importing data is only for large datasets. B) Entering data requires special software tools. C) Importing data is always faster than entering data. D) Importing data is bulk transfer from external sources, while entering data is manual input. Show Answer Correct Answer: D) Importing data is bulk transfer from external sources, while entering data is manual input. ← 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