Question

Which SQL command can change the cardinality of an existing relation?

Options

• Insert

• Delete

• Both Insert & Delete

• Drop

Answer 1

Both Insert & Delete

Explanation:

Cardinality means the number of rows in a table.

• INSERT adds new rows → increases cardinality.
• DELETE removes rows → decreases cardinality.

Hence, both INSERT and DELETE change the table’s cardinality.