Question 1

An index can be created ____.​

Accepted Answer

A)  ​implicitly 
B)  ​explicitly 
C)  ​only at instance startup 
D)  ​both a and b 
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); 
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 
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 
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. 
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 
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

This structure stores the contents of th

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 
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 
A)  ​5 
B)  ​10 
C)  ​15 
D)  ​20

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.

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

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.

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

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?