Question 1

An index can be created ____.​

Accepted Answer

A)  ​implicitly 
B)  ​explicitly 
C)  ​only at instance startup 
D)  ​both a and b

Question 2

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_idx
ON customers (lastname,firstname); 
B)  ​CREATE PUBLIC INDEX customers_name_idx
ON customers (lastname); 
C)  CREATE INDEX customers_name_idx
ON customers (lastname,firstname);​ 
D)  ​CREATE PUBLIC INDEX customers_name_idx
FOR customers (lastname);

Question 3

A DEFAULT sequence value will override any value provided for the column in an INSERT statement.

Accepted Answer

A) True 
 B)False

Question 4

A large table containing a particular column that is frequently referenced by a WHERE clause would probably benefit from a(n)sequence._________________________

Accepted Answer

A) True 
 B)False

Question 5

When a positive value is assigned to the INCREMENT BY clause of the CREATE SEQUENCE command,numeric values are generated in descending order.​

Accepted Answer

A) True 
 B)False

Question 6

The ____________________ option is used to indicate that the values assigned by a sequence can be used after the maximum value is reached.

Accepted Answer

The answer of The ____________________ option is used to indicate...

Question 7

Both a minimum and maximum value can be defined for a(n)sequence._________________________

Accepted Answer

A) True 
 B)False

Question 8

​The ____________________ clause is used to indicate the interval that must exist between two values generated in a sequence.

Accepted Answer

The answer of ​The ____________________ clause is used to indicate...

Question 9

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

Question 10

A Bitmap index is useful for improving queries on columns that have low cardinality.​

Accepted Answer

A) True 
 B)False

Question 11

A NEXTVAL call generates the sequence value of 5.After the value is generated,what value will be stored in CURRVAL?

Accepted Answer

A)  ​5 
B)  ​4 
C)  ​6 
D)  unknown

Question 12

A negative number can be assigned to the ____ clause to generate sequential numbers in decreasing order.

Accepted Answer

A)  DECREMENT BY 
B)  INCREMENT BY 
C)  DECREASE BY 
D)  GENERATE BY

Question 13

A sequence can be deleted from the database using the DROP SEQUENCE command._________________________

Accepted Answer

A) True 
 B)False

Question 14

Which command will modify a sequence?​

Accepted Answer

A)  ​ALTER SEQUENCE...MODIFY 
B)  ​ALTER SEQUENCE sequencename. 
C)  ​ALTER SEQUENTIAL sequencename 
D)  ​ALTER SEQUENTIAL sequencename.

Question 15

Which command will delete a sequence?​

Accepted Answer

A)  ​ALTER SEQUENCE...DELETE 
B)  ​ALTER SEQUENCE...DROP 
C)  ​DELETE SEQUENCE sequencename 
D)  ​DROP SEQUENCE sequencename

Question 16

A synonym is an alternate name assigned to database instances._________________________

Accepted Answer

A) True 
 B)False

Question 17

​How does an Index Organized table differ from a standard table and a typical index?

Accepted Answer

The answer of ​How does an Index Organized table differ...

Question 18

The ____________________ index structure can be particularly beneficial in queries involving compound conditions (AND and OR operator usage).

Accepted Answer

The answer of The ____________________ index structure can be particularly...

Question 19

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 20

If a sequence is set to pre-generate sequential values,____ values will be generated at one time by default.

Accepted Answer

A)  ​5 
B)  ​10 
C)  ​15 
D)  ​20

Exam 6: Additional Database Objects

An index can be created ____.

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

A DEFAULT sequence value will override any value provided for the column in an INSERT statement.

A large table containing a particular column that is frequently referenced by a WHERE clause would probably benefit from a(n)sequence._________________________

When a positive value is assigned to the INCREMENT BY clause of the CREATE SEQUENCE command,numeric values are generated in descending order.

The ____________________ option is used to indicate that the values assigned by a sequence can be used after the maximum value is reached.

Both a minimum and maximum value can be defined for a(n)sequence._________________________

The ____________________ clause is used to indicate the interval that must exist between two values generated in a sequence.

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

A Bitmap index is useful for improving queries on columns that have low cardinality.

A NEXTVAL call generates the sequence value of 5.After the value is generated,what value will be stored in CURRVAL?

A negative number can be assigned to the ____ clause to generate sequential numbers in decreasing order.

A sequence can be deleted from the database using the DROP SEQUENCE command._________________________

Which command will modify a sequence?

Which command will delete a sequence?

A synonym is an alternate name assigned to database instances._________________________

How does an Index Organized table differ from a standard table and a typical index?

The ____________________ index structure can be particularly beneficial in queries involving compound conditions (AND and OR operator usage).

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

If a sequence is set to pre-generate sequential values,____ values will be generated at one time by default.

Exam 6: Additional Database Objects

An index can be created ____.​

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

A DEFAULT sequence value will override any value provided for the column in an INSERT statement.

A large table containing a particular column that is frequently referenced by a WHERE clause would probably benefit from a(n)sequence._________________________

When a positive value is assigned to the INCREMENT BY clause of the CREATE SEQUENCE command,numeric values are generated in descending order.​

The ____________________ option is used to indicate that the values assigned by a sequence can be used after the maximum value is reached.

Both a minimum and maximum value can be defined for a(n)sequence._________________________

​The ____________________ clause is used to indicate the interval that must exist between two values generated in a sequence.

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

A Bitmap index is useful for improving queries on columns that have low cardinality.​

A NEXTVAL call generates the sequence value of 5.After the value is generated,what value will be stored in CURRVAL?

A negative number can be assigned to the ____ clause to generate sequential numbers in decreasing order.

A sequence can be deleted from the database using the DROP SEQUENCE command._________________________

Which command will modify a sequence?​

Which command will delete a sequence?​

A synonym is an alternate name assigned to database instances._________________________

​How does an Index Organized table differ from a standard table and a typical index?

The ____________________ index structure can be particularly beneficial in queries involving compound conditions (AND and OR operator usage).

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

If a sequence is set to pre-generate sequential values,____ values will be generated at one time by default.

An index can be created ____.

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

When a positive value is assigned to the INCREMENT BY clause of the CREATE SEQUENCE command,numeric values are generated in descending order.

The ____________________ clause is used to indicate the interval that must exist between two values generated in a sequence.

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

A Bitmap index is useful for improving queries on columns that have low cardinality.

Which command will modify a sequence?

Which command will delete a sequence?

How does an Index Organized table differ from a standard table and a typical index?

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