Question 1

Which of the following statements about NEXTVAL and CURRVAL is incorrect?

Accepted Answer

A)   The pseudocolumn NEXTVAL is used to actually generate the sequence value.
B)   After the value is generated, it is stored in the CURRVAL pseudocolumn so it can be referenced again by a user.
C)   A reference to CURRVAL will not cause Oracle10g to generate a new sequence number; a reference to NEXTVAL, however, will generate a new number.
D)   NEXTVAL and CURRVAL are pseudocolumns that store unique names for database objects.

Question 2

A synonym is an alternate name assigned to database $\underline { \text { instances } }$. _________________________

Accepted Answer

A) True 
 B)False

Question 3

The highest possible value for a descending sequence is -1.

Accepted Answer

A) True 
 B)False

Question 4

Oracle10g will begin each sequence with the value of one, unless another value is specified in the ____ clause.

Accepted Answer

A)   START WITH
B)   INTERVAL SIZE
C)   INCREMENT BY
D)   VALUE START

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

Which of the following is used to establish a minimum or maximum value, respectively, for a sequence?

Accepted Answer

A)   MINIMUMVALUE | MAXIMUMVALUE
B)   MINVALUE | MAXVALUE
C)   STARTWITH | ENDWITH
D)   BEGINVALUE | ENDVALUE

Question 7

The ____ options are used to determine whether Oracle10g should begin reissuing values from the sequence once the minimum or maximum value has been reached.

Accepted Answer

A)   CYCLE | NOCYCLE
B)   MINIMUMVALUE | MAXIMUMVALUE
C)   CACHE | NOCACHE
D)   REORDER | NOREORDER

Question 8

A function-based index can be used for queries that include searches based upon arithmetic expressions or functions.

Accepted Answer

A) True 
 B)False

Question 9

The ____ clause is used to specify the interval between two sequential values.

Accepted Answer

A)   INTERVAL SIZE
B)   INCREMENT BY
C)   STEP BY
D)   START WITH

Question 10

Indexes can speed up row retrieval, but can slow down ____________________ operations because the index must also be updated.

Accepted Answer

The answer of Indexes can speed up row retrieval, but...

Question 11

The ____________________ pseudocolumn is used to generate the next sequence value.

Accepted Answer

The answer of The ____________________ pseudocolumn is used to generate...

Question 12

How can an organization use a sequence for internal control purposes?

Accepted Answer

One aim of internal control is to ensure...

Question 13

A basic CREATE INDEX command will create a B-Tree index.

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A)   CREATE PUBLIC INDEX customers_name_idxON customers (lastname, firstname) ;
B)   CREATE PUBLIC INDEX customers_name_idxON customers (lastname) ;
C)   CREATE INDEX customers_name_idxON customers (lastname, firstname) ;
D)   CREATE PUBLIC INDEX customers_name_idxFOR customers (lastname) ;

Question 15

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?

Accepted Answer

A)   sequence
B)   index
C)   synonym
D)   schema alias

Question 16

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?

Accepted Answer

A)   NOMAXVALUE
B)   CYCLE
C)   INCREMENT BY 5
D)   MAXVALUE 200

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

Which of the following statements about sequences is incorrect?

Accepted Answer

A)   A sequence can be used to generate unique names for database objects.
B)   A sequence can be used to generate unique values to serve as a primary key.
C)   A sequence can be used to generate sequential values for internal control purposes.
D)   A sequence can be used to generate sequential numbers to track records like checks, invoices, and purchase orders.

Question 19

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

Accepted Answer

The answer of After a value is generated, it is...

Question 20

The NEXTVAL pseudocolumn can be referenced in an INSERT command to add the value to a database table.

Accepted Answer

A) True 
 B)False

Exam 6: Additional Database Objects

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

Correct AnswerverifiedShow Answer

Which of the following is used to establish a minimum or maximum value, respectively, for a sequence?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

How can an organization use a sequence for internal control purposes?

Correct AnswerverifiedOne aim of internal control is to ensure...View AnswerShow Answer

The NEXTVAL pseudocolumn can be referenced in an INSERT command to add the value to a database table.

Correct AnswerverifiedShow Answer

Which of the following statements about NEXTVAL and CURRVAL is incorrect?

Correct AnswerverifiedShow Answer

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?

Correct AnswerverifiedShow Answer

Which of the following statements about sequences is incorrect?

Correct AnswerverifiedShow Answer

A basic CREATE INDEX command will create a B-Tree index.

Correct AnswerverifiedShow Answer

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?

Correct AnswerverifiedShow Answer

The ____ clause is used to specify the interval between two sequential values.

Correct AnswerverifiedShow Answer

The highest possible value for a descending sequence is -1.

Correct AnswerverifiedShow Answer

A function-based index can be used for queries that include searches based upon arithmetic expressions or functions.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The ____________________ pseudocolumn is used to generate the next sequence value.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

A synonym is an alternate name assigned to database instances ‾\underline { \text { instances } } instances ​ . _________________________

Correct AnswerverifiedShow Answer

Indexes can speed up row retrieval, but can slow down ____________________ operations because the index must also be updated.

Correct AnswerverifiedShow Answer

Oracle10g will begin each sequence with the value of one, unless another value is specified in the ____ clause.

Correct AnswerverifiedShow Answer

The ____ options are used to determine whether Oracle10g should begin reissuing values from the sequence once the minimum or maximum value has been reached.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
One aim of internal control is to ensure...
View 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 synonym is an alternate name assigned to database $\underline { \text { instances } }$ . _________________________

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified