Question 1

​Which options are used in application cluster environments where multiple users may be requesting sequence values at the same time?

Accepted Answer

Question 2

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 Oracle 12c 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 Oracle 12c 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 3

Which of the following is a valid SQL statement when referencing a sequence?

Accepted Answer

A)  ​INSERT INTO orderitems
VALUES (currval,1,811794939,1);​ 
B)  ​INSERT INTO orderitems
VALUES (currentval,1,811794939,1);​ 
C)  ​INSERT INTO orderitems
VALUES (nextvalue,1,811794939,1);​ 
D)  none of the above 
A)  ​INSERT INTO orderitems
VALUES (currval,1,811794939,1);​ 
B)  ​INSERT INTO orderitems
VALUES (currentval,1,811794939,1);​ 
C)  ​INSERT INTO orderitems
VALUES (nextvalue,1,811794939,1);​ 
D)  none of the above

Question 4

A(n)____ synonym is used by others to access an individual's database objects.

Accepted Answer

A)  ​unique 
B)  ​duplicated 
C)  ​public 
D)  ​private 
A)  ​unique 
B)  ​duplicated 
C)  ​public 
D)  ​private

Question 5

Which of the following commands is used to create a function-based index?

Accepted Answer

A)  CREATE FUNCTION INDEX...ON 
B)  CREATE INDEX...ON 
C)  CREATE INDEX....FOR 
D)  CREATE INDEX...FUNCTION 
A)  CREATE FUNCTION INDEX...ON 
B)  CREATE INDEX...ON 
C)  CREATE INDEX....FOR 
D)  CREATE INDEX...FUNCTION

Question 6

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

Accepted Answer

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

Question 7

​What are the benefits and disadvantages of an index?

Accepted Answer

An index can help speed up row retrieval

Question 8

Who can remove a public synonym from the database?

Accepted Answer

A)  the owner 
B)  the public user 
C)  a user with DBA privileges 
D)  cannot be done 
A)  the owner 
B)  the public user 
C)  a user with DBA privileges 
D)  cannot be done

Question 9

The USER_SEQ data dictionary view can be used to verify sequence settings._________________________​

Accepted Answer

A) True 
 B)False

Question 10

​Sequence settings can be altered using the ALTER SEQUENCE command._________________________

Accepted Answer

A) True 
 B)False

Question 11

A synonym is an alternate name assigned to a database object.​

Accepted Answer

A) True 
 B)False

Question 12

Which of the following is a pseudocolumn?

Accepted Answer

A)  CURRENTVAL 
B)  DUAL 
C)  NEXTVAL 
D)  both a and c 
A)  CURRENTVAL 
B)  DUAL 
C)  NEXTVAL 
D)  both a and c

Question 13

​The USER_SEQUENCES view of the data dictionary can be used to determine the current values and settings for a sequence.

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

Which of the following statements about indexes is incorrect?

Accepted Answer

A)  An index is a database object that stores a frequently referenced value and the row id (ROWI
D) of the record containing that value. 
B)  An index is only beneficial if a large percentage of a table is expected to be returned in query results. 
C)  An index is used to speed up the process of searching for specific data. 
D)  An index is updated automatically every time a DML operation is performed on the 
A)  An index is a database object that stores a frequently referenced value and the row id (ROWI
D) of the record containing that value. 
B)  An index is only beneficial if a large percentage of a table is expected to be returned in query results. 
C)  An index is used to speed up the process of searching for specific data. 
D)  An index is updated automatically every time a DML operation is performed on the

Question 16

To remove a PUBLIC synonym,you must include the ____ keyword in the DROP command.​

Accepted Answer

A)  ​DEFAULT 
B)  ​DBA 
C)  ​PUBLIC 
D)  ​none of the above 
A)  ​DEFAULT 
B)  ​DBA 
C)  ​PUBLIC 
D)  ​none of the above

Question 17

​A(n)____________________ can be used for internal control purposes by generating a series of numbers.

Accepted Answer

The answer of ​A(n)____________________ can be used for internal control...

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

The GENERATE option can be used to have a sequence pre-generate a set of numbers before they are requested by a user._________________________

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

Which options are used in application cluster environments where multiple users may be requesting sequence values at the same time?

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

Which of the following is a valid SQL statement when referencing a sequence?

A(n)____ synonym is used by others to access an individual's database objects.

Which of the following commands is used to create a function-based index?

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

What are the benefits and disadvantages of an index?

Who can remove a public synonym from the database?

The USER_SEQ data dictionary view can be used to verify sequence settings._________________________

Sequence settings can be altered using the ALTER SEQUENCE command._________________________

A synonym is an alternate name assigned to a database object.

Which of the following is a pseudocolumn?

The USER_SEQUENCES view of the data dictionary can be used to determine the current values and settings for a sequence.

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

Which of the following statements about indexes is incorrect?

To remove a PUBLIC synonym,you must include the ____ keyword in the DROP command.

A(n)____________________ can be used for internal control purposes by generating a series of numbers.

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

The GENERATE option can be used to have a sequence pre-generate a set of numbers before they are requested by a user._________________________

Which of the following is used to establish a minimum or maximum value,respectively,for 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

​Which options are used in application cluster environments where multiple users may be requesting sequence values at the same time?

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

Which of the following is a valid SQL statement when referencing a sequence?

A(n)____ synonym is used by others to access an individual's database objects.

Which of the following commands is used to create a function-based index?

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

​What are the benefits and disadvantages of an index?

Who can remove a public synonym from the database?

The USER_SEQ data dictionary view can be used to verify sequence settings._________________________​

​Sequence settings can be altered using the ALTER SEQUENCE command._________________________

A synonym is an alternate name assigned to a database object.​

Which of the following is a pseudocolumn?

​The USER_SEQUENCES view of the data dictionary can be used to determine the current values and settings for a sequence.

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

Which of the following statements about indexes is incorrect?

To remove a PUBLIC synonym,you must include the ____ keyword in the DROP command.​

​A(n)____________________ can be used for internal control purposes by generating a series of numbers.

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

The GENERATE option can be used to have a sequence pre-generate a set of numbers before they are requested by a user._________________________

Which of the following is used to establish a minimum or maximum value,respectively,for 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

Which options are used in application cluster environments where multiple users may be requesting sequence values at the same time?

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

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

What are the benefits and disadvantages of an index?

The USER_SEQ data dictionary view can be used to verify sequence settings._________________________

Sequence settings can be altered using the ALTER SEQUENCE command._________________________

A synonym is an alternate name assigned to a database object.

The USER_SEQUENCES view of the data dictionary can be used to determine the current values and settings for a sequence.

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

To remove a PUBLIC synonym,you must include the ____ keyword in the DROP command.

A(n)____________________ can be used for internal control purposes by generating a series of numbers.

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

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