SQL and PL/SQL Question:

Download Job Interview Questions and Answers PDF

What is Sequences?

SQL and PL/SQL Interview Question
SQL and PL/SQL Interview Question

Answer:

Sequences are used for generating sequence numbers without any overhead of locking. Drawback is that after generating a sequence number if the transaction is rolled back, then that sequence number is lost.

Download SQL and PL/SQL Interview Questions And Answers PDF

Previous QuestionNext Question
What is Multiple columns?What is Synonyms?