ORACLE DATABASE INTERVIEW QUESTIONS

What is an auto-increment feature in Oracle, and why is it used?

How do you create an auto-increment column in Oracle?

What is the purpose of using a sequence in Oracle for auto-increment functionality?

How can you view the current value of a sequence in Oracle?

How do you reset a sequence in Oracle?

Can you have multiple auto-increment columns in a single Oracle table? Why or why not?

How do you handle gaps in sequence values caused by transaction rollbacks?

How do you ensure that a sequence value is used only once even in a multi-user environment?

What are some potential issues with using sequences for auto-increment, and how can they be mitigated?

Explain how to implement an auto-increment column using identity columns introduced in Oracle 12c.