Bright Tutorials Bright Tutorials
CBSE Class 12 Informatics Practices Question 2 of 103

Review of Database Concepts & SQL — Question 2

Back to all questions
2
Question

Question 2

Assertion (A): A database consists of multiple tables.

Reasoning (R): A foreign key is used to represent the relationship between two tables.

  1. Both A and R are true and R is the correct explanation of A.
  2. Both A and R are true but R is not the correct explanation of A.
  3. A is true but R is false.
  4. A is false but R is true.
Answer

Both A and R are true and R is the correct explanation of A.

Explanation
In a database system, data is organized into multiple tables for better organization, management, and query efficiency. A foreign key is a non-key attribute whose value is derived from the primary key of another table in a database. It references the primary key in another table, thereby establishing a relationship between the two tables.