This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 36 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 36 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Which of the following is TRUE about the atomicity of a database? A) All transactions are considered to be a single entity. B) Incomplete changes are also recorded. C) Multiple operations of a transaction are considered to be a single entity. D) None of the above. Show Answer Correct Answer: C) Multiple operations of a transaction are considered to be a single entity. 2. What is a composite key in a relational database? A) A key that consists of two or more attributes. B) A key that is generated automatically. C) A key that is used for indexing. D) A key that is unique to each record. Show Answer Correct Answer: A) A key that consists of two or more attributes. 3. If "Admission Number" is chosen as the primary key, the combination "Class + Section + Roll No." becomes the: A) Foreign Key. B) Alternate Key. C) Primary Key. D) Domain. Show Answer Correct Answer: B) Alternate Key. 4. What is the significance of theoretical relational languages? A) They focus solely on graphical representations of data. B) They offer a formal framework for understanding data relationships and support the development of robust database systems. C) They simplify the process of data entry in databases. D) They eliminate the need for data normalization. Show Answer Correct Answer: B) They offer a formal framework for understanding data relationships and support the development of robust database systems. 5. .... Father of Relational DataBase . A) Dr. canon F Codd. B) Dr. Edgar F Code. C) Dr. Edgar F Codd. D) Dr. Edgar F Chen. Show Answer Correct Answer: C) Dr. Edgar F Codd. 6. Apa itu primary key dalam database? A) Sebuah kolom atau kumpulan kolom yang secara unik mengidentifikasi setiap baris dalam sebuah tabel. B) Sebuah kolom yang tidak unik dalam sebuah tabel. C) Sebuah kolom yang tidak diperlukan dalam sebuah tabel. D) Sebuah kolom yang dapat diubah setiap saat dalam sebuah tabel. Show Answer Correct Answer: A) Sebuah kolom atau kumpulan kolom yang secara unik mengidentifikasi setiap baris dalam sebuah tabel. 7. Explain the difference between INNER JOIN and OUTER JOIN. A) INNER JOIN includes all records from both tables. B) OUTER JOIN provides only unmatched records from one table. C) INNER JOIN provides only matched records, while OUTER JOIN includes all records from one table and matched records from the other. D) INNER JOIN and OUTER JOIN are the same and can be used interchangeably. Show Answer Correct Answer: C) INNER JOIN provides only matched records, while OUTER JOIN includes all records from one table and matched records from the other. 8. Which technique involves using locks to control access to data? A) Locking. B) Data validation. C) Multi-version Concurrency Control. D) Time-stamping. Show Answer Correct Answer: A) Locking. 9. What does database scalability refer to? A) The speed of data retrieval. B) The ability to handle increasing demands. C) The type of data stored. D) The security of the database. Show Answer Correct Answer: B) The ability to handle increasing demands. 10. Boolean A) A field that can have multiple values. B) A field that can only have two possible values. For example: "on/off", "true/false", "yes/no" . C) A field that represents a numerical value. D) A field that can store text data. Show Answer Correct Answer: B) A field that can only have two possible values. For example: "on/off", "true/false", "yes/no" . 11. Which of the following is NOT a benefit of using a database management system? A) Improved data security. B) Reduced data redundancy. C) Increased data inconsistency. D) Enhanced data accessibility. Show Answer Correct Answer: C) Increased data inconsistency. 12. In a database, a record represents: A) A whole table. B) One row of information about a person or item. C) A binary code for letters. D) A column of values. Show Answer Correct Answer: B) One row of information about a person or item. 13. Which of the following is NOT a type of database testing? A) Structural Database Testing. B) Functional Database Testing. C) Non-functional Testing. D) Operational Database Testing. Show Answer Correct Answer: D) Operational Database Testing. 14. Which of the following is an example of a domain in a database? A) A specific table in a database. B) A set of all possible values for a particular attribute. C) A relationship between two tables. D) A unique identifier for a row in a table. Show Answer Correct Answer: B) A set of all possible values for a particular attribute. 15. What is the purpose of field properties? A) To print reports. B) To delete old data. C) To determine how a field is stored and displayed. D) To create new records. Show Answer Correct Answer: C) To determine how a field is stored and displayed. 16. What is a database program used for? A) Writing documents. B) Organizing and retrieving information. C) Creating graphics. D) Browsing the internet. Show Answer Correct Answer: B) Organizing and retrieving information. 17. What is the first step in database design? A) Avoid storing the same data. B) Data modelling. C) Stay up-to-date. D) Keep consistency with relevant raw facts. Show Answer Correct Answer: B) Data modelling. 18. What is the primary function of a DBMS? A) To store data in a cloud. B) To provide internet access to databases. C) To facilitate the creation and maintenance of a computerized database. D) To create hardware for databases. Show Answer Correct Answer: C) To facilitate the creation and maintenance of a computerized database. 19. Berikut ini perintah yang digunakan untuk merubah nama tabel buku menjadi LKS adalah ..... A) Rename buku to LKS;. B) Alter buku to LKS;. C) Alter table buku change to LKS;. D) Alter table buku modify to LKS;. E) Rename table buku to LKS;. Show Answer Correct Answer: E) Rename table buku to LKS;. 20. Data is unorganised and no meaning or context. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 21. SQL command to create a table A) CREATE TABLE. B) INSERT INTO. C) DROP TABLE. D) SELECT * FROM. Show Answer Correct Answer: A) CREATE TABLE. 22. Which of the following is an example of a database? A) A list of students in a class with their names and ages. B) A storybook. C) A calculator. D) A video game. Show Answer Correct Answer: A) A list of students in a class with their names and ages. 23. Which ACID property ensures that a transaction brings the database from one valid state to another? A) Atomicity. B) Consistency. C) Isolation. D) Durability. Show Answer Correct Answer: B) Consistency. 24. What is a candidate key? A) A key that is always selected as the primary key. B) A key that could potentially be a primary key. C) A key that is not used in any table. D) A key that is used for indexing. Show Answer Correct Answer: B) A key that could potentially be a primary key. 25. ..... is a top-down process in EERD. It divides high level entities into lower levels. Example:EMPLOYEES can have subclass of Teachers or Technicians. A) Specialization. B) Generalization. C) Association. D) Aggregation. Show Answer Correct Answer: A) Specialization. ← 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