This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 89 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 89 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. You have a procedure:CREATE PROC sp ..... LogEvent @EventMessage VARCHAR(200), @EventID INT OUTPUT. Which statement correctly retrieves the auto-generated ID after logging an event? A) SET @EventID = @@IDENTITY;. B) SET @EventID = IDENT CURRENT('Events');. C) SET @EventID = SCOPE IDENTITY();. D) SET @EventID = @EventMessage;. Show Answer Correct Answer: C) SET @EventID = SCOPE IDENTITY();. 2. Which of the following is a key feature of NoSQL databases? A) Fixed schema. B) Joins required for data retrieval. C) Flexible schema. D) Limited scalability. Show Answer Correct Answer: C) Flexible schema. 3. Which keyword in an UPDATE command decides which record gets changed? A) FROM. B) WHERE. C) SET. D) LIKE. Show Answer Correct Answer: B) WHERE. 4. What is one advantage of using a DBMS? A) Less security. B) More manual work. C) Controlled redundancy. D) Increased redundancy. Show Answer Correct Answer: C) Controlled redundancy. 5. Why should you avoid using calculated fields like 'age' in your database? A) They are hard to print. B) They are difficult to format. C) They can become outdated or inconsistent. D) They require special software. Show Answer Correct Answer: C) They can become outdated or inconsistent. 6. What is the role of fields in a database table? A) To determine the type of information stored. B) To play background music. C) To display images. D) To send notifications. Show Answer Correct Answer: A) To determine the type of information stored. 7. Indicate whether the statement is true or false:DBMS have a data definition capability to specify the structure of the content of the database. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 8. Which SQL command is used to add new rows to a table? A) INSERT INTO. B) DELETE FROM. C) UPDATE. D) ALTER TABLE. Show Answer Correct Answer: A) INSERT INTO. 9. How many types of relationships are there in databases? A) 1. B) 2. C) 3. D) 4. Show Answer Correct Answer: C) 3. 10. For a 'one-to-one' relationship to be established between two tables, what specific condition must the linked fields meet? A) One field must be numeric, and the other must be alphanumeric. B) The linked fields in both tables must contain the same unique values. C) Both fields must be set to the AutoNumber data type. D) One table must be a flat-file, and the other must be relational. Show Answer Correct Answer: B) The linked fields in both tables must contain the same unique values. 11. What is meant by use case in system development? A) Model of data flow between modules. B) Description of how users interact with the system. C) List of tables in the database. D) User interface design. E) System performance specifications. Show Answer Correct Answer: B) Description of how users interact with the system. 12. Which of the following is a type of database model? A) Relational model. B) Hierarchical model. C) Network model. D) Object-oriented model. Show Answer Correct Answer: A) Relational model. 13. Indicate whether the statement is true or false:Spanner is an example of a distributed database. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 14. Tables in second normal form (2NF): A) Eliminate all hidden dependencies. B) Eliminate the possibility of a insertion anomalies. C) Have a composite key. D) Have all non key fields depend on the whole primary key. Show Answer Correct Answer: A) Eliminate all hidden dependencies. 15. What is the main difference between relational and non-relational databases? A) Non-relational databases are easier to use. B) Relational databases use tables, while non-relational do not. C) Non-relational databases are more secure. D) Relational databases are faster. Show Answer Correct Answer: B) Relational databases use tables, while non-relational do not. 16. Manakah yang merupakan contoh dari relasi one to one A) Negara dan kota. B) Mahasiswa dan kampus. C) Warga negara dan nomor KTP. D) Mahasiswa dan mata pelajaran. Show Answer Correct Answer: C) Warga negara dan nomor KTP. 17. How can you optimize a subquery for better performance? A) Use JOINs instead of subqueries, limit returned data, and index relevant columns. B) Use nested subqueries for all data retrieval. C) Select all columns without filtering results. D) Avoid indexing columns to reduce complexity. Show Answer Correct Answer: A) Use JOINs instead of subqueries, limit returned data, and index relevant columns. 18. What does clicking OK after renaming a table do? A) Saves the new table name. B) Deletes the table. C) Closes MS Access. D) Restarts the software. Show Answer Correct Answer: A) Saves the new table name. 19. What must you do to maintain data integrity when you normalize a relation by breaking it into two smaller relations? A) Create a primary key(s) for the new relation. B) Denormalize the data. C) Assign both relations the same primary key field(s). D) Remove any functional dependencies from both relations. Show Answer Correct Answer: A) Create a primary key(s) for the new relation. 20. Which symbol is used as a wildcard for multiple characters in LIKE? A) %. B) . C) *. D) ?. Show Answer Correct Answer: A) %. 21. Quale tipo di attributo ha un tipo semplice, come numeri interi o stringhe? A) Opzionale. B) Composto. C) Multiplo. D) Semplice. Show Answer Correct Answer: D) Semplice. 22. A field in a database table whose values are the same as the primary key of another table is called ..... A) A foreign key. B) A primary key. C) Metadata. D) An alternate key. Show Answer Correct Answer: A) A foreign key. 23. In the relational table, which of the following can also be represented by the term 'attribute'? A) Entity. B) Row. C) Column. D) Both A and C. Show Answer Correct Answer: C) Column. 24. The select operation ..... A) Combines relational tables to provide the user with more information than is otherwise available. B) Creates a subset consisting of rows in a table that meet stated criteria. C) Identifies the table from which the columns will be selected. D) Creates a subset consisting of all records in a file. Show Answer Correct Answer: B) Creates a subset consisting of rows in a table that meet stated criteria. 25. What is one to one relationship means? A) Each record in the first table is related to only one record in the second table, but not vice versa. B) Each record in the first table is related to only one record in the second table, and vice versa. C) Each record in the first table is not related to any record in the second table. D) Each record in the first table is related to multiple records in the second table. Show Answer Correct Answer: B) Each record in the first table is related to only one record in the second table, and vice versa. ← 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