This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 26 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 26 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What are the different types of data that can be stored in a database? A) Text, numbers, dates, images, audio, video, and text data. B) Text, numbers, dates, images, audio, video, and binary data. C) Text, numbers, dates, images, audio, video, and character data. D) Text, numbers, dates, images, audio, video, and boolean data. Show Answer Correct Answer: B) Text, numbers, dates, images, audio, video, and binary data. 2. In relational data model, the total number of rows can be identified as ..... A) Cardinality. B) Degree. C) Attribute. D) Entity. Show Answer Correct Answer: A) Cardinality. 3. A relation in this form has no modification anomalies: A) First normal form. B) Second normal form. C) Third normal form. D) Domain/key normal form. Show Answer Correct Answer: B) Second normal form. 4. What is the purpose of data modeling in database design? A) To create hardware for storing data. B) To help programmers understand the complex flow of data. C) To prevent data from being accessed. D) To format data automatically. Show Answer Correct Answer: B) To help programmers understand the complex flow of data. 5. What are the different types of relationships that can exist between tables in a database design? A) One-to-One, One-to-Many, Many-to-Many. B) Red, Blue, Green. C) Up, Down, Left. D) Cat, Dog, Bird. Show Answer Correct Answer: A) One-to-One, One-to-Many, Many-to-Many. 6. Meta data refers to ..... A) Data. B) Empty data. C) Data about data. D) None of these. Show Answer Correct Answer: C) Data about data. 7. In a school's database, both "Admission Number" and the combination of "Class + Section + Roll No." can identify a student. These are: A) Alternate Keys. B) Foreign Keys. C) Candidate Keys. D) Composite Keys. Show Answer Correct Answer: C) Candidate Keys. 8. How many levels are in the ANSI-SPARC model? A) 2. B) 3. C) 4. D) 5. Show Answer Correct Answer: B) 3. 9. Name three types of Database Management Systems. A) Relational DBMS, NoSQL DBMS, Object-oriented DBMS. B) Flat-file DBMS. C) Hierarchical DBMS. D) Network DBMS. Show Answer Correct Answer: A) Relational DBMS, NoSQL DBMS, Object-oriented DBMS. 10. What does an RDBMS consist of? A) Collection of records. B) Collection of Keys. C) Collection of Tables. D) Collection of Fields. Show Answer Correct Answer: C) Collection of Tables. 11. Each row in a table represents a ..... A) Field. B) Record. C) Data. D) Database. Show Answer Correct Answer: B) Record. 12. Which symbol is used in query criteria to find records that begin with a specific letter? A) #. B) &. C) *. D) Like "S*". Show Answer Correct Answer: D) Like "S*". 13. What is the purpose of normalization in a database? A) Increase data redundancy. B) Optimize query speed. C) Reduce data redundancy. D) Improve data security. Show Answer Correct Answer: C) Reduce data redundancy. 14. What data type should be used for the 'RoomNumber' field in the 'Classes' table? A) Numeric. B) Text. C) Currency. D) Logical. Show Answer Correct Answer: A) Numeric. 15. Detecting and correcting data in a database or file that are incorrect, incomplete, improperly formatted, or redundant is called ..... A) Data auditing. B) Defragmentation. C) Data cleansing. D) Data optimization. Show Answer Correct Answer: C) Data cleansing. 16. .... is a repository collection of related . A) Data. B) Information. C) Database. D) None of these. Show Answer Correct Answer: C) Database. 17. What is data redundancy? A) Error that occurs during data entry. B) Unnecessary repetition of data in a database. C) Unique identifier for a record. D) Format control for data entry. Show Answer Correct Answer: B) Unnecessary repetition of data in a database. 18. A relational operator that yields all rows in one table that are not found in the other table is the ..... operator. A) UNION. B) INTERSECT. C) DIFFERENCE. D) PRODUCT. Show Answer Correct Answer: C) DIFFERENCE. 19. What type of relationship exists between two tables when a foreign key references a primary key? A) One-to-many. B) Many-to-many. C) One-to-one. D) None of the above. Show Answer Correct Answer: A) One-to-many. 20. What are the advantages of using a database management system? A) A database management system (DBMS) provides several advantages, including data integrity, data security, data consistency, data sharing, data independence, and efficient data access and retrieval. B) Reduced data redundancy and inconsistency. C) Faster data processing and retrieval. D) Improved data organization and storage. Show Answer Correct Answer: A) A database management system (DBMS) provides several advantages, including data integrity, data security, data consistency, data sharing, data independence, and efficient data access and retrieval. 21. What is one reason organizations prefer databases over spreadsheets? A) Databases can generate colorful graphs. B) Databases can handle more data points efficiently. C) Spreadsheets are only for financial reports. D) Spreadsheets are harder to understand. Show Answer Correct Answer: B) Databases can handle more data points efficiently. 22. What is the primary purpose of backup and recovery features in DBMS? A) To increase database speed. B) To reduce storage costs. C) To improve user interfaces. D) To protect against data loss and restore systems after failures. Show Answer Correct Answer: D) To protect against data loss and restore systems after failures. 23. Which of the following describes the internal level of data abstraction? A) The way users see the data. B) Logical structure of the database. C) How the data is actually stored. D) Relationship among entities. Show Answer Correct Answer: C) How the data is actually stored. 24. What is a primary key and why is it important? A) A primary key is a random number for database entries, irrelevant for data management. B) A primary key is a unique identifier for records in a database, crucial for data integrity and relationships. C) A primary key is a duplicate identifier for records, essential for data redundancy. D) A primary key is a visual representation of data, important for user interface design. Show Answer Correct Answer: B) A primary key is a unique identifier for records in a database, crucial for data integrity and relationships. 25. What is an entity-relationship model and how is it used in database design? A) It is a method for organizing files in a computer system. B) It is a visual representation of the relationships between entities in a database and is used to define the structure of the database and the relationships between different data entities. C) It is a type of computer virus used to corrupt databases. D) It is a tool for creating animations in database design. Show Answer Correct Answer: B) It is a visual representation of the relationships between entities in a database and is used to define the structure of the database and the relationships between different data entities. ← 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