Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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

Question 3

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 4

A(n)index can be used to quickly determine whether a value already exists in a specific column._________________________​

Accepted Answer

A) True 
 B)False

Question 5

To create a PUBLIC synonym,the PUBLIC keyword must be used in the CREATE SYNONYM command._________________________​

Accepted Answer

A) True 
 B)False

Question 6

​Even if you created a PUBLIC synonym,you must have ____________________ privileges to delete a PUBLIC synonym.

Accepted Answer

The answer of ​Even if you created a PUBLIC synonym,you...

Question 7

Structure of the BOOKS table
   ​
-​Which of the following is not a valid statement concerning identity columns.

Accepted Answer

A)  ​A DEFAULT clause may be assigned 
B)  ​A unique constraint is automatically applied 
C)  ​Only one may be created in a table 
D)  ​Must have a numeric data type 
A)  ​A DEFAULT clause may be assigned 
B)  ​A unique constraint is automatically applied 
C)  ​Only one may be created in a table 
D)  ​Must have a numeric data type

Question 8

The ____________________ SYNONYM command is used to permanently remove a synonym from a database

Accepted Answer

The answer of The ____________________ SYNONYM command is used to...

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

The NEXTVALUE pseudocolumn is used to actually generate the next value in a sequence.​

Accepted Answer

A) True 
 B)False

Question 11

The purpose of an index is to ____.​

Accepted Answer

A)  ​speed up DML operations 
B)  ​speed up full table scans 
C)  ​efficiently determine whether a value exists in a table 
D)  ​all of the above 
A)  ​speed up DML operations 
B)  ​speed up full table scans 
C)  ​efficiently determine whether a value exists in a table 
D)  ​all of the above

Question 12

A(n)____________________ synonym can be referenced by other database users.

Accepted Answer

The answer of A(n)____________________ synonym can be referenced by other...

Question 13

The ____________________ option of a sequence indicates that a set of values are to be pre-generated by the sequence rather than wait for a user request.​

Accepted Answer

The answer of The ____________________ option of a sequence indicates...

Question 14

All synonyms are PUBLIC.

Accepted Answer

A) True 
 B)False

Question 15

If the PUBLIC keyword is not included when a synonym is created,the command will create a(n)____ synonym,by default.​

Accepted Answer

A)  ​PUBLIC 
B)  ​functional 
C)  ​private 
D)  ​objective 
A)  ​PUBLIC 
B)  ​functional 
C)  ​private 
D)  ​objective

Question 16

An index can be created with the ____________________ INDEX command.

Accepted Answer

The answer of An index can be created with the...

Question 17

If the minimum value for a sequence is not specified,then NOMINVALUE will be assumed as the default.​

Accepted Answer

A) True 
 B)False

Question 18

A database index allows users and application programs to quickly locate specific records.​

Accepted Answer

A) True 
 B)False

Question 19

The INCREMENT BY setting for a sequence cannot be changed with the ALTER SEQUENCE command._________________________

Accepted Answer

A) True 
 B)False

Question 20

By default,the START WITH clause has a value of one.​

Accepted Answer

A) True 
 B)False

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

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

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(n)index can be used to quickly determine whether a value already exists in a specific column._________________________

To create a PUBLIC synonym,the PUBLIC keyword must be used in the CREATE SYNONYM command._________________________

Even if you created a PUBLIC synonym,you must have ____________________ privileges to delete a PUBLIC synonym.

Structure of the BOOKS table -Which of the following is not a valid statement concerning identity columns.

The ____________________ SYNONYM command is used to permanently remove a synonym from a database

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

The NEXTVALUE pseudocolumn is used to actually generate the next value in a sequence.

The purpose of an index is to ____.

A(n)____________________ synonym can be referenced by other database users.

The ____________________ option of a sequence indicates that a set of values are to be pre-generated by the sequence rather than wait for a user request.

All synonyms are PUBLIC.

If the PUBLIC keyword is not included when a synonym is created,the command will create a(n)____ synonym,by default.

An index can be created with the ____________________ INDEX command.

If the minimum value for a sequence is not specified,then NOMINVALUE will be assumed as the default.

A database index allows users and application programs to quickly locate specific records.

The INCREMENT BY setting for a sequence cannot be changed with the ALTER SEQUENCE command._________________________

By default,the START WITH clause has a value of one.

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 USER_INDEXES data dictionary view can be used to verify existing indexes.________________________

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

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(n)index can be used to quickly determine whether a value already exists in a specific column._________________________​

To create a PUBLIC synonym,the PUBLIC keyword must be used in the CREATE SYNONYM command._________________________​

​Even if you created a PUBLIC synonym,you must have ____________________ privileges to delete a PUBLIC synonym.

Structure of the BOOKS table ​ -​Which of the following is not a valid statement concerning identity columns.

The ____________________ SYNONYM command is used to permanently remove a synonym from a database

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

The NEXTVALUE pseudocolumn is used to actually generate the next value in a sequence.​

The purpose of an index is to ____.​

A(n)____________________ synonym can be referenced by other database users.

The ____________________ option of a sequence indicates that a set of values are to be pre-generated by the sequence rather than wait for a user request.​

All synonyms are PUBLIC.

If the PUBLIC keyword is not included when a synonym is created,the command will create a(n)____ synonym,by default.​

An index can be created with the ____________________ INDEX command.

If the minimum value for a sequence is not specified,then NOMINVALUE will be assumed as the default.​

A database index allows users and application programs to quickly locate specific records.​

The INCREMENT BY setting for a sequence cannot be changed with the ALTER SEQUENCE command._________________________

By default,the START WITH clause has a value of one.​

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 USER_INDEXES data dictionary view can be used to verify existing indexes.________________________

A(n)index can be used to quickly determine whether a value already exists in a specific column._________________________

To create a PUBLIC synonym,the PUBLIC keyword must be used in the CREATE SYNONYM command._________________________

Even if you created a PUBLIC synonym,you must have ____________________ privileges to delete a PUBLIC synonym.

Structure of the BOOKS table -Which of the following is not a valid statement concerning identity columns.

The NEXTVALUE pseudocolumn is used to actually generate the next value in a sequence.

The purpose of an index is to ____.

The ____________________ option of a sequence indicates that a set of values are to be pre-generated by the sequence rather than wait for a user request.

If the PUBLIC keyword is not included when a synonym is created,the command will create a(n)____ synonym,by default.

If the minimum value for a sequence is not specified,then NOMINVALUE will be assumed as the default.

A database index allows users and application programs to quickly locate specific records.

By default,the START WITH clause has a value of one.