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 51

True/False

Review LaterAdd Note

Review Later

​The USER_INDEXES data dictionary view can be used to verify existing indexes.________________________

A) True
B) False

Correct Answer

verified

Show Answer

Question 52

Multiple Choice

Review LaterAdd Note

Review Later

Structure of the BOOKS table ​ -​Which of the following is not a valid statement concerning identity columns.

A) ​A DEFAULT clause may be assigned
B) ​A unique constraint is automatically applied
C) ​Only one may be created in a table
D) ​Must have a numeric data type

E) B) and D)
F) B) and C)

Correct Answer

verified

Show Answer

Question 53

Short Answer

Review LaterAdd Note

The ____________________ option of a sequence indicates that a set of values are to be pre-generated by the sequence rather than wait for a user request.​

To change the starting value for a sequence,the sequence must be dropped and then re-created.

A(n)____________________ synonym can be referenced by other database users.

The ____________________ SYNONYM command is used to permanently remove a synonym from a database

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

The purpose of an index is to ____.​

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

All synonyms are PUBLIC.

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

Which of the following can be created so other users will not need to prefix a table owned by user Jeff with his schema name?

To create a PUBLIC synonym,the PUBLIC keyword must be used in the CREATE SYNONYM command._________________________​

If the PUBLIC keyword is not included when a synonym is created,the command will create a(n) ____ synonym,by default.​

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

The NEXTVALUE pseudocolumn is used to actually generate the next value in a sequence.​

The INCREMENT BY setting for a sequence cannot be changed with the ALTER SEQUENCE command._________________________

A(n)index can be used to quickly determine whether a value already exists in a specific column._________________________​

After a value is generated,it is stored in the ____________________ pseudocolumn so it can be referenced again by a user.

An index can be created with the ____________________ INDEX command.