This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 47 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 47 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. An instance of an entity, represented by a row in a table. A) Row. B) Tuple. C) Column. D) Field. Show Answer Correct Answer: B) Tuple. 2. What does the term "composite key" refer to in a database? A) A key that uniquely identifies each record. B) A key made up of multiple attributes. C) A key used for encryption. D) A key used to establish relationships between tables. Show Answer Correct Answer: B) A key made up of multiple attributes. 3. Which of these is a valid condition for filtering records in a query? A) Age > 18. B) Table = Name. C) Field 100. D) Database = Query. Show Answer Correct Answer: A) Age > 18. 4. What does scalability in a database mean? A) The ability to store physical items. B) The process of adding more physical hard drives for data storage. C) The ability to handle a large amount of data efficiently. D) The ability to access social media. Show Answer Correct Answer: C) The ability to handle a large amount of data efficiently. 5. What are the ACID properties in database transactions? A) Atomicity, Clarity, Isolation, Reliability. B) Atomicity, Consistency, Isolation, Accessibility. C) Accuracy, Clarity, Integrity, Timeliness. D) ACID properties:Atomicity, Consistency, Isolation, Durability. Show Answer Correct Answer: D) ACID properties:Atomicity, Consistency, Isolation, Durability. 6. A ..... is a feature of a database using which we can enter data in a table in an easy and user friendly manner. A) Query. B) Report. C) Form. D) Field. Show Answer Correct Answer: C) Form. 7. How do fields relate to records in a database? A) Fields are the same as records in a database. B) Records are collections of fields in a database. C) Fields are only used for indexing in a database. D) Fields are the attributes of a record in a database. Show Answer Correct Answer: D) Fields are the attributes of a record in a database. 8. What is the main goal of database administration? A) Managing and optimizing database systems to ensure data availability and performance. B) Hosting data-oriented applications. C) Designing database management systems to efficiently handle large datasets. D) None of the above. Show Answer Correct Answer: A) Managing and optimizing database systems to ensure data availability and performance. 9. Tuple is another name for A) Row. B) Records. C) Columns. D) Both B & C. Show Answer Correct Answer: B) Records. 10. Data mining allows users to ..... A) Quickly compare transaction data gathered over many years. B) Find hidden patterns and relationships in large databases. C) Obtain online answers to ad-hoc questions in a rapid amount of time. D) Summarize massive amounts of data into much smaller, traditional reports. Show Answer Correct Answer: B) Find hidden patterns and relationships in large databases. 11. What is the primary function of the DELETE statement in SQL? A) To retrieve data from a table. B) To update records in a table. C) To remove records from a table. D) To create a new table. Show Answer Correct Answer: C) To remove records from a table. 12. A one-to-many relationship between two entities is symbolized in a diagram by a line that ends with ..... A) A crow's foot topped by a short mark. B) Two short marks. C) Three short marks. D) A crow's foot. Show Answer Correct Answer: D) A crow's foot. 13. Which MS Access feature is used to extract specific information from a database? A) Report. B) Form. C) Query. D) Relationship. Show Answer Correct Answer: C) Query. 14. Which DBLC phase includes performance tuning? A) Implementation. B) Maintenance. C) Design. D) Evaluation. Show Answer Correct Answer: B) Maintenance. 15. Which level of abstraction describes how data is physically stored? A) External level. B) Logical level. C) Physical level. D) Conceptual level. Show Answer Correct Answer: C) Physical level. 16. A record is represented by what in a database? A) Table. B) Row. C) Column. D) Cell. Show Answer Correct Answer: B) Row. 17. Data can be in the form of numbers, letters, symbols and sounds. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 18. How can structured query language be used to manipulate data in databases? A) By using commands such as SEARCH, APPEND, MODIFY, and CLEAR to manipulate data. B) By using commands such as PRINT, ADD, CHANGE, and ERASE to manipulate data. C) By using commands such as SELECT, INSERT, UPDATE, and DELETE to retrieve, add, modify, and remove data from the database. D) By using commands such as COPY, PASTE, CUT, and RENAME to manipulate data. Show Answer Correct Answer: C) By using commands such as SELECT, INSERT, UPDATE, and DELETE to retrieve, add, modify, and remove data from the database. 19. Which of the following is NOT a primary responsibility of a Database Administrator? A) Database design and implementation. B) Performance management. C) Security administration. D) Writing application programs. Show Answer Correct Answer: D) Writing application programs. 20. Why would you create a primary key? A) To make each record in a database unique. B) To make each field in a database unique. C) To make each query in a database unique. D) None of the above. Show Answer Correct Answer: A) To make each record in a database unique. 21. What is the purpose of data abstraction in a database system? A) To display all data to the user. B) To improve hardware speed. C) To hide complex details of data storage from the user. D) To encrypt user passwords. Show Answer Correct Answer: C) To hide complex details of data storage from the user. 22. Which of the following describes a SQL "Join" ? A) A query that combines rows from two or more tables based on related columns. B) A key used to identify data in different tables. C) A rule that defines relationships between databases. D) A primary key in a relational database. Show Answer Correct Answer: A) A query that combines rows from two or more tables based on related columns. 23. What is a relational database a collection of? A) Tables. B) Fields. C) Records. D) Keys. Show Answer Correct Answer: A) Tables. 24. What is the best definition for table A) Single type of data within the table. B) The core structure in a relational database. C) Represent a single, specific record in the table. D) None of the above. Show Answer Correct Answer: B) The core structure in a relational database. 25. What is the 'Not Null' constraint used for? A) To enforce unique values. B) To ensure a field always has a value. C) To allow duplicate values. D) None of the above. Show Answer Correct Answer: B) To ensure a field always has a value. ← 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