06

Chapter 6: Additional Database Objects

TRUE/FALSE

1. A sequence serves as a nickname for a database object.

ANS: F PTS: 1 REF: 158

2. A database index allows users and application programs to quickly locate specific records.

ANS: T PTS: 1 REF: 158

3. A synonym is an alternate name assigned to a database object.

ANS: T PTS: 1 REF: 158

4. When a positive value is assigned to the INCREMENT BY clause of the CREATE SEQUENCE command, numeric values are generated in descending order.

ANS: F PTS: 1 REF: 161

5. When a negative value is assigned to the INCREMENT BY clause of the CREATE SEQUENCE command, numeric values are generated in descending order.

ANS: T PTS: 1 REF: 161

6. The START WITH clause is used to identify the starting numeric value for a synonym.

ANS: F PTS: 1 REF: 161

7. By default, the START WITH clause has a value of one.

ANS: T PTS: 1 REF: 161

8. By default, the lowest value that can be generated by a sequence is 0.

ANS: F PTS: 1 REF: 161-162

9. If the minimum value for a sequence is not specified, then NOMINVALUE will be assumed as the default.

ANS: T PTS: 1 REF: 161

10. The highest possible value for a descending sequence is -1.

ANS: T PTS: 1 REF: 162

11. The highest possible value for a sequence can be specified through the MAXVALUE clause.

ANS: T PTS: 1 REF: 161

12. After the highest possible value for a sequence has been reached, previous values can be reused if the NOCYCLE option has been specified.

ANS: F PTS: 1 REF: 162

13. The NOCACHE option specifies that the sequence can generate a number only after a request has been made by a user.

ANS: T PTS: 1 REF: 162

14. Pre-generated sequence numbers that have not been used when the database is shut down will no longer be available when the database is restarted.

ANS: T PTS: 1 REF: 162

15. When a sequence is created for internal control purposes, the values should not be cached otherwise gaps may appear in the sequence.

ANS: T PTS: 1 REF: 162

16. The