1. Which of the following generates a series of integers that can be stored in a database? a. a number generator b. a view c. a sequence d. an index e. a synonym 2. Which syntax is correct for removin…
1. Which of the following generates a series of integers that can be stored in a database?
a. a number generator
b. a view
c. a sequence
d. an index
e. a synonym
2. Which syntax is correct for removing a public synonym?
a. DROP SYNONYM synonymname;
b. DELETE PUBLIC SYNONYM synonymname;
c. DROP PUBLIC SYNONYM synonymname;
d. DELETE SYNONYM synonymname;
3. Which of the following commands can you use to modify an index?
a. ALTER SESSION
b. ALTER TABLE
c. MODIFY INDEX
d. ALTER INDEX
e. none of the above
4. Which of the following generates an integer in a sequence?
a. NEXTVAL
b. CURVAL
c. NEXT_VALUE
d. CURR_VALUE
e. NEXT_VAL
f. CUR_VAL
OR