Chapter 11: Database Concepts — Online MCQ Test
COMPUTER SCIENCE · CLASS 12th · Tamil Nadu State Board
Practice Chapter 11: Database Concepts with a free chapter-wise online MCQ test.
This chapter covers: This foundational chapter explores database management systems and relational database concepts. It covers data models keys table relations components of database architecture and....
AI-generated questions from basic to board-exam level, with instant results and explanations.
Chapter 11: Database Concepts — Important Questions & Answers
What is the main purpose of a Database Management System (DBMS)?
- A. To design computer hardware
- B. To store, manage, and retrieve data efficiently
- C. To create only presentation slides
- D. To format text documents
Answer: B. To store, manage, and retrieve data efficiently
A DBMS is software used to organize and manage data so that it can be accessed and updated efficiently.
A DBMS is software used to organize and manage data so that it can be accessed and updated efficiently.
Which of the following is an example of a relational database object used to store data in rows and columns?
- A. Table
- B. Folder
- C. Window
- D. Icon
Answer: A. Table
In the relational model, data is stored in tables made up of rows and columns.
In the relational model, data is stored in tables made up of rows and columns.
In a relational database, a foreign key is used to:
- A. Uniquely identify records in the same table
- B. Link one table to another table
- C. Store only text data
- D. Delete duplicate rows automatically
Answer: B. Link one table to another table
A foreign key establishes a relationship between two tables by referring to the primary key of another table.
A foreign key establishes a relationship between two tables by referring to the primary key of another table.
A school stores student marks in separate files for each subject. The same student details are repeated in every file. Which DBMS feature can best solve this problem?
- A. Data encryption
- B. Data redundancy reduction
- C. Data output formatting
- D. Data compression only
Answer: B. Data redundancy reduction
A DBMS reduces repeated storage of the same data by organizing it properly in related tables.
A DBMS reduces repeated storage of the same data by organizing it properly in related tables.
Which option correctly matches the relationship between two tables where one department can have many students, but each student belongs to only one department?
- A. Many-to-many
- B. One-to-one
- C. One-to-many
- D. Many-to-one only
Answer: C. One-to-many
One department can relate to many students, so the relationship is one-to-many.
One department can relate to many students, so the relationship is one-to-many.