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

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)  can not be done 
A)  the owner 
B)  the public user 
C)  a user with DBA privileges 
D)  can not be done

Question 3

Which of the following can be used to provide an alternative, simplified name, to identify database objects?

Accepted Answer

A)  view 
B)  index 
C)  synonym 
D)  sequence 
A)  view 
B)  index 
C)  synonym 
D)  sequence

Question 4

The USER_INDEXES data dictionary view can be used to verify existing indexes.

Accepted Answer

A) True 
 B)False

Question 5

An explicitly created index can be dropped with the DROP INDEX command.

Accepted Answer

A) True 
 B)False

Question 6

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 7

The keyword ____________________ must be used in a CREATE INDEX command to create a Bitmap index.

Accepted Answer

The answer of The keyword ____________________ must be used in...

Question 8

Which of the following SQL statements will delete the private synonym named MYSYNON?

Accepted Answer

A)  DROP PRIVATE SYNONYM mysynon; 
B)  DROP PUBLIC SYNONYM mysynon; 
C)  DROP SYNONYM mysynon; 
D)  DELETE PRIVATE SYNONYM mysynon; 
A)  DROP PRIVATE SYNONYM mysynon; 
B)  DROP PUBLIC SYNONYM mysynon; 
C)  DROP SYNONYM mysynon; 
D)  DELETE PRIVATE SYNONYM mysynon;

Question 9

The $\underline { \text { 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 10

The $\underline { \text { INCREMENT BY } }$ BY setting for a sequence cannot be changed with the ALTER SEQUENCE command. _________________________

Accepted Answer

A) True 
 B)False

Question 11

When a positive value is assigned to the INCREMENT BY clause of the CREATE SEQUENCE command, numeric values are generated in $\underline {\text { ascending } }$ order. _________________________

Accepted Answer

A) True 
 B)False

Question 12

Structure of the CUSTOMERS table
  
-Which of the following commands can be used to create a sequence for the CUSTOMERS table?

Accepted Answer

A)  CREATE SEQUENCE customers_customer#; 
B)  CREATE SEQUENCE customers_customer#
START WITH 2000
MAXVALUE 999; 
C)  CREATE SEQUENCE customers_customer#
INCREMENT BY -1
NOCACHE|CACHE; 
D)  all of the above 
A)  CREATE SEQUENCE customers_customer#; 
B)  CREATE SEQUENCE customers_customer#
START WITH 2000
MAXVALUE 999; 
C)  CREATE SEQUENCE customers_customer#
INCREMENT BY -1
NOCACHE|CACHE; 
D)  all of the above

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

A(n) ____________________ can be used to quickly locate specific records in a large table.

Accepted Answer

The answer of A(n) ____________________ can be used to quickly...

Question 15

By default, the lowest value that can be generated by a sequence is 0.

Accepted Answer

A) True 
 B)False

Question 16

When a sequence is created for internal control purposes, the values should not be cached otherwise gaps may appear in the sequence.

Accepted Answer

A) True 
 B)False

Question 17

The START WITH clause is used to identify the starting numeric value for a synonym.

Accepted Answer

A) True 
 B)False

Question 18

To create a PUBLIC synonym, the $\underline {\text { PUBLIC } }$ keyword must be used in the CREATE SYNONYM command. _________________________

Accepted Answer

A) True 
 B)False

Question 19

The ____________________ clause of the CREATE SEQUENCE command is used to identify the starting value for a sequence.

Accepted Answer

The answer of The ____________________ clause of the CREATE SEQUENCE...

Question 20

Both a minimum and maximum value can be defined for a(n) $\underline { \text { sequence } }$. _________________________

Accepted Answer

A) True 
 B)False

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

Who can remove a public synonym from the database?

Which of the following can be used to provide an alternative, simplified name, to identify database objects?

The USER_INDEXES data dictionary view can be used to verify existing indexes.

An explicitly created index can be dropped with the DROP INDEX command.

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

The keyword ____________________ must be used in a CREATE INDEX command to create a Bitmap index.

Which of the following SQL statements will delete the private synonym named MYSYNON?

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

The $\underline { \text { INCREMENT BY } }$ BY setting for a sequence cannot be changed with the ALTER SEQUENCE command. _________________________

When a positive value is assigned to the INCREMENT BY clause of the CREATE SEQUENCE command, numeric values are generated in $\underline {\text { ascending } }$ order. _________________________

Structure of the CUSTOMERS table -Which of the following commands can be used to create a sequence for the CUSTOMERS table?

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

A(n) ____________________ can be used to quickly locate specific records in a large table.

By default, the lowest value that can be generated by a sequence is 0.

When a sequence is created for internal control purposes, the values should not be cached otherwise gaps may appear in the sequence.

The START WITH clause is used to identify the starting numeric value for a synonym.

To create a PUBLIC synonym, the $\underline {\text { PUBLIC } }$ keyword must be used in the CREATE SYNONYM command. _________________________

The ____________________ clause of the CREATE SEQUENCE command is used to identify the starting value for a sequence.

Both a minimum and maximum value can be defined for a(n) $\underline { \text { 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?

Who can remove a public synonym from the database?

Which of the following can be used to provide an alternative, simplified name, to identify database objects?

The USER_INDEXES data dictionary view can be used to verify existing indexes.

An explicitly created index can be dropped with the DROP INDEX command.

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

The keyword ____________________ must be used in a CREATE INDEX command to create a Bitmap index.

Which of the following SQL statements will delete the private synonym named MYSYNON?

The GENERATE ‾\underline { \text { GENERATE } } GENERATE ​ option can be used to have a sequence pre-generate a set of numbers before they are requested by a user. _________________________

The INCREMENT BY ‾\underline { \text { INCREMENT BY } } INCREMENT BY ​ BY setting for a sequence cannot be changed with the ALTER SEQUENCE command. _________________________

When a positive value is assigned to the INCREMENT BY clause of the CREATE SEQUENCE command, numeric values are generated in ascending ‾\underline {\text { ascending } } ascending ​ order. _________________________

Structure of the CUSTOMERS table -Which of the following commands can be used to create a sequence for the CUSTOMERS table?

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

A(n) ____________________ can be used to quickly locate specific records in a large table.

By default, the lowest value that can be generated by a sequence is 0.

When a sequence is created for internal control purposes, the values should not be cached otherwise gaps may appear in the sequence.

The START WITH clause is used to identify the starting numeric value for a synonym.

To create a PUBLIC synonym, the PUBLIC ‾\underline {\text { PUBLIC } } PUBLIC ​ keyword must be used in the CREATE SYNONYM command. _________________________

The ____________________ clause of the CREATE SEQUENCE command is used to identify the starting value for a sequence.

Both a minimum and maximum value can be defined for a(n) sequence ‾\underline { \text { sequence } } 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 $\underline { \text { GENERATE } }$ option can be used to have a sequence pre-generate a set of numbers before they are requested by a user. _________________________

The $\underline { \text { INCREMENT BY } }$ BY setting for a sequence cannot be changed with the ALTER SEQUENCE command. _________________________

When a positive value is assigned to the INCREMENT BY clause of the CREATE SEQUENCE command, numeric values are generated in $\underline {\text { ascending } }$ order. _________________________

To create a PUBLIC synonym, the $\underline {\text { PUBLIC } }$ keyword must be used in the CREATE SYNONYM command. _________________________

Both a minimum and maximum value can be defined for a(n) $\underline { \text { sequence } }$ . _________________________