This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 40 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 40 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Explain the significance of database indexing in improving query performance. A) Indexes are used to store data in a database. B) Indexes help in improving the performance of database queries by allowing the database to quickly locate specific rows in a table. C) Indexes are only used for data deletion in a database. D) Indexes have no impact on database performance. Show Answer Correct Answer: B) Indexes help in improving the performance of database queries by allowing the database to quickly locate specific rows in a table. 2. Which level hides hardware details from the user? A) Physical. B) Conceptual. C) External. D) System. Show Answer Correct Answer: B) Conceptual. 3. A schematic of the entire database that describes the relationships in a database is called a(n) ..... A) Data dictionary. B) Intersection relationship diagram. C) Entity-relationship diagram. D) Data definition diagram. Show Answer Correct Answer: C) Entity-relationship diagram. 4. What is the purpose of a primary key in a table? A) To allow null values. B) To uniquely identify records. C) To store foreign keys. D) None of the above. Show Answer Correct Answer: B) To uniquely identify records. 5. Perintah yang memudahkan admin dalam memberikan hak akses adalah ..... A) ALTER. B) DELETE. C) REVOKE. D) GRANT. E) SELECT. Show Answer Correct Answer: D) GRANT. 6. The output relation which has sum of column and product of rows is called ..... A) Cartesian product. B) Selection Operation. C) Project Operation. D) Union operation. Show Answer Correct Answer: A) Cartesian product. 7. Which data type can store a calculated value based on other fields in the table? A) Lookup. B) Calculated. C) OLE Object. D) Attachment. Show Answer Correct Answer: B) Calculated. 8. What is the function of a form in database management? A) To store data in a structured format. B) To perform complex calculations on data. C) To generate reports automatically. D) To provide a user-friendly interface for data entry and management. Show Answer Correct Answer: D) To provide a user-friendly interface for data entry and management. 9. Which of the following is NOT a type of database user? A) Database Administrator. B) Database Designer. C) End-user. D) Hardware Engineer. Show Answer Correct Answer: D) Hardware Engineer. 10. Why is a DBMS necessary for managing data? A) A DBMS complicates data access and reduces efficiency. B) A DBMS is unnecessary for small-scale data management. C) A DBMS is only useful for large organizations with massive data. D) A DBMS is essential for efficient data management, ensuring integrity, security, and concurrent access. Show Answer Correct Answer: D) A DBMS is essential for efficient data management, ensuring integrity, security, and concurrent access. 11. How do markup languages like HTML differ from programming languages? A) Markup languages are used for formatting and linking text, not for programming instructions. B) Markup languages require a compiler to run. C) Markup languages are low-level languages like assembly code. D) Markup languages cannot be used for creating web pages. Show Answer Correct Answer: A) Markup languages are used for formatting and linking text, not for programming instructions. 12. Indicate whether the statement is true or false:Encryption is a key feature of a blockchain database. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 13. At which level of data abstraction is the database schema defined? A) Physical level. B) Logical level. C) External level. D) Conceptual level. Show Answer Correct Answer: D) Conceptual level. 14. SQL statements can be classified into A) Data definition language(DDL). B) Data manipulation language(DML). C) Transaction control language(TCL). D) All of these. Show Answer Correct Answer: D) All of these. 15. In the context of databases, what does the term 'concurrency control' refer to? A) Controlling user access to the database. B) Backing up data regularly. C) Ensuring that multiple transactions can occur without conflict. D) Managing multiple database connections. Show Answer Correct Answer: C) Ensuring that multiple transactions can occur without conflict. 16. Another name for a production database is a ..... database. A) Development. B) Warehousing. C) Transactional. D) Data-mining. Show Answer Correct Answer: C) Transactional. 17. Which type of end user makes up the largest category and uses predefined transactions? A) Naive or Parametric End Users. B) Casual End Users. C) Sophisticated End Users. D) Stand-alone Users. Show Answer Correct Answer: A) Naive or Parametric End Users. 18. What is the primary key for the world table? A) Name. B) Area. C) Population. D) Continent. Show Answer Correct Answer: A) Name. 19. The SQL statementSELECT SUBSTR('123456789', INSTR('abcabcabc', 'b'), 4) FROM DUAL; A) 6789. B) 2345. C) 1234. D) 456789. Show Answer Correct Answer: B) 2345. 20. Which of the following SQL queries is used to retrieve rows from the "customers" table where the "email" column contains NULL values? A) SELECT * FROM customers WHERE email = NULL;. B) SELECT * FROM customers WHERE email IS NOT NULL;. C) SELECT * FROM customers WHERE ISNULL(email);. D) SELECT * FROM customers WHERE email IS NULL. Show Answer Correct Answer: D) SELECT * FROM customers WHERE email IS NULL. 21. Which of the following is NOT a foreign key in a database? A) Student ID number. B) Product category. C) Order date. D) Customer name. Show Answer Correct Answer: B) Product category. 22. Which of the following is an RDBMS? A) Dbase. B) FoxPro. C) Microsoft Access. D) SQLite. Show Answer Correct Answer: D) SQLite. 23. Which of the following is NOT an expectation we have for a database management system, whether it is relational or not A) More complicated handling of requests for information. B) Backup and recovery. C) Efficient storage handling. D) Concurrency. Show Answer Correct Answer: B) Backup and recovery. 24. What is the main advantage of a distributed database? A) Easier to manage. B) Lower costs. C) Faster access times. D) Redundancy and reliability. Show Answer Correct Answer: D) Redundancy and reliability. 25. What is a transposition error? A) When data is omitted or excluded. B) When two characters are accidentally swapped. C) When data is lost or damaged. D) When data is encrypted incorrectly. Show Answer Correct Answer: B) When two characters are accidentally swapped. ← 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