The ____________________ value of a sequence cannot be changed if the sequence has already generated a number greater than that value.

A NEXTVAL call generates the sequence value of 5. After the value is generated, what value will be stored in CURRVAL?

Answers:	a. 5
	b. 4
	c. unknown
	d. 6

The ____________________ SEQUENCE command can be used to permanently delete a sequence from a database.

Which option is used to have Oracle12c pre-generate a set of values and store those values in the server's memory?

Answers:	a. CACHE
	b. INTERVAL STORE
	c. CACHE VALUE
	d. INCREMENT BY

Which of the following sequence settings cannot be changed with the ALTER SEQUENCE command?

Answers:	a. NOCACHE
	b. NOMAXVALUE
	c. START WITH
	d. INCREMENT BY

	A(n) ____________________ can be used to quickly locate specific records in a large table.

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

Answers:	True
	False

A(n) index can be created based on more than one column. _________________________

Answers:	True
	False

Even if you created a PUBLIC synonym, you must have ____________________ privileges to delete a PUBLIC synonym.