This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 19 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 19 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Which is a key advantage of NoSQL databases? A) Strong consistency. B) High flexibility and scalability. C) Fixed schemas. D) Complex joins support. Show Answer Correct Answer: B) High flexibility and scalability. 2. What operations can be performed using relational query languages? A) Inserting, updating, deleting, and retrieving. B) Creating, modifying, exporting, and importing. C) Selection, projection, joining, union, and aggregation. D) Sorting, filtering, grouping, and indexing. Show Answer Correct Answer: C) Selection, projection, joining, union, and aggregation. 3. What is the purpose of forms in a database? A) To provide a user-friendly interface. B) To print documents. C) To edit videos. D) To play music. Show Answer Correct Answer: A) To provide a user-friendly interface. 4. Why is it important to have a primary key in a database table? A) To save disk space. B) To enforce referential integrity. C) To improve query performance. D) To uniquely identify each record and ensure data integrity. Show Answer Correct Answer: D) To uniquely identify each record and ensure data integrity. 5. What is a common method used in predictive analysis? A) Regression analysis. B) Data cleaning. C) Descriptive statistics. D) Data warehousing. Show Answer Correct Answer: A) Regression analysis. 6. How can views improve data security? A) Views can delete sensitive data automatically. B) Views enhance performance but do not affect security. C) Views allow unrestricted access to all data. D) Views improve data security by restricting access to sensitive data and enforcing data access policies. Show Answer Correct Answer: D) Views improve data security by restricting access to sensitive data and enforcing data access policies. 7. What is an example of a one-to-one (1:1) relationship? A) Each person has one unique passport. B) A teacher can teach multiple classes. C) Students can enroll in multiple courses. D) A class can have multiple teachers. Show Answer Correct Answer: A) Each person has one unique passport. 8. ..... allows us to have relationship between tables which makes the data more meaningful and connected. A) DBMS. B) Program. C) Software. D) Hardware. Show Answer Correct Answer: A) DBMS. 9. What is a primary reason for using a relational database instead of a flat file? A) Improving data consistency. B) Easier data deletion. C) Faster data retrieval. D) Simpler data structure. Show Answer Correct Answer: A) Improving data consistency. 10. What happens if atomicity is not maintained in a bank transaction? A) The system slows down. B) One account may be debited but the other not credited. C) Data remains permanently saved. D) User login fails. Show Answer Correct Answer: B) One account may be debited but the other not credited. 11. According to the text, why is this 'flat-file' approach considered inefficient? A) It makes the data too secure for daily use. B) It requires data to be entered many times, increasing the risk of entry errors. C) It prevents the use of alphanumeric data types. D) It makes the database too small to be searched effectively. Show Answer Correct Answer: B) It requires data to be entered many times, increasing the risk of entry errors. 12. Dalam diagram ERD, hubungan antara entitas diwakili oleh: A) Garis penghubung. B) Oval. C) Persegi panjang. D) Belah ketupat (rhombus). E) Segitiga. Show Answer Correct Answer: A) Garis penghubung. 13. If a student's section is changed from A to B but updated only in one record, it leads to: A) Data Inconsistency. B) Data Security. C) Data Sharing. D) Data Integrity. Show Answer Correct Answer: A) Data Inconsistency. 14. What is the 'AutoNumber' data type used for? A) To store monetary data. B) To generate unique values for records. C) To store large amounts of text. D) To store text data. Show Answer Correct Answer: B) To generate unique values for records. 15. Discuss the process of denormalization in database design. A) Denormalization has no impact on data integrity and duplication. B) Denormalization is the process of increasing redundancy in a database to ensure data accuracy. C) Denormalization involves combining multiple tables into one to simplify the database structure. D) Denormalization in database design is the process of adding redundant data to a database to improve read performance for large tables. Show Answer Correct Answer: D) Denormalization in database design is the process of adding redundant data to a database to improve read performance for large tables. 16. What term is used in databases instead of 'rows' in spreadsheets? A) Fields. B) Records. C) Tables. D) Columns. Show Answer Correct Answer: B) Records. 17. The view of total database contents is A) Conceptual view. B) Internal view. C) External view. D) Physical view. Show Answer Correct Answer: A) Conceptual view. 18. The manipulative part of a data model mainly specifies: A) The physical devices used to store data. B) The operations that can be performed on the data. C) The job descriptions of DBMS users. D) The graphical notation of ER diagrams. Show Answer Correct Answer: B) The operations that can be performed on the data. 19. What is an entity in an Entity-Relationship model? A) An entity is a process that describes how data is manipulated. B) An entity is a collection of attributes without any distinct identity. C) An entity is a type of relationship between two objects. D) An entity is a distinct object or thing in the real world that can be identified and has attributes. Show Answer Correct Answer: D) An entity is a distinct object or thing in the real world that can be identified and has attributes. 20. Which of the following is a specialized language that programmers use to add and change data in the database? A) Data access language. B) Data manipulation language. C) Database language. D) Data definition language. Show Answer Correct Answer: B) Data manipulation language. 21. What does the term 'referential integrity' mean? A) Ensuring that data is encrypted. B) Ensuring that data is backed up. C) Ensuring that foreign keys correctly reference primary keys. D) Ensuring that all data is unique. Show Answer Correct Answer: C) Ensuring that foreign keys correctly reference primary keys. 22. Which relationship type ensures that each record in the first table is linked to only one record in the second table? A) One-to-One. B) One-to-Many. C) Many-to-Many. D) Many-to-One. Show Answer Correct Answer: A) One-to-One. 23. Which SQL data type is used to store numerical values with fixed precision and scale? A) DECIMAL. B) INTEGER. C) DATE. D) VARCHAR. Show Answer Correct Answer: A) DECIMAL. 24. What is the main function of a database? A) To encrypt data. B) To visualize data. C) To delete data. D) To store data. Show Answer Correct Answer: D) To store data. 25. The logical view of a database ..... A) Displays the organization and structure of data on the physical storage media. B) Includes a digital dashboard. C) Allows the creation of supplementary reports. D) Presents data as they would be perceived by end users. Show Answer Correct Answer: D) Presents data as they would be perceived by end users. ← 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