Test Bank For Oracle 11G SQL 2nd Edition By Joan Casteel

Description

Test Bank For Oracle 11G SQL 2nd Edition By Joan Casteel

Chapter 6: Additional Database Objects
TRUE/FALSE
1. A sequence serves as a nickname for a database object.
ANS: F PTS: 1 REF: 176

2. A database index allows users and application programs to quickly locate specific records.
ANS: T PTS: 1 REF: 176

3. A synonym is an alternate name assigned to a database object.
ANS: T PTS: 1 REF: 176

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: 178

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: 178

6. The START WITH clause is used to identify the starting numeric value for a synonym.
ANS: F PTS: 1 REF: 179

7. By default, the START WITH clause has a value of one.
ANS: T PTS: 1 REF: 179

8. By default, the lowest value that can be generated by a sequence is 0.
ANS: F PTS: 1 REF: 178

9. If the minimum value for a sequence is not specified, then NOMINVALUE will be assumed as the
default.
ANS: T PTS: 1 REF: 179

10. The highest possible value for a descending sequence is -1.
ANS: T PTS: 1 REF: 179

11. The highest possible value for a sequence can be specified through the MAXVALUE clause.
ANS: T PTS: 1 REF: 179
2
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: 179

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: 180

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: 180

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: 180

16. The USER_SEQUENCES view of the data dictionary can be used to determine the current values
and settings for a sequence.
ANS: T PTS: 1 REF: 182

17. The NEXTVALUE pseudocolumn is used to actually generate the next value in a sequence.
ANS: F PTS: 1 REF: 183

18. The NEXTVAL pseudocolumn can be referenced in an INSERT command to add the value to a
database table.
ANS: T PTS: 1 REF: 183

19. The START WITH clause of a sequence cannot be reset with the ALTER SEQUENCE command.
ANS: T PTS: 1 REF: 185

20. To change the starting value for a sequence, the sequence must be dropped and then re-created.
ANS: T PTS: 1 REF: 185