This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 48 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 48 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Which database approach characteristic allows the same DBMS software to work with any database? A) Multiple views. B) Data sharing. C) Program-data independence. D) Self-describing nature. Show Answer Correct Answer: D) Self-describing nature. 2. What is an example of a database management system? A) Microsoft Word. B) MySQL. C) Adobe Photoshop. D) Windows OS. Show Answer Correct Answer: B) MySQL. 3. Indicate whether the statement is true or false:The term data governance encompasses policies and procedures through which data can be managed as an organizational resource. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 4. What SQL command is used to create a new table? A) INSERT TABLE. B) MODIFY TABLE. C) ADD TABLE. D) CREATE TABLE. Show Answer Correct Answer: D) CREATE TABLE. 5. What is the difference between the "Execute Statement" and "Execute Script" icons in SQL Developer? A) Execute Statement runs multiple lines; Execute Script only one. B) Execute Script runs all statements or highlighted ones; Execute Statement runs the line with the cursor. C) Both are used to run scripts with the same functionality. D) Only Execute Script can run anonymous blocks. Show Answer Correct Answer: B) Execute Script runs all statements or highlighted ones; Execute Statement runs the line with the cursor. 6. What is a candidate key in a database? A) A key that is used to encrypt data. B) A field that can be used as a primary key. C) A key that is used to link two tables. D) A field that contains a foreign key. Show Answer Correct Answer: B) A field that can be used as a primary key. 7. Which DML command is used to add new records to a table? A) UPDATE. B) SELECT. C) INSERT. D) DELETE. Show Answer Correct Answer: C) INSERT. 8. In a table there can be many candidate keys. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 9. Which of the following is NOT one of the ACID properties? A) Atomicity. B) Durability. C) Simplicity. D) Isolation. Show Answer Correct Answer: C) Simplicity. 10. Which tool would you use to find all records where the value is greater than 100? A) Sort tool. B) Form Wizard. C) Query criteria using > 100. D) Advanced Filter Sort. Show Answer Correct Answer: C) Query criteria using > 100. 11. Why are databases better for concurrent use compared to spreadsheets? A) Spreadsheets are only for single users. B) Spreadsheets cannot store words. C) Databases are cheaper. D) Databases allow many users to access data simultaneously. Show Answer Correct Answer: D) Databases allow many users to access data simultaneously. 12. What is the purpose of a transaction in a database? A) To create new data. B) To read and write data. C) To store data. D) To delete data. Show Answer Correct Answer: B) To read and write data. 13. What is an aggregate function in a query? A) A function that performs calculations on a group of values. B) A function that deletes duplicate records. C) A function that creates new tables. D) A function that sorts data automatically. Show Answer Correct Answer: A) A function that performs calculations on a group of values. 14. What is the cardinality of a relationship? A) The minimum number of relationships. B) The maximum number of relationships. C) The degree of the relationship. D) None of the above. Show Answer Correct Answer: B) The maximum number of relationships. 15. Data Types A) Alphanumeric, numeric, currency, date/time & Boolean. B) Strings, integers, floats, and arrays. C) Images, videos, audio files, and documents. D) Text, binary, hexadecimal, and octal. Show Answer Correct Answer: A) Alphanumeric, numeric, currency, date/time & Boolean. 16. Which of the following is part of a three-level database architecture? A) Logical Level. B) Physical Level. C) View Level. D) All of the above. Show Answer Correct Answer: D) All of the above. 17. What is the main challenge of data volume in database management? A) Databases must scale appropriately as data grows. B) Data can be ignored if it is too large. C) Data must be stored in a single location. D) Data quality is always guaranteed. Show Answer Correct Answer: A) Databases must scale appropriately as data grows. 18. Third normal form is based on the concept of ..... A) Closure Dependency. B) Transitive Dependency. C) Normal Dependency. D) Functional Dependency. Show Answer Correct Answer: B) Transitive Dependency. 19. Which of the following best describes the concept of 'atomicity' in ACID properties? A) Data remains consistent. B) Transactions can interfere with each other. C) Transactions are all-or-nothing. D) Data is stored permanently. Show Answer Correct Answer: C) Transactions are all-or-nothing. 20. What are some common techniques for optimizing SQL queries? A) Common techniques for optimizing SQL queries include using indexes, avoiding SELECT *, limiting rows with WHERE clauses, efficient JOINs, analyzing execution plans, and denormalization. B) Ignoring execution plans completely. C) Always using subqueries for better performance. D) Using only SELECT * for simplicity. Show Answer Correct Answer: A) Common techniques for optimizing SQL queries include using indexes, avoiding SELECT *, limiting rows with WHERE clauses, efficient JOINs, analyzing execution plans, and denormalization. 21. ..... model represents the data in many to-many relationships. A) Hierarchical. B) Relational. C) Network. D) Object. Show Answer Correct Answer: C) Network. 22. A ..... application can be used to organize data but lacks the robust functions of a true database management system. A) Spreadsheet. B) Word processor. C) Presentation. D) Email client. Show Answer Correct Answer: A) Spreadsheet. 23. Section D:Fill in the Blanks (5 marks)-Write the correct word or term in each blank space. Each column in a table is known as a ..... A) Field. B) Record. C) File. D) Database. Show Answer Correct Answer: A) Field. 24. Which of the following products is an early implementation of the relational model developed by E.F. Codd of IBM? A) IDMS. B) DB2. C) DBase-II. D) R:base. Show Answer Correct Answer: B) DB2. 25. In a Students table, the row:(101, 'Alice', 'Computer Science') is an example of: A) Domain. B) Attribute. C) Tuple. D) Schema. Show Answer Correct Answer: C) Tuple. ← 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