This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 70 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 70 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Identify the types of Data Anomalies: A) Add, Delete and Save anomalies. B) Insert, Add and Save anomalies. C) Update, Save and Insert anomalies. D) Insert, Delete and Update anomalies. Show Answer Correct Answer: D) Insert, Delete and Update anomalies. 2. A file in a database consists of: A) A collection of records. B) A collection of databases. C) A single record. D) A single field. Show Answer Correct Answer: A) A collection of records. 3. What does the BEGIN/END block do in T-SQL? A) Defines a variable. B) Executes a set of SQL statements together. C) Creates a new database. D) Ends a database connection. Show Answer Correct Answer: B) Executes a set of SQL statements together. 4. Which option in MS Access is used to open an already created database? A) Create New. B) Blank Database. C) Open Recent Database. D) Exit. Show Answer Correct Answer: C) Open Recent Database. 5. When would you use the "Boolean" data type in a database? A) To store employee names. B) To indicate whether an item is in stock (Yes/No). C) To store customer addresses. D) To calculate total salesTagsLO2. Show Answer Correct Answer: B) To indicate whether an item is in stock (Yes/No). 6. What is another term for a database record? A) Tuple. B) Attribute. C) Key. D) Index. Show Answer Correct Answer: A) Tuple. 7. What is a major disadvantage of the file system? A) High performance. B) Low data redundancy. C) Data inconsistency. D) Centralized management. Show Answer Correct Answer: C) Data inconsistency. 8. Which of the following provides centralized control of data? A) File system. B) DBMS. C) Operating system. D) Compiler. Show Answer Correct Answer: B) DBMS. 9. True or False:The "Value" of a relational database represents the entity for which it has value for each attribute? A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 10. Network Structure A) A database structure where records can have multiple relationships. B) A linear arrangement of data records. C) A hierarchical model with a single parent for each record. D) A flat file system with no relationships between records. Show Answer Correct Answer: A) A database structure where records can have multiple relationships. 11. In the context of database systems, what does 'CRUD' stand for? A) Create, Read, Update, Delete. B) Compile, Run, Undo, Debug. C) Copy, Restore, Upgrade, Downgrade. D) Classify, Retrieve, Utilize, Discard. Show Answer Correct Answer: A) Create, Read, Update, Delete. 12. Record A) A collection of unrelated data points. B) A set of related fields in a database about a person or thing. C) A type of database management system. D) A method for storing data in a spreadsheet. Show Answer Correct Answer: B) A set of related fields in a database about a person or thing. 13. What is a tablespace in an RDBMS? A) A caching layer for temporary queries. B) A virtual partition of operating system memory. C) Logical structure that maps objects to physical files. D) None of the above. Show Answer Correct Answer: C) Logical structure that maps objects to physical files. 14. Which schema level describes how data is stored, including file organizations and indexes? A) External schema. B) Conceptual schema. C) Internal schema. D) View schema. Show Answer Correct Answer: C) Internal schema. 15. In a relational database, what is a foreign key? A) A key that refers to the primary key in another table. B) A key that is automatically generated. C) A key that is unique to each table. D) A key that is used for indexing. Show Answer Correct Answer: A) A key that refers to the primary key in another table. 16. How can you retrieve unique values from a column? A) Use the DISTINCT keyword. B) Use the GROUP BY clause. C) Use the UNIQUE function. D) Use the SELECT ALL statement. Show Answer Correct Answer: A) Use the DISTINCT keyword. 17. The database schema is written in A) SQL. B) DML. C) DDL. D) DCL. Show Answer Correct Answer: C) DDL. 18. During which SDLC phase is the conceptual model designed? A) Design. B) Analysis. C) Planning. D) None of the above. Show Answer Correct Answer: B) Analysis. 19. Which SQL keyword is used to remove existing records from a table? A) DELETE. B) INSERT. C) VIEW. D) ADD. Show Answer Correct Answer: A) DELETE. 20. Perintah pada MySQL selalu diakhiri dengan tanda ..... A) ). B) );. C) ,. D) ;. E) ". Show Answer Correct Answer: D) ;. 21. What is the purpose of an Entity Relationship Diagram (ERD)? A) To write SQL queries. B) To display entities and their relationships. C) To manage databases. D) None of the above. Show Answer Correct Answer: B) To display entities and their relationships. 22. Why are databases important in healthcare? A) They store patient records. B) They diagnose diseases. C) They perform surgeries. D) They manufacture medicines. Show Answer Correct Answer: A) They store patient records. 23. Section A:True or False (5 marks)-Write True or False beside each statement. A field refers to a complete set of data about one person or item. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 24. What does normalization help to achieve? A) Data duplication. B) Unstructured storage. C) Reduced redundancy and improved integrity. D) File compression. Show Answer Correct Answer: C) Reduced redundancy and improved integrity. 25. Which of the following is a valid SQL type? A) CHARACTER. B) NUMERIC. C) FLOAT. D) All of the above. Show Answer Correct Answer: D) All of the above. ← 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