Question 1

After the highest possible value for a sequence has been reached,previous values can be reused if the NOCYCLE option has been specified.

Accepted Answer

A) True 
 B)False  False

Question 2

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

Question 3

Which command will create a synonym for a table?​

Accepted Answer

A)  ​CREATE SYNONYM synonymname IN tablename; 
B)  ​CREATE SYNONYM synonymname ON tablename; 
C)  ​CREATE SYNONYM synonymname REFERENCE tablename; 
D)  ​CREATE SYNONYM synonymname FOR tablename; 
A)  ​CREATE SYNONYM synonymname IN tablename; 
B)  ​CREATE SYNONYM synonymname ON tablename; 
C)  ​CREATE SYNONYM synonymname REFERENCE tablename; 
D)  ​CREATE SYNONYM synonymname FOR tablename; D

Question 4

A sequence serves as a nickname for a database object.​

Accepted Answer

A) True 
 B)False

Question 5

A sequence can be used to speed up row retrieval.​

Accepted Answer

A) True 
 B)False

Question 6

The ____________________ clause identifies the lowest value a sequence can generate.

Accepted Answer

The answer of The ____________________ clause identifies the lowest value...

Question 7

Which of the following contains the ROWID of referenced rows?​

Accepted Answer

A)  ​sequence 
B)  ​index 
C)  ​private synonym 
D)  ​public synonym 
A)  ​sequence 
B)  ​index 
C)  ​private synonym 
D)  ​public synonym

Question 8

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 9

A(n)____ synonym is used by an individual to reference objects owned by that person.​

Accepted Answer

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

Question 10

​The ____________________ value of a sequence cannot be changed if the sequence has already generated a number greater than that value.

Accepted Answer

The answer of ​The ____________________ value of a sequence cannot...

Question 11

A sequence value may be set as a DEFAULT value for a column.​

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

A(n)____ generates sequential integers that can be used by organizations to assist with internal controls or simply to serve as a primary key for a table.​

Accepted Answer

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

Question 14

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 15

When creating a sequence,which of the following is not an optional clause?​

Accepted Answer

A)  ​INCREMENT BY value 
B)  ​CYCLE | NOCYCLE 
C)  ​MAXVALUE value | NOMAXVALUE 
D)  ​CREATE SEQUENCE 
A)  ​INCREMENT BY value 
B)  ​CYCLE | NOCYCLE 
C)  ​MAXVALUE value | NOMAXVALUE 
D)  ​CREATE SEQUENCE

Question 16

A(n)index can be used to generate a series of unique numbers._________________________​

Accepted Answer

A) True 
 B)False

Question 17

Which of the following can be used to remove an index that currently exists on the column of a database table?​

Accepted Answer

A)  ​ALTER TABLE...DROP 
B)  ​ALTER TABLE...MODIFY 
C)  ​DROP INDEX 
D)  ​DELETE INDEX 
A)  ​ALTER TABLE...DROP 
B)  ​ALTER TABLE...MODIFY 
C)  ​DROP INDEX 
D)  ​DELETE INDEX

Question 18

Which of the following is defined in Oracle12c as simply anything that has a name and a defined structure?

Accepted Answer

A)  ​object 
B)  index 
C)  synonym 
D)  sequence 
A)  ​object 
B)  index 
C)  synonym 
D)  sequence

Question 19

Which of the following serves the same basic purpose as an index in a book,by allowing users to quickly locate specific records?​

Accepted Answer

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

Question 20

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

After the highest possible value for a sequence has been reached,previous values can be reused if the NOCYCLE option has been specified.

Which of the following statements about sequences is incorrect?

Which command will create a synonym for a table?

A sequence serves as a nickname for a database object.

A sequence can be used to speed up row retrieval.

The ____________________ clause identifies the lowest value a sequence can generate.

Which of the following contains the ROWID of referenced rows?

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

A(n)____ synonym is used by an individual to reference objects owned by that person.

The ____________________ value of a sequence cannot be changed if the sequence has already generated a number greater than that value.

A sequence value may be set as a DEFAULT value for a column.

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

A(n)____ generates sequential integers that can be used by organizations to assist with internal controls or simply to serve as a primary key for a table.

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

When creating a sequence,which of the following is not an optional clause?

A(n)index can be used to generate a series of unique numbers._________________________

Which of the following can be used to remove an index that currently exists on the column of a database table?

Which of the following is defined in Oracle12c as simply anything that has a name and a defined structure?

Which of the following serves the same basic purpose as an index in a book,by allowing users to quickly locate specific records?

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

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

After the highest possible value for a sequence has been reached,previous values can be reused if the NOCYCLE option has been specified.

Which of the following statements about sequences is incorrect?​

Which command will create a synonym for a table?​

A sequence serves as a nickname for a database object.​

A sequence can be used to speed up row retrieval.​

The ____________________ clause identifies the lowest value a sequence can generate.

Which of the following contains the ROWID of referenced rows?​

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

A(n)____ synonym is used by an individual to reference objects owned by that person.​

​The ____________________ value of a sequence cannot be changed if the sequence has already generated a number greater than that value.

A sequence value may be set as a DEFAULT value for a column.​

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

A(n)____ generates sequential integers that can be used by organizations to assist with internal controls or simply to serve as a primary key for a table.​

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

When creating a sequence,which of the following is not an optional clause?​

A(n)index can be used to generate a series of unique numbers._________________________​

Which of the following can be used to remove an index that currently exists on the column of a database table?​

Which of the following is defined in Oracle12c as simply anything that has a name and a defined structure?

Which of the following serves the same basic purpose as an index in a book,by allowing users to quickly locate specific records?​

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

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 of the following statements about sequences is incorrect?

Which command will create a synonym for a table?

A sequence serves as a nickname for a database object.

A sequence can be used to speed up row retrieval.

Which of the following contains the ROWID of referenced rows?

A(n)____ synonym is used by an individual to reference objects owned by that person.

The ____________________ value of a sequence cannot be changed if the sequence has already generated a number greater than that value.

A sequence value may be set as a DEFAULT value for a column.

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

A(n)____ generates sequential integers that can be used by organizations to assist with internal controls or simply to serve as a primary key for a table.

When creating a sequence,which of the following is not an optional clause?

A(n)index can be used to generate a series of unique numbers._________________________

Which of the following can be used to remove an index that currently exists on the column of a database table?

Which of the following serves the same basic purpose as an index in a book,by allowing users to quickly locate specific records?