Question 1

A sequence can be deleted from the database using the $\underline { \text { DROP SEQUENCE } }$ command. _________________________

Accepted Answer

A) True 
 B)False

Question 2

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 3

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 4

All synonyms are PUBLIC.

Accepted Answer

A) True 
 B)False

Question 5

The ____________________ option is used to indicate that the values assigned by a sequence can be used after the maximum value is reached.

Accepted Answer

The answer of The ____________________ option is used to indicate...

Question 6

An _________________________ is a variant of the B-tree index structure and is used as an alternative to the conventional heap-organized table.

Accepted Answer

Index Orga

Question 7

An index is not implicitly created when which type of constraint is created?

Accepted Answer

A)  NOT NULL 
B)  UNIQUE 
C)  PRIMARY KEY 
D)  none of the above 
A)  NOT NULL 
B)  UNIQUE 
C)  PRIMARY KEY 
D)  none of the above

Question 8

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 9

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 10

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 11

Which of the following is defined in Oracle11g 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 12

The $\underline { \text { CURRVAI } }$ pseudocolumn is used to generate the next value in a sequence. _________________________

Accepted Answer

A) True 
 B)False

A sequence can be deleted from the database using the $\underline { \text { DROP SEQUENCE } }$ command. _________________________

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

Which of the following is a pseudocolumn?

All synonyms are PUBLIC.

The ____________________ option is used to indicate that the values assigned by a sequence can be used after the maximum value is reached.

An _________________________ is a variant of the B-tree index structure and is used as an alternative to the conventional heap-organized table.

An index is not implicitly created when which type of constraint is created?

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

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

The purpose of an index is to ____.

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

The $\underline { \text { CURRVAI } }$ pseudocolumn is used to generate the next value in 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

A sequence can be deleted from the database using the DROP SEQUENCE ‾\underline { \text { DROP SEQUENCE } } DROP SEQUENCE ​ command. _________________________

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

Which of the following is a pseudocolumn?

All synonyms are PUBLIC.

The ____________________ option is used to indicate that the values assigned by a sequence can be used after the maximum value is reached.

An _________________________ is a variant of the B-tree index structure and is used as an alternative to the conventional heap-organized table.

An index is not implicitly created when which type of constraint is created?

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

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

The purpose of an index is to ____.

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

The CURRVAI ‾\underline { \text { CURRVAI } } CURRVAI ​ pseudocolumn is used to generate the next value in 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

A sequence can be deleted from the database using the $\underline { \text { DROP SEQUENCE } }$ command. _________________________

The $\underline { \text { CURRVAI } }$ pseudocolumn is used to generate the next value in a sequence. _________________________