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 USER_INDEXES data dictionary view can be used to verify existing indexes. _________________________

Accepted Answer

A) True 
 B)False

Question 3

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 4

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

Accepted Answer

A) True 
 B)False

Question 5

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 6

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 
A)  ALTER SEQUENCE...MODIFY 
B)  ALTER SEQUENCE sequencename 
C)  ALTER SEQUENTIAL sequencename 
D)  CREATE OR REPLACE SEQUENCE

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

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 
A)  INTERVAL STORE 
B)  CACHE VALUE 
C)  CACHE 
D)  INCREMENT BY

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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) 
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 11

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 
A)  UPPER(lastname) 
B)  (retail-cost) 
C)  UPPER(firstname) 
D)  all of the above

Question 12

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 
A)  DELETE SEQ 
B)  DROP SEQ 
C)  REMOVE SEQUENCE 
D)  DROP SEQUENCE

Question 13

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 14

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

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 
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 last value generated by a sequence is stored in the ____ pseudocolumn.

Accepted Answer

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

Question 17

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 
A)  CREATE FUNCTION INDEX...ON 
B)  CREATE INDEX...ON 
C)  CREATE INDEX....FOR 
D)  CREATE INDEX...FUNCTION

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

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

Question 20

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. 
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.

An index can be created with the ____________________ INDEX command.

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

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

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

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

Which command will modify a sequence?

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.

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

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

Which command will create an index?

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

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

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

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

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

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

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

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

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

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

Overview of Database Concepts

Basic Sql Select Statements

Table Creation and Management

Constraints

Data Manipulation and Transaction Control

User Creation and Management

Restricting Rows and Sorting Data

Joining Data From Multiple Tables

Selected Single Row Functions

Group Functions

Subqueries and Merge Statements

Views

Filters

Exam 6: Additional Database Objects

An index can be created with the ____________________ INDEX command.

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

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

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

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

Which command will modify a sequence?

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.

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

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

Which command will create an index?

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

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

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

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

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

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

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

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

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

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

Overview of Database Concepts

Basic Sql Select Statements

Table Creation and Management

Constraints

Data Manipulation and Transaction Control

User Creation and Management

Restricting Rows and Sorting Data

Joining Data From Multiple Tables

Selected Single Row Functions

Group Functions

Subqueries and Merge Statements

Views

Filters

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

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