FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 6: Additional Database Objects

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 71

Multiple Choice

Review LaterAdd Note

Review Later

Which of the following commands can be used to remove a sequence from a database?​

A) ​DELETE SEQ
B) ​DROP SEQ
C) ​REMOVE SEQUENCE
D) ​DROP SEQUENCE

Correct Answer

verified

Show Answer

Question 72

Multiple Choice

Review LaterAdd Note

Review Later

Structure of the CUSTOMERS table ​ -​Which of the following commands can be used to create a sequence for the CUSTOMERS table?

A) ​CREATE SEQUENCE customers_customer#;
B) ​CREATE SEQUENCE customers_customer#
START WITH 2000
C) ​CREATE SEQUENCE customers_customer#
INCREMENT BY -1
NOCACHE|CACHE;
D) ​all of the above

Correct Answer

verified

Show Answer

Question 73

True/False

Review LaterAdd Note

The CYCLE option prevents a sequence from regenerating previous values._________________________

An index is implicitly created when a NOT NULL constraint is added to a table.​

​The USER_ALL data dictionary view displays information about all the relevant objects owned by the user._________________________

Structure of the BOOKS table ​ -Based on the structure of the BOOKS table,which of the following is a valid SQL statement?​

Which of the following keywords is used to actually generate a sequence value?

The last value generated by a sequence is stored in the ____ pseudocolumn.

A(n)sequencecan be used to generate a series of numeric values._________________________

​The starting value for a sequence cannot be changed using the ____________________ SEQUENCE command.

Using an identity column is particularly suited to use for a primary key when only random values are needed to uniquely identify rows.

Indexes are usually created for frequently referenced or searched columns._________________________

Which of the following commands can be used to modify an index?​

If the last values generated by a sequence were 277 and 278,which of the following changes cannot be initiated by the ALTER SEQUENCE command?​

An index is implicitly created whenever a(n)CHECK constraint is created for a table column._________________________​

Structure of the BOOKS table ​ -Which of the following methods is not used in an INSERT statement to enable the use of a DEFAULT sequence value defined for a column?​

The ____________________ view can be used to verify the existence of an index owned by a user.

​A(n)synonym is a collection of objects._________________________