🎴 Flashcard Mode
DB2 and Oracle Database Fundamentals
Card1 / 20
Mastered0
Review0
QuestionClick to flip
For auto-increment in oracle,sql command is written with the keyword?
AnswerClick to flip back
A
sequence
💡 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.