This quiz works best with JavaScript enabled. Home > Class 11 > Class 11 Computer Science Chapter 7 Database Concepts – Quiz 27 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 11 Computer Science Chapter 7 Database Concepts Quiz 27 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What is the functional purpose of a 'Foreign Key' within a relational database table? A) To ensure that every record within that specific table is unique. B) To act as a placeholder for media files like images and videos. C) To point to a primary key in another table to form a relationship. D) To prevent the database from being accessed by unauthorized users. Show Answer Correct Answer: C) To point to a primary key in another table to form a relationship. 2. What is the purpose of Design View in MS Access? A) To create tables. B) To enter data into fields. C) To delete records. D) To print reports. Show Answer Correct Answer: A) To create tables. 3. In an ER diagram, a *mandatory* relationship means: A) The foreign key must be NULL. B) The foreign key can be either NULL or NOT NULL. C) The foreign key cannot be NULL. D) There is no foreign key involved. Show Answer Correct Answer: C) The foreign key cannot be NULL. 4. What is the purpose of indexes in a database? A) To store data in a single file. B) To improve the speed of data retrieval operations. C) To ensure data integrity. D) To create relationships between tables. Show Answer Correct Answer: B) To improve the speed of data retrieval operations. 5. Which type of key is used to uniquely identify a record in a database table? A) Foreign Key. B) Composite Key. C) Primary Key. D) Candidate Key. Show Answer Correct Answer: C) Primary Key. 6. The process of organizing data to be stored in a database into two or more tables and establishing relationships between the tables, so that data redundancy is minimized. A) Normalization (database). B) Denormalization. C) Data Warehousing. D) Data Mining. Show Answer Correct Answer: A) Normalization (database). 7. Which of the following is NOT true of relational database management systems A) Tables are organized into columns. B) One or more columns uniquely identify a row within the table. C) Stores data in flat files. D) An index provides a quick way to look up data. Show Answer Correct Answer: C) Stores data in flat files. 8. What command would you use to delete a database in MySQL? A) CLEAR DATABASE database name;. B) REMOVE DATABASE database name;. C) DROP DATABASE database name;. D) DELETE DATABASE database name;. Show Answer Correct Answer: C) DROP DATABASE database name;. 9. Can a table have more than one foreign key? A) Yes, a table can have multiple foreign keys. B) No, a table can only have one foreign key. C) No, a table cannot have any foreign keys. D) Yes, but only if it does not have a primary key. Show Answer Correct Answer: A) Yes, a table can have multiple foreign keys. 10. Which of the following is an example of an entity? A) Idea. B) Animal. C) Object. D) Person. Show Answer Correct Answer: D) Person. 11. Business rules mainly define ..... A) Hardware requirements. B) Network protocols. C) Data relationships and constraints. D) File formats. Show Answer Correct Answer: C) Data relationships and constraints. 12. Which type of database user interacts with the external level? A) End-user. B) Database Administrator. C) Data Analyst. D) Application Developer. Show Answer Correct Answer: A) End-user. 13. Each entity is described by ..... A) Entity. B) Relationship. C) None of these. D) Attribute. Show Answer Correct Answer: D) Attribute. 14. Normalization ..... data duplication A) Eliminates. B) Reduces. C) Increases. D) Maximizes. Show Answer Correct Answer: A) Eliminates. 15. What is the purpose of relationships in a database? A) To eliminate the need for data normalization. B) To store data in a single table only. C) To create visual representations of data without structure. D) The purpose of relationships in a database is to connect and organize data across different tables, ensuring data integrity and facilitating efficient data retrieval. Show Answer Correct Answer: D) The purpose of relationships in a database is to connect and organize data across different tables, ensuring data integrity and facilitating efficient data retrieval. 16. Which data type can store unstructured data in a column? A) RAW. B) CHAR. C) NUMERIC. D) VARCHAR. Show Answer Correct Answer: A) RAW. 17. A functional dependency is a relationship between: A) Tables. B) Rows. C) Relations. D) Attributes. Show Answer Correct Answer: D) Attributes. 18. What is a foreign key used for in a database? A) To store unique values. B) To enforce referential integrity. C) To create a new table. D) To delete records. Show Answer Correct Answer: B) To enforce referential integrity. 19. What is the difference between a field and a column? A) A field is a horizontal set of data; a column is a vertical set of data. B) A field is a type of database; a column is a type of table. C) A field is a single data attribute; a column is a vertical set of fields in a table. D) A field is a collection of columns; a column is a single data attribute. Show Answer Correct Answer: C) A field is a single data attribute; a column is a vertical set of fields in a table. 20. What is the isolation property in transactions? A) All transactions must be the same. B) Transactions cannot be changed. C) Each transaction appears to execute alone. D) Transactions are executed together. Show Answer Correct Answer: C) Each transaction appears to execute alone. 21. How can a Database Administrator (DBA) ensure the security of student data using a DBMS? A) By using access rights to manage user actions. B) By storing data in unsecured locations. C) By implementing regular back-ups. D) By allowing unrestricted access to all users. Show Answer Correct Answer: A) By using access rights to manage user actions. 22. Which of the following is a characteristic of data? A) Data is always qualitative. B) Data must be collected in real-time. C) Data is always processed. D) Data is irrelevant. Show Answer Correct Answer: B) Data must be collected in real-time. 23. Which of the following is NOT a data type in a database? A) Text. B) Auto number. C) Memo. D) Algorithm. Show Answer Correct Answer: D) Algorithm. 24. Explain the role of a primary key in a database. A) The role of a primary key in a database is to uniquely identify each record and maintain data integrity. B) A primary key is optional and can be left blank in a database. C) A primary key allows duplicate records in a database. D) The primary key is used to store large amounts of data. Show Answer Correct Answer: A) The role of a primary key in a database is to uniquely identify each record and maintain data integrity. 25. Indicate whether the statement is true or false:In a database, a bit represents a single character, which can be a letter, a number, or another symbol. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. ← 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