Database - Managing Databases with Oracle - Discussion

Discussion :: Managing Databases with Oracle - General Questions (Q.No.2)


Which statement about sequences is not true?

[A]. A sequence is an object that generates a sequential series of unique numbers.
[B]. Sequences are most often used to provide values for surrogate keys.
[C]. NextVal and CurrVal are both sequence methods.
[D]. Sequences guarantee valid surrogate key values.

Answer: Option D


No answer description available for this question.

Adi said: (Apr 15, 2013)  
What is the meaning of surrogate key values?

Ali said: (Sep 23, 2014)  
When an OLTP systems are merged to Warehouse then warehouse creates own unique keys by the composition of multiple unique keys of OLTP system.

Yash said: (Jul 17, 2015)  
Still surrogate key values are not cleared? Can someone please explain it in more details?

Annu said: (Sep 7, 2016)  
These are like substitute or alternate key to a column or a group of column, given as a unique ID.

Post your comments here:

Name *:

Email   : (optional)

» Your comments will be displayed only after manual approval.