Question

In SQL, a relation consists of 5 columns and 6 rows. If 2 columns and 3 rows are added to the existing relation, what will be the updated degree of a relation?

Options

• Degree: 7

• Degree: 8

• Degree: 9

• Degree: 6

Answer 1

Degree: 7

Explanation:

In SQL, the degree of a relation = number of columns (attributes).

Originally, there are 5 columns.

After adding 2 more columns, the total becomes 5 + 2 = 7.

Adding rows affects cardinality, not degree.