Intermediate SQL
Q68 / 100

What is the purpose of "GENERATED ALWAYS AS IDENTITY" (or AUTO_INCREMENT in MySQL)?

Correct! Well done.

Incorrect.

The correct answer is A) To automatically generate a unique, sequential value for a column, commonly used for primary keys

A

Correct Answer

To automatically generate a unique, sequential value for a column, commonly used for primary keys

Explanation

Identity/auto-increment columns automatically assign an incrementing numeric value on each insert, commonly used to generate surrogate primary keys.

Progress
68/100