Question 1

The NOCACHE option specifies that the sequence can generate a number only after a request has been made by a user.

Accepted Answer

A) True 
 B)False

Question 2

The lowest possible value for an increasing sequence is $\underline {  1 .  }$. _________________________

Accepted Answer

A) True 
 B)False

Question 3

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 4

The starting value for a sequence cannot be changed using the ____________________ SEQUENCE command.

Accepted Answer

The answer of The starting value for a sequence cannot...

Question 5

The START WITH clause of a sequence cannot be reset with the ALTER SEQUENCE command.

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

Sequence settings can be altered using the $\underline {\text { ALTER SEQUENCE }}$ command. _________________________

Accepted Answer

A) True 
 B)False

Question 8

A synonym can be created for any database object such as a table or sequence.

Accepted Answer

A) True 
 B)False

Question 9

When creating a sequence, which of the following is not an optional clause?

Accepted Answer

A)  INCREMENT BY value 
B)  CYCLE | NOCYCLE 
C)  MAXVALUE value | NOMAXVALUE 
D)  CREATE SEQUENCE 
A)  INCREMENT BY value 
B)  CYCLE | NOCYCLE 
C)  MAXVALUE value | NOMAXVALUE 
D)  CREATE SEQUENCE

Question 10

Pre-generated sequence numbers that have not been used when the database is shut down will no longer be available when the database is restarted.

Accepted Answer

A) True 
 B)False

Question 11

The $\underline { \text { CYCLE } }$ option prevents a sequence from regenerating previous values. _________________________

Accepted Answer

A) True 
 B)False

Question 12

Which command will create a synonym for a table?

Accepted Answer

A)  CREATE SYNONYM synonymname IN tablename; 
B)  CREATE SYNONYM synonymname ON tablename; 
C)  CREATE SYNONYM synonymname REFERENCE tablename; 
D)  CREATE SYNONYM synonymname FOR tablename; 
A)  CREATE SYNONYM synonymname IN tablename; 
B)  CREATE SYNONYM synonymname ON tablename; 
C)  CREATE SYNONYM synonymname REFERENCE tablename; 
D)  CREATE SYNONYM synonymname FOR tablename;

Question 13

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 14

Which of the following contains the ROWID of referenced rows?

Accepted Answer

A)  sequence 
B)  index 
C)  private synonym 
D)  public synonym 
A)  sequence 
B)  index 
C)  private synonym 
D)  public synonym

Question 15

An index is implicitly created whenever a(n) $\underline {\text { CHECK } }$constraint is created for a table column. _________________________

Accepted Answer

A) True 
 B)False

Question 16

A sequence serves as a nickname for a database object.

Accepted Answer

A) True 
 B)False

Question 17

A sequence can be used to speed up row retrieval.

Accepted Answer

A) True 
 B)False

Question 18

Which of the following commands can be used to modify an index?

Accepted Answer

A)  ALTER INDEX...MODIFY 
B)  ALTER INDEX...CHANGE 
C)  ALTER TABLE...INDEX 
D)  none of the above 
A)  ALTER INDEX...MODIFY 
B)  ALTER INDEX...CHANGE 
C)  ALTER TABLE...INDEX 
D)  none of the above

Question 19

If more than ____________________ percent of a table is expected to be returned in the results of a query, then an index will probably not speed up the process.

Accepted Answer

The answer of If more than ____________________ percent of a...

Question 20

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

The NOCACHE option specifies that the sequence can generate a number only after a request has been made by a user.

The lowest possible value for an increasing sequence is $\underline { 1 . }$ . _________________________

An index can be created ____.

The starting value for a sequence cannot be changed using the ____________________ SEQUENCE command.

The START WITH clause of a sequence cannot be reset with the ALTER SEQUENCE command.

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

Sequence settings can be altered using the $\underline {\text { ALTER SEQUENCE }}$ command. _________________________

A synonym can be created for any database object such as a table or sequence.

When creating a sequence, which of the following is not an optional clause?

Pre-generated sequence numbers that have not been used when the database is shut down will no longer be available when the database is restarted.

The $\underline { \text { CYCLE } }$ option prevents a sequence from regenerating previous values. _________________________

Which command will create a synonym for a table?

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

Which of the following contains the ROWID of referenced rows?

An index is implicitly created whenever a(n) $\underline {\text { CHECK } }$ constraint is created for a table column. _________________________

A sequence serves as a nickname for a database object.

A sequence can be used to speed up row retrieval.

Which of the following commands can be used to modify an index?

If more than ____________________ percent of a table is expected to be returned in the results of a query, then an index will probably not speed up the process.

Which command will delete a sequence?

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

The NOCACHE option specifies that the sequence can generate a number only after a request has been made by a user.

The lowest possible value for an increasing sequence is 1.‾\underline { 1 . }1.​ . _________________________

An index can be created ____.

The starting value for a sequence cannot be changed using the ____________________ SEQUENCE command.

The START WITH clause of a sequence cannot be reset with the ALTER SEQUENCE command.

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

Sequence settings can be altered using the ALTER SEQUENCE ‾\underline {\text { ALTER SEQUENCE }} ALTER SEQUENCE ​ command. _________________________

A synonym can be created for any database object such as a table or sequence.

When creating a sequence, which of the following is not an optional clause?

Pre-generated sequence numbers that have not been used when the database is shut down will no longer be available when the database is restarted.

The CYCLE ‾\underline { \text { CYCLE } } CYCLE ​ option prevents a sequence from regenerating previous values. _________________________

Which command will create a synonym for a table?

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

Which of the following contains the ROWID of referenced rows?

An index is implicitly created whenever a(n) CHECK ‾\underline {\text { CHECK } } CHECK ​ constraint is created for a table column. _________________________

A sequence serves as a nickname for a database object.

A sequence can be used to speed up row retrieval.

Which of the following commands can be used to modify an index?

If more than ____________________ percent of a table is expected to be returned in the results of a query, then an index will probably not speed up the process.

Which command will delete a sequence?

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

The lowest possible value for an increasing sequence is $\underline { 1 . }$ . _________________________

Sequence settings can be altered using the $\underline {\text { ALTER SEQUENCE }}$ command. _________________________

The $\underline { \text { CYCLE } }$ option prevents a sequence from regenerating previous values. _________________________

An index is implicitly created whenever a(n) $\underline {\text { CHECK } }$ constraint is created for a table column. _________________________