This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 23 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 23 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. An entity set that does not have sufficient attributes to form a primary key, is a ..... A) Primary entity set. B) Weak entity set. C) Strong entity set. D) None of the above. Show Answer Correct Answer: B) Weak entity set. 2. Interact with the system without writingprograms. Instead, they form their requests either using a database query language. A) Application Programmers. B) Sophisticated users. C) Back-End Programmers. D) System Programmers. Show Answer Correct Answer: B) Sophisticated users. 3. Which of the following is not a function of the database? A) Managing stored data. B) Manipulating data. C) Security for stored data. D) Analyzing data. Show Answer Correct Answer: D) Analyzing data. 4. Which of the following is used to manipulate data in DBMS? A) DDL. B) DML. C) CSS. D) XML. Show Answer Correct Answer: B) DML. 5. Why is it essential to use a database in a school to manage student information? A) To make the data look polished. B) To efficiently update, search, and generate reports. C) To replace teachers with computers. D) To store only numerical data. Show Answer Correct Answer: B) To efficiently update, search, and generate reports. 6. Pada menit 3:35, muncul pesan kesalahan 'ERROR 1064 (42000):You have an error in your SQL syntax;'. Apa arti umum dari pesan kesalahan ini? A) Database tidak ditemukan. B) Koneksi ke server terputus. C) Ada kesalahan dalam penulisan perintah SQL. D) Tabel tidak ada. Show Answer Correct Answer: C) Ada kesalahan dalam penulisan perintah SQL. 7. The school wants to sort the data by staff Surname. How will they sort it? A) Ascending order. B) Descending order. C) All the above. D) None of the above. Show Answer Correct Answer: A) Ascending order. 8. Which of the following is NOT a core concept in the relational database model? A) Domain. B) Tuple. C) Relation. D) Attribute. Show Answer Correct Answer: D) Attribute. 9. Perintah SQL yang digunakan untuk melihat struktur tabel, termasuk nama kolom, tipe data, dan batasan (constraints), adalah ..... A) SHOW COLUMNS FROM nama siswa;. B) DESCRIBE nama siswa;. C) INFO nama siswa;. D) GET STRUCTURE nama siswa;. Show Answer Correct Answer: B) DESCRIBE nama siswa;. 10. What is the acronym of DBMS? A) DataBase Management Symbol. B) DataBase Managing System. C) DataBase Management System. D) DataBasic Management System. Show Answer Correct Answer: C) DataBase Management System. 11. Which of these holds lots of data? A) Record. B) Field. C) Table. D) Drawing. Show Answer Correct Answer: C) Table. 12. Beyond simple identification, how does a primary key help improve the performance of a large database? A) It acts as an index to optimize storage and provide quicker searches. B) It converts all text data into images for faster visual scanning. C) It limits the search parameters to only numeric fields. D) It deletes old records automatically to keep the table size small. Show Answer Correct Answer: A) It acts as an index to optimize storage and provide quicker searches. 13. A serial schedule means: A) Transactions run interleaved. B) One after another. C) All rollback. D) None. Show Answer Correct Answer: B) One after another. 14. In MongoDB, the $ set operator is used to: A) Replace an entire document. B) Update specific fields in a document. C) Delete a field. D) Rename a collection. Show Answer Correct Answer: B) Update specific fields in a document. 15. How do you create a data entry form in Access? A) Select the Table Design view to create a data entry form. B) Import a data entry form from Excel to Access. C) Use the Form Wizard in the Create tab to create a data entry form. D) Use the Query Builder to create a data entry form. Show Answer Correct Answer: C) Use the Form Wizard in the Create tab to create a data entry form. 16. Why are databases important in modern applications? A) They provide a graphical interface for user interaction. B) They enable secure storage and efficient retrieval of data. C) They are used to develop mobile applications only. D) They manage operating system functions. Show Answer Correct Answer: B) They enable secure storage and efficient retrieval of data. 17. Rows os relation are known as the ..... A) Degree. B) Tuples. C) Entity. D) All of the above. Show Answer Correct Answer: D) All of the above. 18. Pool of values from where a column draws the value is called ..... A) Table. B) Attribute. C) Dataset. D) Domain. Show Answer Correct Answer: D) Domain. 19. ..... is information collected, stored, and analyzed within a database system. A) Data. B) Code. C) Algorithm. D) Network. Show Answer Correct Answer: A) Data. 20. Which of the following is NOT a valid foreign key in a database? A) A customer's name. B) An order's date. C) A product's name. D) A student's last name. Show Answer Correct Answer: C) A product's name. 21. In the relational model, what is a primary key? A) A column that uniquely identifies each row. B) A key that can be null. C) A column that can have duplicate values. D) A key that links to another table. Show Answer Correct Answer: A) A column that uniquely identifies each row. 22. What is the role of the DBMS in relation to application programs? A) It is not related to application programs. B) It replaces the need for application programs. C) It provides a single, combined view of the data. D) It generates application programs automatically. Show Answer Correct Answer: C) It provides a single, combined view of the data. 23. A candidate key that will most commonly be used to uniquely identify a single entity instance is said to be a A) Candidate key. B) Primary key. C) Concatenated key. D) Alternate key. Show Answer Correct Answer: B) Primary key. 24. What does RDBMS stand for? A) Relational Data Model System. B) Real Data Model System. C) Real Database Management System. D) Relational Database Management System. Show Answer Correct Answer: D) Relational Database Management System. 25. What are the advantages of using triggers in database management? A) Triggers are only useful for large databases. B) Triggers slow down database performance. C) Advantages of using triggers include automated enforcement of business rules, improved data integrity, automatic logging of changes, and reduced application complexity. D) Triggers can replace all application logic. Show Answer Correct Answer: C) Advantages of using triggers include automated enforcement of business rules, improved data integrity, automatic logging of changes, and reduced application complexity. ← 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