This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 79 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 79 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Explain how to update a view in SQL. A) Use 'ALTER VIEW view name AS SELECT ;' to modify a view. B) Use 'DROP VIEW view name;' followed by 'CREATE VIEW view name AS SELECT ;' to update a view. C) Run 'REPLACE VIEW view name AS SELECT ;' to refresh the view. D) Execute 'UPDATE view name SET ;' to change the view definition. Show Answer Correct Answer: B) Use 'DROP VIEW view name;' followed by 'CREATE VIEW view name AS SELECT ;' to update a view. 2. Which concurrency control method completely avoids deadlock? A) Locking. B) Timestamp ordering. C) Two-phase locking. D) None. Show Answer Correct Answer: B) Timestamp ordering. 3. What is the main purpose of forms in a database? A) To delete records. B) To serve as a user-friendly interface for data entry. C) To encrypt data. D) To create new tables. Show Answer Correct Answer: B) To serve as a user-friendly interface for data entry. 4. COLLECTION OF DATA A) DBMS. B) SQL. C) DATABASE. D) INFORMATION. Show Answer Correct Answer: C) DATABASE. 5. The property (or set of properties) that uniquely defines each row in a table is called the: A) Identifier. B) Index. C) Primary key. D) Symmetric key. Show Answer Correct Answer: C) Primary key. 6. Which of the following is not a true statement about performing a data quality audit? A) A data quality audit can be performed by surveying entire data files. B) A data quality audit can be performed by surveying samples from data files. C) A data quality audit can be performed by surveying data definition and query files. D) A data quality audit can be performed by surveying end users about their perceptions of data quality. Show Answer Correct Answer: D) A data quality audit can be performed by surveying end users about their perceptions of data quality. 7. Number A) Numeric data stored as an integer or decimal which calculations can be performed on. For example: "200", "49.534" . B) A character or symbol used to represent a quantity. C) A type of variable that can only hold text values. D) A graphical representation of data points. Show Answer Correct Answer: A) Numeric data stored as an integer or decimal which calculations can be performed on. For example: "200", "49.534" . 8. Which level of data abstraction describes how data is actually stored in memory? A) Conceptual or Logical. B) External or View. C) Data Independence. D) Internal or Physical. Show Answer Correct Answer: D) Internal or Physical. 9. Which command is used to delete a table permanently? A) TRUNCATE. B) DELETE. C) DROP. D) REMOVE. Show Answer Correct Answer: C) DROP. 10. What type of database is designed to facilitate the exchange of structured documents? A) NoSQL. B) XML. C) Object-Oriented. D) NewSQL. Show Answer Correct Answer: B) XML. 11. A business wants to track whether or not an invoice has been paid. Which data type is the most efficient choice to minimize storage while providing a clear status? A) Currency. B) Integer. C) Boolean (Yes/No). D) Alphanumeric. Show Answer Correct Answer: C) Boolean (Yes/No). 12. Which of the following is a characteristic of a database system? A) Manual record-keeping. B) Unstructured storage. C) Data redundancy. D) Efficient data management. Show Answer Correct Answer: D) Efficient data management. 13. Entities of a given type are grouped into a(n): A) Database. B) Entity class. C) Attribute. D) ERD. Show Answer Correct Answer: B) Entity class. 14. Which of the following best describes the responsibility of the conceptual level in a DBMS? A) Managing how data is physically stored. B) Providing user-specific views of the data. C) Defining all entities, attributes, and relationships in the database. D) Handling backup and recovery mechanisms. Show Answer Correct Answer: C) Defining all entities, attributes, and relationships in the database. 15. What is the purpose of a DBMS in a business setting? A) To better serve customers. B) To make better decisions. C) To improve business processes. D) All of the above. Show Answer Correct Answer: D) All of the above. 16. A table is synonymous with the term: A) Record. B) Relation. C) Column. D) Field. Show Answer Correct Answer: B) Relation. 17. If a query is created to show all students in 'Grade 10', what condition should be used? A) Criteria Age = 10. B) Criteria ClassName = Grade 10. C) Criteria ContactNumber IS NULL. D) Criteria Subject = 'Math'. Show Answer Correct Answer: B) Criteria ClassName = Grade 10. 18. What must be selected during the installation of SQL Server for distributed databases? A) SQL Server Replication. B) SQL Server Developer. C) SQL Server Management Studio. D) SQL Server Express. Show Answer Correct Answer: A) SQL Server Replication. 19. Which of the following is known as a set of entities of the same type that share same properties or attributes? A) Relation set. B) Tuples. C) Entity set. D) Entity Relation model. Show Answer Correct Answer: C) Entity set. 20. A relationship between Customer and Order entities with connectivity 1:M is classified as: A) Unary relationship. B) Binary relationship. C) Ternary relationship. D) Recursive relationship. Show Answer Correct Answer: B) Binary relationship. 21. Explain the concept of data mining in relation to databases. A) Data mining is solely focused on data entry and management. B) Data mining involves creating new databases from scratch. C) Data mining is the extraction of useful information and patterns from large datasets in databases. D) Data mining is the process of storing data in a database. Show Answer Correct Answer: C) Data mining is the extraction of useful information and patterns from large datasets in databases. 22. UPDATE A) An SQL command used to modify existing data. B) A command to delete records from a database. C) A command to retrieve data from a database. D) A command to create a new database table. Show Answer Correct Answer: A) An SQL command used to modify existing data. 23. Which concurrency control technique validates transactions before commit? A) Locking. B) Timestamp. C) Validation-based. D) None. Show Answer Correct Answer: C) Validation-based. 24. Juvante is working on a project where he needs to analyze sales data. Which step is involved in creating a query? A) Selecting a table to query data from. B) Adding a primary key to the table. C) Exporting the data to a spreadsheet. D) Formatting the database layout. Show Answer Correct Answer: A) Selecting a table to query data from. 25. Which SQL clause is used to specify the condition on aggregate functions, such as 'COUNT' or 'SUM'? A) WHERE. B) HAVING. C) ORDER BY. D) GROUP BY. Show Answer Correct Answer: B) HAVING. ← 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