This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 80 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 80 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. In ..... database, data is organized in the form of trees with nodes. A) Hierarchical. B) Relational. C) Network. D) None of the above. Show Answer Correct Answer: A) Hierarchical. 2. Which operation in relational algebra selects tuples that satisfy a given condition? A) Project Operation. B) Select Operation. C) Join Operation. D) Union Operation. Show Answer Correct Answer: B) Select Operation. 3. True or False:An "instance" of a relational database is not a specific entity represented in the database? A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 4. Which of the following is an example of a primary key in a database? A) A customer's name. B) A product's name. C) A student's last name. D) An order's date. Show Answer Correct Answer: B) A product's name. 5. What are the different types of fields in a database? A) Integer. B) Float. C) Character. D) Text, number, date/time, boolean, binary. Show Answer Correct Answer: D) Text, number, date/time, boolean, binary. 6. What is the main purpose of a form in MS Access? A) To allow users to enter and view data easily. B) To filter data from multiple tables. C) To run complex calculations. D) To store data permanently. Show Answer Correct Answer: A) To allow users to enter and view data easily. 7. What does the 'Yes/No' data type represent? A) Date and time data. B) Text data. C) Boolean data. D) Numeric data. Show Answer Correct Answer: C) Boolean data. 8. What does a 'hyperlink' data type allow you to do in a database? A) Perform calculations. B) Store long texts. C) Add a link to a website. D) Store numbers used in reports. Show Answer Correct Answer: C) Add a link to a website. 9. How can you ensure data integrity in a database? A) By allowing unrestricted access to the database. B) By implementing measures such as primary keys, foreign keys, constraints, backups, data validation checks, access controls, and transaction management. C) By storing data in multiple databases. D) By regularly updating the database software. Show Answer Correct Answer: B) By implementing measures such as primary keys, foreign keys, constraints, backups, data validation checks, access controls, and transaction management. 10. What are fields in a database commonly referred to as? A) Records. B) Attributes. C) Entities. D) Rows. Show Answer Correct Answer: B) Attributes. 11. What is a foreign key in a database table? A) A field used to uniquely identify any record. B) A complete set of related records. C) A set of related fields. D) A single type of data. Show Answer Correct Answer: B) A complete set of related records. 12. An example of DBMS software is ..... A) MySQL. B) Oracle. C) MongoDB. D) PostgreSQL. Show Answer Correct Answer: A) MySQL. 13. Which of these statements about databases is true? A) A database only stores numbers. B) A field contains multiple rows of information. C) A record represents all data about one item. D) ASCII is not used in databases. Show Answer Correct Answer: C) A record represents all data about one item. 14. Which of the following property states that an incomplete transaction is not recorded? A) Consistency. B) Durability. C) Atomicity. D) Isolation. Show Answer Correct Answer: C) Atomicity. 15. Which of the following is an example of a composite key? A) A single field that uniquely identifies a record. B) A combination of two or more fields that uniquely identify a record. C) A field that contains a foreign key. D) A field that stores a large text value. Show Answer Correct Answer: B) A combination of two or more fields that uniquely identify a record. 16. In the ANSI-SPARC model, which level is responsible for specifying how data is stored in blocks, indexes, and file structures? A) External level. B) Conceptual level. C) Internal level. D) Logical level. Show Answer Correct Answer: C) Internal level. 17. Which of the following SQL statements retrieves all records from a table named Students? A) SELECT * IN Students. B) VIEW ALL FROM Students. C) SELECT * FROM Students. D) GET ALL Students. Show Answer Correct Answer: C) SELECT * FROM Students. 18. A developer is granted EXECUTE permission on a stored procedure named sp ..... UpdateUserEmail. This is the only way the developer can change user emails. What is the primary database concept this demonstrates? A) Encapsulation and Security. B) Performance Optimization. C) Transaction Isolation. D) Data Durability. Show Answer Correct Answer: A) Encapsulation and Security. 19. The details associated with an entity are called ..... A) Table. B) Attributes. C) Records. D) Primary key. Show Answer Correct Answer: B) Attributes. 20. Which SQL command grants user permissions? A) COMMIT. B) GRANT. C) REVOKE. D) CREATE. Show Answer Correct Answer: B) GRANT. 21. What is the purpose of concurrency control software? A) To allow multiple users to access data. B) To delete data. C) To create new databases. D) To store data securely. Show Answer Correct Answer: A) To allow multiple users to access data. 22. Who is responsible for authorizing access to the database? A) End users. B) System analysts. C) Database administrators. D) Application programmers. Show Answer Correct Answer: C) Database administrators. 23. Which PL/SQL object automatically executes when an event occurs? A) Function. B) Procedure. C) Trigger. D) Cursor. Show Answer Correct Answer: C) Trigger. 24. Which type of JOIN returns only rows that have matching values in both tables? A) LEFT JOIN. B) RIGHT JOIN. C) FULL OUTER JOIN. D) INNER JOIN. Show Answer Correct Answer: D) INNER JOIN. 25. What is the purpose of setting a primary key in an MS Access table? A) To ensure no duplicate records exist. B) To increase the speed of queries. C) To allow multiple users to access data. D) To provide additional security. Show Answer Correct Answer: A) To ensure no duplicate records exist. ← 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