Multiple choice technology databases

Which of the following is a characteristic of a sequence?

  1. A sequence will never generate duplicate values. b.The MAXVALUE of a sequence can be equal to the MINVALUE. c.It is not possible to create a sequence that generates a constant since the INCREMENT value must be greater than zero.

  2. The MAXVALUE of a sequence can be equal to the MINVALUE

  3. It is not possible to create a sequence that generates a constant since the INCREMENT value must be greater than zero.

  4. When a sequence cycles back to either the MAXVALUE or MINVALUE, it will always be equal to the specified value of either of these two boundaries.
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

A sequence's maximum value can equal its minimum value, though this restricts the sequence to a single value. Other options are incorrect: sequences can generate duplicates upon cycling, and an increment value of zero is technically syntactically prohibited but increment options aren't restricted to positive integers.

Keep practicing — related questions