Question 1

​Which command will create an index?

Accepted Answer

A)  ​CREATE INDEX indexname IN tablename (columnname) 
B)  ​CREATE INDEX indexname REFERENCE (columnname) 
C)  ​CREATE INDEX indexname ON tablename (columnname) 
D)  ​CREATE INDEX indexname INCREMENT BY (columnname) 
A)  ​CREATE INDEX indexname IN tablename (columnname) 
B)  ​CREATE INDEX indexname REFERENCE (columnname) 
C)  ​CREATE INDEX indexname ON tablename (columnname) 
D)  ​CREATE INDEX indexname INCREMENT BY (columnname)

Question 2

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

Accepted Answer

Question 3

Oracle12c 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 4

​The default value for the INCREMENT BY clause is two._________________________

Accepted Answer

A) True 
 B)False

Question 5

Which of the following is a correct statement?​

Accepted Answer

A)  ​A PUBLIC synonym allows any user to access the specified table. 
B)  ​A PUBLIC synonym can be referenced by any user. 
C)  ​A PUBLIC synonym can only be deleted by the user that created the synonym. 
D)  ​all of the above 
A)  ​A PUBLIC synonym allows any user to access the specified table. 
B)  ​A PUBLIC synonym can be referenced by any user. 
C)  ​A PUBLIC synonym can only be deleted by the user that created the synonym. 
D)  ​all of the above

Question 6

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

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 8

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

Accepted Answer

A) True 
 B)False

Question 9

​The highest possible value for a sequence can be specified through the MAXVALUE clause.

Accepted Answer

A) True 
 B)False

Question 10

A column has low cardinality if it contains many distinct values.

Accepted Answer

A) True 
 B)False

Question 11

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 12

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

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

​A(n)index can be created based on more than one column._________________________

Accepted Answer

A) True 
 B)False

Question 15

The ____________________ SEQUENCE command can be used to permanently delete a sequence from a database.​

Accepted Answer

The answer of The ____________________ SEQUENCE command can be used...

Question 16

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 17

Which of the following sequence settings cannot be changed with the ALTER SEQUENCE command?​

Accepted Answer

A)  ​INCREMENT BY 
B)  ​START WITH 
C)  ​NOCACHE 
D)  ​NOMAXVALUE 
A)  ​INCREMENT BY 
B)  ​START WITH 
C)  ​NOCACHE 
D)  ​NOMAXVALUE

Question 18

When a negative 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 19

To verify individual settings for the clauses of a sequence,you can query the ____ table in the data dictionary.​

Accepted Answer

A)  ​USER_SEQUENCES 
B)  ​V$SEQUENCES 
C)  ​DISPLAY_SEQUENCES 
D)  ​VIEW_SEQUENCES 
A)  ​USER_SEQUENCES 
B)  ​V$SEQUENCES 
C)  ​DISPLAY_SEQUENCES 
D)  ​VIEW_SEQUENCES

Question 20

When working with cached sequence values,which of the following is correct?​

Accepted Answer

A)  ​The cache option instructs Oracle 12c to return the sequence values in the same order in which the user requests were received. 
B)  ​The cache option instructs Oracle 12c not to generate any more numbers after the minimum or maximum value has been reached. 
C)  ​When a value has been generated and cached,that value has been assigned and cannot be regenerated until the sequence begins a new cycle. 
D)  ​The highest value for a cached number is 10^44. 
A)  ​The cache option instructs Oracle 12c to return the sequence values in the same order in which the user requests were received. 
B)  ​The cache option instructs Oracle 12c not to generate any more numbers after the minimum or maximum value has been reached. 
C)  ​When a value has been generated and cached,that value has been assigned and cannot be regenerated until the sequence begins a new cycle. 
D)  ​The highest value for a cached number is 10^44.

Which command will create an index?

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

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

The default value for the INCREMENT BY clause is two._________________________

Which of the following is a correct statement?

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

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 START WITH clause of a sequence cannot be reset with the ALTER SEQUENCE command.

The highest possible value for a sequence can be specified through the MAXVALUE clause.

A column has low cardinality if it contains many distinct values.

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

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

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

A(n)index can be created based on more than one column._________________________

The ____________________ SEQUENCE command can be used to permanently delete a sequence from a database.

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 of the following sequence settings cannot be changed with the ALTER SEQUENCE command?

When a negative value is assigned to the INCREMENT BY clause of the CREATE SEQUENCE command,numeric values are generated in descending order.

To verify individual settings for the clauses of a sequence,you can query the ____ table in the data dictionary.

When working with cached sequence values,which of the following is correct?

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 command will create an index?

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

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

​The default value for the INCREMENT BY clause is two._________________________

Which of the following is a correct statement?​

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

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 START WITH clause of a sequence cannot be reset with the ALTER SEQUENCE command.

​The highest possible value for a sequence can be specified through the MAXVALUE clause.

A column has low cardinality if it contains many distinct values.

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

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

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

​A(n)index can be created based on more than one column._________________________

The ____________________ SEQUENCE command can be used to permanently delete a sequence from a database.​

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 of the following sequence settings cannot be changed with the ALTER SEQUENCE command?​

When a negative value is assigned to the INCREMENT BY clause of the CREATE SEQUENCE command,numeric values are generated in descending order.​

To verify individual settings for the clauses of a sequence,you can query the ____ table in the data dictionary.​

When working with cached sequence values,which of the following is correct?​

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 command will create an index?

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

The default value for the INCREMENT BY clause is two._________________________

Which of the following is a correct statement?

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

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

The highest possible value for a sequence can be specified through the MAXVALUE clause.

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

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

A(n)index can be created based on more than one column._________________________

The ____________________ SEQUENCE command can be used to permanently delete a sequence from a database.

Which of the following sequence settings cannot be changed with the ALTER SEQUENCE command?

When a negative value is assigned to the INCREMENT BY clause of the CREATE SEQUENCE command,numeric values are generated in descending order.

To verify individual settings for the clauses of a sequence,you can query the ____ table in the data dictionary.

When working with cached sequence values,which of the following is correct?