Database - Managing Databases with Oracle - Discussion

Discussion Forum : Managing Databases with Oracle - General Questions (Q.No. 2)
Which statement about sequences is not true?
A sequence is an object that generates a sequential series of unique numbers.
Sequences are most often used to provide values for surrogate keys.
NextVal and CurrVal are both sequence methods.
Sequences guarantee valid surrogate key values.
Answer: Option
No answer description is available. Let's discuss.
4 comments Page 1 of 1.

Annu said:   7 years ago
These are like substitute or alternate key to a column or a group of column, given as a unique ID.

Yash said:   8 years ago
Still surrogate key values are not cleared? Can someone please explain it in more details?

Ali said:   8 years ago
When an OLTP systems are merged to Warehouse then warehouse creates own unique keys by the composition of multiple unique keys of OLTP system.

Adi said:   10 years ago
What is the meaning of surrogate key values?

Post your comments here:

Your comments will be displayed after verification.