Home » MCQs » SQL MCQs » SQL Auto Increment, Like, Commit and Rollback MCQs

Which of the following is the feature(s) of SQL Auto Increment?

2. Which of the following is the feature(s) of SQL Auto Increment?

1. In some cases you may not have any unique identifying characteristics in data; therefore, it makes sense to create a Primary Key.
2. Explicitly initializing and modifying the auto-increment value is possible at any time.
3. Record identifiers can easily be created that are unique to each record.
4. All of the above

Answer: D) All of the above

Explanation:

Features of SQL Auto Increment are:

1. In some cases you may not have any unique identifying characteristics in data; therefore, it makes sense to create a Primary Key.
2. Explicitly initializing and modifying the auto-increment value is possible at any time.
3. Record identifiers can easily be created that are unique to each record.
4. Automatic incrementing allows flexibility in handling gaps between records.
5. Syntax-speaking, auto-increment queries in SQL are straightforward.