This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 63 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 63 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What does the term "cardinality" refer to in an ERD? A) The number of attributes in an entity. B) The number of entities in a database. C) The number of relationships between entities. D) The numerical relationship between two entities. Show Answer Correct Answer: D) The numerical relationship between two entities. 2. Which of the following is NOT a candidate key in a database? A) Customer name. B) Student ID number. C) Product category. D) Order date. Show Answer Correct Answer: D) Order date. 3. ADVANTAGE OF DATABASE A) Repetition. B) Inconsistancy. C) Poor integaration. D) Data availability. Show Answer Correct Answer: D) Data availability. 4. Which of the following is an automated or manual file that stores information about data elements and data characteristics such as usage, physical representation, ownership, authorization, and security? A) Data dictionary. B) Data definition diagram. C) Entity-relationship diagram. D) Relationship dictionary. Show Answer Correct Answer: A) Data dictionary. 5. Which of the following is an example of a database used in a business? A) A list of customers and their orders. B) A storybook. C) A calculator. D) A video game. Show Answer Correct Answer: A) A list of customers and their orders. 6. One of the following is not a valid data type name for a field ..... A) Text or string. B) Number. C) Entity. D) Date. Show Answer Correct Answer: C) Entity. 7. The status of a relational database in which entities are in 1NF and any non-key attributes depend on the primary key. A) First normal form (1NF). B) Second normal form (2NF). C) Third normal form (3NF). D) Boyce-Codd normal form (BCNF). Show Answer Correct Answer: B) Second normal form (2NF). 8. What problem might arise if incorrect fields are inserted into a database? A) The database becomes more efficient. B) Reports may be inaccurate or misleading. C) Students can log in faster. D) The ASCII code won't work. Show Answer Correct Answer: B) Reports may be inaccurate or misleading. 9. What is data validation in a database? A) Ensuring data is accurate and meets certain criteria. B) Sorting data alphabetically. C) Deleting duplicate records. D) Storing images in a table. Show Answer Correct Answer: A) Ensuring data is accurate and meets certain criteria. 10. How do databases help businesses? A) By managing customer information. B) By creating advertisements. C) By designing products. D) By hiring employees. Show Answer Correct Answer: A) By managing customer information. 11. Which of the following is an example of a SQL extension? A) JSON. B) PL-SQL. C) HTML. D) XML. Show Answer Correct Answer: B) PL-SQL. 12. What is an example of a record in a database? A) Information about a unique employee. B) A song playlist. C) A movie script. D) A painting description. Show Answer Correct Answer: A) Information about a unique employee. 13. DBMS EXTRACT DATA FROM A) DATA. B) META DATA. C) DATABASE. D) INFORMATION. Show Answer Correct Answer: C) DATABASE. 14. What does ETL stand for in data integration? A) Extract, Transform, Load. B) Encode, Translate, Load. C) Evaluate, Transmit, G. D) None of the above. Show Answer Correct Answer: A) Extract, Transform, Load. 15. Facilitates oversight and control of databases, enabling a variety of administrative operations such as performance monitoring, tuning, and backup and recovery. A) MySQL. B) NoSQL. C) RDMS. D) DBMS. Show Answer Correct Answer: D) DBMS. 16. Which database language is used for defining data structures? A) DCL. B) DDL. C) DML. D) TCL. Show Answer Correct Answer: B) DDL. 17. A ..... is a question asked from a database. A) Query. B) Report. C) Form. D) Field. Show Answer Correct Answer: A) Query. 18. What does the term "data redundancy" refer to? A) Storing data in multiple formats. B) Duplicating data unnecessarily within a database. C) Processing data to create information. D) The inability to retrieve data when needed. Show Answer Correct Answer: B) Duplicating data unnecessarily within a database. 19. Why is a database important in organizing information? A) It keeps information structured and easy to find. B) It removes all duplicate data automatically. C) It only stores numerical data. D) It is only useful for large organizations. Show Answer Correct Answer: A) It keeps information structured and easy to find. 20. Which term refers to a unique identifier for each record in a table that is composed of more than one field? A) Primary key. B) Composite key. C) Foreign key. D) Secondary key. Show Answer Correct Answer: B) Composite key. 21. What is a composite key in a database? A) A key made up of multiple attributes. B) A key used for encryption. C) A key that uniquely identifies each record. D) None of the above. Show Answer Correct Answer: A) A key made up of multiple attributes. 22. Neha wishes to rename a table in her database. What should she do? A) Press F5. B) Right-click table name and select Rename. C) Use Save As. D) Edit field name in Datasheet. Show Answer Correct Answer: B) Right-click table name and select Rename. 23. Which of the following is an example of domain integrity being enforced? A) A student's ID is unique. B) A grade must be between 1 and 7. C) A teacher record is deleted when a course is removed. D) A database is restored from backup. Show Answer Correct Answer: B) A grade must be between 1 and 7. 24. What does a conceptual data model NOT include? A) Primary keys. B) Business ideas and rules. C) Entities and their attributes. D) Relationships between entities. Show Answer Correct Answer: A) Primary keys. 25. What is the purpose of Advanced Filter Sort? A) To create new databases. B) To modify form layouts. C) To perform complex filtering and sorting operations. D) To print reports only. Show Answer Correct Answer: C) To perform complex filtering and sorting operations. ← 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