Assertion (A): A database is the largest component for holding and storing data and may contain several tables.

Reasoning (R): Each table comprises multiple rows and records.

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.

Assertion (A): Referential integrity is a constraint that defines rules of holding data in parent and child table.

Reasoning (R): Referential integrity ensures that users don't accidently delete or change related data.

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.

Assertion (A): A foreign key is an attribute whose value is derived from the primary key of another relation.

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

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.

Assertion (A): Order by clause is used to sort the records of a table in ascending or descending order.

Reasoning (R): For sorting in ascending or descending order, ASC and DESC keywords are used along with the Order by clause.

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.