Q. Which of the following is the feature(s) of SQL Auto Increment?
✅ Correct Answer: (D)
All of the above
Explanation: Features of SQL Auto Increment are:
In some cases you may not have any unique identifying characteristics in data; therefore, it makes sense to create a Primary Key.
Explicitly initializing and modifying the auto-increment value is possible at any time.
Record identifiers can easily be created that are unique to each record.
Automatic incrementing allows flexibility in handling gaps between records.
Syntax-speaking, auto-increment queries in SQL are straightforward
In some cases you may not have any unique identifying characteristics in data; therefore, it makes sense to create a Primary Key.
Explicitly initializing and modifying the auto-increment value is possible at any time.
Record identifiers can easily be created that are unique to each record.
Automatic incrementing allows flexibility in handling gaps between records.
Syntax-speaking, auto-increment queries in SQL are straightforward