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

Shivam • 8.86K Points
Tutor III

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

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

Correct Answer - Option(D)
Views: 106
Filed under category MySQL

Explanation by: Shivam

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

You must be Logged in to update hint/solution