Question 1

An index can be created with the ____________________ INDEX command.

Accepted Answer

The answer of An index can be created with the...

Question 2

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

Accepted Answer

A)   NEXTVAL
B)   DUAL
C)   CURRENTVAL
D)   CURRVAL

Question 3

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

Accepted Answer

A)   NEXTVALUE
B)   NEXTVAL
C)   GENERATEVAL
D)   GENERATE

Question 4

Which of the following commands is used to create a function-based index?

Accepted Answer

A)   CREATE FUNCTION INDEX...ON
B)   CREATE INDEX...ON
C)   CREATE INDEX....FOR
D)   CREATE INDEX...FUNCTION

Question 5

Which command will modify a sequence?

Accepted Answer

A)   ALTER SEQUENCE...MODIFY
B)   ALTER SEQUENCE sequencename
C)   ALTER SEQUENTIAL sequencename
D)   CREATE OR REPLACE SEQUENCE

Question 6

A function-based index can be created based on which of the following?

Accepted Answer

A)   UPPER(lastname) 
B)   (retail-cost) 
C)   UPPER(firstname) 
D)   all of the above

Question 7

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.

Accepted Answer

The answer of The ____________________ option of a sequence indicates...

Question 8

After the highest possible value for a sequence has been reached, previous values can be reused if the NOCYCLE option has been specified.

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A)   INTERVAL STORE
B)   CACHE VALUE
C)   CACHE
D)   INCREMENT BY

Question 11

When working with cached sequence values, which of the following is correct?

Accepted Answer

A)   The cache option instructs Oracle10g to return the sequence values in the same order in which the user requests were received.
B)   The cache option instructs Oracle10g not to generate any more numbers after the minimum or maximum value has been reached.
C)   When a value has been generated and cached, that value has been assigned and cannot be regenerated until the sequence begins a new cycle.
D)   The highest value for a cached number is 10^44.

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

A(n)$\underline {\text { synonym } }$ is a collection of objects. _________________________

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

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

Question 15

Which command will create a sequence named NEWSEQUENCE to generate a series of integers?

Accepted Answer

A)   CREATE SEQUENCE newsequence;
B)   CREATE SEQUENCE STARTING WITH 5;
C)   CREATE SEQUENTIAL newsequence STARTING WITH 5;
D)   none of the above

Question 16

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

Accepted Answer

The answer of The ____________________ view can be used to...

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

Which command will create an index?

Accepted Answer

A)   CREATE INDEX indexname IN tablename (columnname) 
B)   CREATE INDEX indexname REFERENCE (columnname) 
C)   CREATE INDEX indexname ON tablename (columnname) 
D)   CREATE INDEX indexname INCREMENT BY (columnname)

Question 19

A(n) ____________________ synonym is an alternate name that can be referenced by all users.

Accepted Answer

The answer of A(n) ____________________ synonym is an alternate name...

Question 20

The $\underline {\text { USER ALL }}$ data dictionary view displays information about all the relevant objects owned by the user. _________________________

Accepted Answer

A) True 
 B)False

Exam 6: Additional Database Objects

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

When working with cached sequence values, which of the following is correct?

Correct AnswerverifiedShow Answer

After the highest possible value for a sequence has been reached, previous values can be reused if the NOCYCLE option has been specified.

Correct AnswerverifiedShow Answer

A(n) ____________________ synonym is an alternate name that can be referenced by all users.

Correct AnswerverifiedShow Answer

Which command will modify a sequence?

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

Which of the following commands is used to create a function-based index?

Correct AnswerverifiedShow Answer

Which command will create a sequence named NEWSEQUENCE to generate a series of integers?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

An index can be created with the ____________________ INDEX command.

Correct AnswerverifiedShow Answer

A(n) synonym ‾\underline {\text { synonym } } synonym ​ is a collection of objects. _________________________

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The USER ALL ‾\underline {\text { USER ALL }} USER ALL ​ data dictionary view displays information about all the relevant objects owned by the user. _________________________

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

A function-based index can be created based on which of the following?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Which command will create an index?

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

A(n) $\underline {\text { synonym } }$ is a collection of objects. _________________________

Correct Answer
verified

Correct Answer
verified

The $\underline {\text { USER ALL }}$ data dictionary view displays information about all the relevant objects owned by the user. _________________________

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified