Multiple choice technology databases

For auto-increment in oracle,sql command is written with the keyword?

  1. auto_increment

  2. sequence

  3. identity

  4. increment
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

In Oracle, auto-increment functionality is implemented using SEQUENCE objects, not the auto_increment keyword used in MySQL. A sequence generates unique numeric values that can be used for auto-incrementing primary keys through triggers or direct insertion. Option A is MySQL syntax, Option C is SQL Server/PostgreSQL syntax, and Option D is not a valid keyword in this context.

Keep practicing — related questions