Database - Managing Databases with Oracle - Discussion

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

Managing Databases with Oracle

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

Explanation:

No answer description is available. Let's discuss.

Discussion:

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:

Quick links

Quantitative Aptitude

Verbal (English)

Reasoning

Programming

Interview

Placement Papers