Question 1

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

Accepted Answer

Question 2

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

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 
A)  START WITH 
B)  INTERVAL SIZE 
C)  INCREMENT BY 
D)  VALUE START

Question 5

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 
A)  NOMAXVALUE 
B)  CYCLE 
C)  INCREMENT BY 5 
D)  MAXVALUE 200

Question 6

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 7

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

Accepted Answer

One aim of internal control is to ensure

Question 8

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 9

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 
A)  sequence 
B)  index 
C)  synonym 
D)  schema alias

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

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 
A)  INTERVAL SIZE 
B)  INCREMENT BY 
C)  STEP BY 
D)  START WITH

Question 13

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

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_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 15

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

Question 16

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

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

Accepted Answer

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

Question 18

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 19

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

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

Accepted Answer

A) True 
 B)False

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

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

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

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

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?

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

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

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

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?

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

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

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

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

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

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

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

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

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

Which of the following statements about sequences is incorrect?

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

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

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

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

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

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

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?

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

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

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

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?

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

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

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

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

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

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

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

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

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

Which of the following statements about sequences is incorrect?

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

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 synonym is an alternate name assigned to database $\underline { \text { instances } }$ . _________________________