Database Administration Question:
Download Job Interview Questions and Answers PDF
Explain What is an Oracle sequence?
Answer:
A sequence is a database object created by a user that can be used to generate unique integers. A typical usage of sequences is to generate primary key values which are unique for each row.
It is generated and incremented (or decremented) by an internal Oracle routine. It can be used by multiple users and for multiple tables too. A sequence can be used instead of writing an application code for sequence-generating routine.
It is generated and incremented (or decremented) by an internal Oracle routine. It can be used by multiple users and for multiple tables too. A sequence can be used instead of writing an application code for sequence-generating routine.
Download Database Administration Interview Questions And Answers
PDF
Previous Question | Next Question |
Explain When can hash cluster used? | Explain What is an extent? |