This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 72 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 72 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. DBMSs typically include report generation tools in order to ..... A) Retrieve and display data. B) Display data in a more structured and polished format than would be possible just by querying. C) Display data in graphs. D) Perform predictive analysis. Show Answer Correct Answer: B) Display data in a more structured and polished format than would be possible just by querying. 2. In SQL, which of the following can be used to limit the number of rows returned by a query? A) HAVING. B) GROUP BY. C) LIMIT. D) DISTINCT. Show Answer Correct Answer: C) LIMIT. 3. In SQL, what is the difference between CHAR and VARCHAR data types? A) CHAR is fixed length, VARCHAR is variable length. B) CHAR is variable length, VARCHAR is fixed length. C) No difference. D) VARCHAR is used only for numeric data. Show Answer Correct Answer: A) CHAR is fixed length, VARCHAR is variable length. 4. The SQL statementSELECT ROUND(45.926, -1) FROM DUAL; A) Is illegal. B) Prints garbage. C) Prints 045.926. D) Prints 50. Show Answer Correct Answer: D) Prints 50. 5. What is SQL injection and how can it be prevented? A) SQL injection is a method to enhance database performance. B) SQL injection is a code injection technique that exploits vulnerabilities in applications. It can be prevented by using prepared statements, parameterized queries, and input validation. C) It can be avoided by using regular expressions and data encryption. D) SQL injection is a technique for optimizing SQL queries. Show Answer Correct Answer: B) SQL injection is a code injection technique that exploits vulnerabilities in applications. It can be prevented by using prepared statements, parameterized queries, and input validation. 6. What is concurrency in the context of databases? A) The speed at which database operations are performed. B) The simultaneous execution of multiple transactions. C) The process of creating backup copies of the database. D) The ability to store large amounts of data. Show Answer Correct Answer: B) The simultaneous execution of multiple transactions. 7. Which of the following is not a characteristic of a good database design? A) Data integrity. B) Data redundancy. C) Scalability. D) Efficiency. Show Answer Correct Answer: B) Data redundancy. 8. Mana yang BUKAN merupakan atribut? A) Nama. B) Nomor telepon. C) Email. D) Hubungan dengan pemasok. Show Answer Correct Answer: D) Hubungan dengan pemasok. 9. Where is the foreign key used in a one-to-many relationship? A) In the table on the 'one' side of the relationship. B) In the table on the 'many' side of the relationship. C) In both tables involved in the relationship. D) Foreign keys are not used in one-to-many relationships. Show Answer Correct Answer: B) In the table on the 'many' side of the relationship. 10. Section B:Multiple Choice (5 marks)-Circle or write the correct letter (A, B, C, or D). Which of the following is a disadvantage of a database? A) It requires training and setup costs. B) It reduces duplication. C) It makes updates easier. D) It increases data accuracy. Show Answer Correct Answer: A) It requires training and setup costs. 11. A transaction is a unit of work performed within a database management system against a database. A) False. B) True. C) All the above. D) None of the above. Show Answer Correct Answer: B) True. 12. The vertical section (column) in a table is known as: A) Field. B) Record. C) View. D) Form. Show Answer Correct Answer: A) Field. 13. When a database is used for a web application to display high-resolution product images, which data type is specifically intended to hold these files? A) Long Integer. B) Alphanumeric (Short Text). C) Attachment or OLE object. D) Boolean. Show Answer Correct Answer: C) Attachment or OLE object. 14. .... includes all tuples that are in tables A or in B. A) Union. B) Intersection. C) Product. D) Set difference. Show Answer Correct Answer: A) Union. 15. Depending on the type of data organization, the following basic models of data representation are distinguished in the database? A) Hierarchical; network;relationships. B) To each other; relationshipone-many and many-one;many relationships. C) Individual and group. D) Everything is correct. E) Operational and non-operational. Show Answer Correct Answer: A) Hierarchical; network;relationships. 16. Apa itu foreign key dalam database? A) Foreign key digunakan untuk menghapus data dari tabel induk. B) Foreign key adalah kolom yang tidak memiliki hubungan dengan tabel lain. C) Foreign key hanya dapat mengacu pada kunci utama dalam tabel yang sama. D) Foreign key adalah kolom atau serangkaian kolom dalam sebuah tabel yang mengacu pada kunci utama kolom atau serangkaian kolom lain dalam tabel lain, yang digunakan untuk membangun hubungan antar tabel. Show Answer Correct Answer: D) Foreign key adalah kolom atau serangkaian kolom dalam sebuah tabel yang mengacu pada kunci utama kolom atau serangkaian kolom lain dalam tabel lain, yang digunakan untuk membangun hubungan antar tabel. 17. Why is credential management important? A) It ensures secure authentication and user identity. B) It logs password reuse. C) It enables storing passwords in plaintext for easy recovery. D) None of the above. Show Answer Correct Answer: A) It ensures secure authentication and user identity. 18. What are the steps to design a form in Access? A) Choose 'Design View' for a report instead. B) 1. Open Access and select the database. 2. Go to 'Create' tab. 3. Click 'Form Design'. 4. Add controls. 5. Set properties. 6. Save the form. 7. Test in 'Form View'. C) Select 'File' and create a new table. D) Go to 'Home' tab and click 'Import'. Show Answer Correct Answer: B) 1. Open Access and select the database. 2. Go to 'Create' tab. 3. Click 'Form Design'. 4. Add controls. 5. Set properties. 6. Save the form. 7. Test in 'Form View'. 19. Indicate whether the statement is true or false:Multiple data marts are combined and streamlined to create a data warehouse. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 20. What is the relationship where one entry in one table has a single entry in the other table and vice versa? A) One-to-one. B) One-to-many. C) Many-to-many. D) None of the above. Show Answer Correct Answer: A) One-to-one. 21. What is the role of a database index? A) To speed up data retrieval. B) To store data securely. C) To create relationships between tables. D) To back up data automatically. Show Answer Correct Answer: A) To speed up data retrieval. 22. Which of the following is an example of a non-relational database? A) Oracle. B) PostgreSQL. C) MySQL. D) MongoDB. Show Answer Correct Answer: D) MongoDB. 23. A ..... is a stored program that is attached to a table or a view. A) Pseudofile. B) Embedded SELECT statement. C) Trigger. D) None of the above is correct. Show Answer Correct Answer: C) Trigger. 24. Why are database systems important for businesses? A) They prevent electricity loss. B) They enhance business intelligence. C) They improve office layout. D) They are required by law. Show Answer Correct Answer: B) They enhance business intelligence. 25. Table A) Tables are used to store images in a database. B) Tables contain sets of records in a database. C) Tables are only used for temporary data storage. D) Tables can only hold numeric data. Show Answer Correct Answer: B) Tables contain sets of records in a database. ← 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