Question 1

Discuss the purpose of the UTL_MAIL package and identify at least five parameters available in the package.

Accepted Answer

The UTL_MAIL package enable emails to be

Question 2

____ frees the resources allocated to the cursor.

Accepted Answer

A)  EXIT_CURSOR 
B)  FETCH_ROWS 
C)  EXECUTE 
D)  CLOSE_CURSOR 
A)  EXIT_CURSOR 
B)  FETCH_ROWS 
C)  EXECUTE 
D)  CLOSE_CURSOR

Question 3

Two methods can be used to implement _________________________: EXECUTE IMMEDIATE and OPEN FOR.

Accepted Answer

The answer of Two methods can be used to implement...

Question 4

The process flow of the DBMS_SQL procedures involves the establishment of a(n) ____ to contain and manipulate the SQL statement.

Accepted Answer

A)  BIND_VARIABLE 
B)  object type 
C)  cursor 
D)  DML statement 
A)  BIND_VARIABLE 
B)  object type 
C)  cursor 
D)  DML statement

Question 5

A large object (LOB) can hold ____.

Accepted Answer

A)  1 GB 
B)  2 GB 
C)  3 GB 
D)  4 GB 
A)  1 GB 
B)  2 GB 
C)  3 GB 
D)  4 GB

Discuss the purpose of the UTL_MAIL package and identify at least five parameters available in the package.

____ frees the resources allocated to the cursor.