This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 3 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 3 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Which of the following is NOT a valid data type in MS Access? A) Hyperlink. B) Memo. C) Audio. D) Currency. Show Answer Correct Answer: C) Audio. 2. Which SQL statement is used to grant ALL privilege on the SUPPLIERS in the schema to the user 'Manager'? A) REVOKE ALL ON SUPPLIERS TO Manager. B) GRANT ALL ON SUPPLIERS TO Manager. C) CREATE USER ON SUPPLIERS TO Manager. D) GRANT ALL ON SUPPLIERS. Show Answer Correct Answer: B) GRANT ALL ON SUPPLIERS TO Manager. 3. Berikut ini perintah yang digunakan untuk menampilkan nama dan alamat dari tabelBUKU yang di urutkan berdasarkan alamat secara urut turun ..... A) Select nama, alamat from buku order by alamat;. B) Select nama, alamat from buku order by alamat asc;. C) Select nama, alamat from buku order by alamat desc;. D) Select nama.alamat from buku order by alamat asc;. E) Select nama.alamat from buku order by alamat desc;. Show Answer Correct Answer: C) Select nama, alamat from buku order by alamat desc;. 4. Rasheed is organizing his music collection on his computer. Each song has information like title, artist, album, and duration. In the context of a database, what would each song represent? A) A collection of related data fields. B) A single column in a table. C) A set of duplicate entries. D) A backup of the database. Show Answer Correct Answer: A) A collection of related data fields. 5. Which of the following is NOT a good design practice? A) Avoid calculated fields. B) Use a dropdown for repeated values. C) Create identical key records. D) Assign appropriate data types. Show Answer Correct Answer: C) Create identical key records. 6. What is the primary objective of database security? A) To prevent unauthorized access and disclosure of data. B) To prevent packet loss while transferring data. C) To provide secure access to public data. D) None of the above. Show Answer Correct Answer: A) To prevent unauthorized access and disclosure of data. 7. What does debugging involve? A) Writing source code. B) Correcting errors in the program. C) Converting machine code into source code. D) Drawing flowcharts. Show Answer Correct Answer: B) Correcting errors in the program. 8. Where does the DBMS store the definitions of data elements and their relationships? A) Data file. B) Index. C) Data dictionary. D) Data map. Show Answer Correct Answer: C) Data dictionary. 9. Which of the following is a benefit of using a DBMS? A) They provide full security to data using private/public key encryption. B) They create automatic queries. C) They help create an environment for centralized control. D) They provide seamless Internet access to database data. Show Answer Correct Answer: C) They help create an environment for centralized control. 10. When a school's database is password protected and only the principal can change marks, it shows: A) Data Sharing. B) Data Security. C) Data Redundancy. D) Data Normalization. Show Answer Correct Answer: B) Data Security. 11. What is the purpose of an index in a database? A) To store data in a compressed format. B) To speed up data retrieval. C) To ensure data integrity. D) To create backups of the database. Show Answer Correct Answer: B) To speed up data retrieval. 12. Setelah membuat database 'siswa', perintah apa yang harus digunakan untuk memilih database tersebut agar dapat bekerja di dalamnya? A) SELECT siswa;. B) OPEN siswa;. C) USE siswa;. D) ACTIVATE siswa;. Show Answer Correct Answer: C) USE siswa;. 13. What is a characteristic of 'program-data independence'? A) Data can be accessed only by one program. B) Programs can be changed without affecting data structures. C) Data structures must remain constant. D) Programs must be rewritten for every data change. Show Answer Correct Answer: B) Programs can be changed without affecting data structures. 14. What is the simplest kind of database described here? A) A flat file storing one entity. B) A network model of relations. C) A hierarchical tree of folders. D) A relational schema with keys. Show Answer Correct Answer: A) A flat file storing one entity. 15. What is the primary feature of distributed filesystems like HDFS? A) Data distribution facilitates data access speed but hinders fault tolerance. B) Data is stored in a physically distributed manner for lower latency. C) Data is partitioned and replicated across nodes for fault tolerance. D) None of the above. Show Answer Correct Answer: C) Data is partitioned and replicated across nodes for fault tolerance. 16. Which of the following wildcard characters represents 'any number of characters'? A) ?. B) *. C) #. D) []. Show Answer Correct Answer: B) *. 17. In the relational modes, cardinality is termed as: A) Number of tuples. B) Number of attributes. C) Number of tables. D) Number of constraints. Show Answer Correct Answer: A) Number of tuples. 18. What does the following SQL statement do? Delete from Customer ..... T where state = 'HI'; A) Deletes all records from customer t where the state is equal to HI. B) Removes the Customer T table from the database. C) Deletes all records from the Customer T table. D) Doesn't delete anything because of a syntax error. Show Answer Correct Answer: A) Deletes all records from customer t where the state is equal to HI. 19. Database specification A) The reliability and integrity of the data is also ensured in the database. B) It can be much faster than typing on the keyboard. C) Easier for a beginner to learn/use. D) Not very good for novice users. E) It can be much faster than typing on the keyboard. Show Answer Correct Answer: A) The reliability and integrity of the data is also ensured in the database. 20. The basic structure of data in relational model is ..... A) Row. B) Column. C) Tables. D) Data. Show Answer Correct Answer: C) Tables. 21. What is the significance of "Transactions" and "Transaction Processing" in a database? A) To use objects that represent real-world occurrences. B) To represent a property, quality, or characteristic of the entity. C) To ensure that the data does not get out of sync. D) To enable the ability for an attribute to accept null values. Show Answer Correct Answer: C) To ensure that the data does not get out of sync. 22. What is meant by 'data abstraction' in a database? A) Storing data in multiple formats. B) Creating backups of data. C) Hiding storage details and presenting a conceptual view. D) Accessing data through web applications. Show Answer Correct Answer: C) Hiding storage details and presenting a conceptual view. 23. Consider the following schema:SUPPLIERS(SupplierID, SupplierName, Address) Which SQL statement is used to REVOKE ALL privilege on the SUPPLIERS in the schema to the user 'Manager'? A) REVOKE ALL ON SUPPLIERS FROM Manager. B) GRANT ALL ON SUPPLIERS TO Manager. C) REVOKE ALL ON SUPPLIERS TO Manager. D) REVOKE ALL ON SUPPLIERS. Show Answer Correct Answer: A) REVOKE ALL ON SUPPLIERS FROM Manager. 24. In MS Access, which option allows users to create a form quickly? A) Ribbon. B) Create Tab. C) Print Preview. D) Page Layout. Show Answer Correct Answer: B) Create Tab. 25. Which selection rule would return all the records where age is greater than 25? A) Age <> 25. B) Age < 25. C) Age > 25. D) Age =< 25. Show Answer Correct Answer: C) Age > 25. ← 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 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 10Class 11 Computer Science Chapter 7 Database Concepts Quiz 11 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books