A sequence is an Oracle database object. Which of the following statements is tr

Question

A sequence is an Oracle database object. Which of the following statements is true about sequences:

For an Oracle sequence, the starting value can be something other than one, but the increment between values generated is fixed at 1 always.

It can be used to generate sequential values to populate a surrogate key field that you are planning to use as the primary key of a table.

If you use a sequence to populate values of a surrogate key field, then you cannot insert a literal value directly into the field without using the sequence.

For an Oracle sequence, the starting value can be something other than one, but the increment between values generated is fixed at 1 always.

It can be used to generate sequential values to populate a surrogate key field that you are planning to use as the primary key of a table.

If you use a sequence to populate values of a surrogate key field, then you cannot insert a literal value directly into the field without using the sequence.

Explanation / Answer

The default value of sequence is 1 and is used for used to generating sequential values to populate a surrogate key field that you are planning to use as the primary key of a table. Hence the correct option is c. It can be used to generate sequential values to populate a surrogate key field that you are planning to use as the primary key of a table.

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.