Question 1

The UTL_LINE package allows access to files that reside on an operating system and are accessible from the database server. _________________________

Accepted Answer

A) True 
 B)False

Question 2

In which of the following situations is the use of native dynamic SQL considered inappropriate?

Accepted Answer

A)  The number and types of columns to be used is not known. 
B)  The number and type of bind variables is known. 
C)  You want to perform DDL. 
D)  You are executing the statement only once or twice.

Question 3

The ____ package allows access to two DDL statements that cannot be used directly within a PL/SQL block: ALTER_COMPILE and ANALYZE_OBJECT.

Accepted Answer

A)  DBMS_PIPE 
B)  DBMS_SQL 
C)  DBMS_DDL 
D)  DBMS_JOB

Question 4

The array-like processing available in DBMS_SQL makes working with many rows much more cumbersome.

Accepted Answer

A) True 
 B)False

Question 5

The _________________________ action of the DBMS_DDL package computes statistics on a database object, typically tables and indexes, such as the range of values.

Accepted Answer

The answer of The _________________________ action of the DBMS_DDL package...

Question 6

The code fragment ____ would raise an error.

Accepted Answer

A)  DBMS_ALERT.REGISTER( 'new_bid' ); 
B)  DBMS_ALERT.WAITONE( 'new_bid', v_msg, v_status, 600); 
C)  DBMS_ALERT( 'new_bid', v_msg, v_status, 600); 
D)  DBMS_ALERT.SIGNAL( 'new_bid', TO_CHAR(:new.bid));

Question 7

DBMS_DDL.ALTER_COMPILE (
Type VARCHAR2,
Schema VARCHAR2,
Name VARCHAR2);
In the header for the ALTER_COMPILE procedure above, the ____ statement refers to the object's owner.

Accepted Answer

A)  type 
B)  schema 
C)  name 
D)  ALTER

Question 8

In the DBMS_LOB package, the term ____ represents programs that read LOBs or information about the LOBs.

Accepted Answer

A)  Mutator 
B)  Tablespace 
C)  BFILE 
D)  Observer

Question 9

When executing a stored program, any DBMS_OUTPUT lines are placed in an output buffer, which dumps its contents to the screen when the program has completed execution. _________________________

Accepted Answer

A) True 
 B)False

Question 10

The util.ora file contains environment settings, such as the UTL_FILE_DIR parameter, that determine if and how certain Oracle features are accessible from within PL/SQL code.

Accepted Answer

A) True 
 B)False

Question 11

In the DBMS_DDL package, ____ is a valid ANALYZE_OBJECT exception.

Accepted Answer

A)  ORA-20000 
B)  ORA-20002 
C)  ORA-20003 
D)  ORA-20004

Question 12

All of the following procedures are included in the DBMS_ALERT package, except ____.

Accepted Answer

A)  REGISTER 
B)  SIGNAL 
C)  WAIT 
D)  WAITONE

Question 13

What is the goal of dynamic SQL?

Accepted Answer

The answer of What is the goal of dynamic SQL?...

Question 14

The ____ built-in package retrieves information about database objects.

Accepted Answer

A)  DBMS_JAVA 
B)  DBMS_METADATA 
C)  DBMS_RANDOM 
D)  DBMS_SESSION

Question 15

Which of the following is the correct syntax for an EXECUTE IMMEDIATE statement?

Accepted Answer

A)  EXECUTE IMMEDIATE 'SQL statement'
[ INTO ( var1, var2, ... | record ]
[ USING [ IN | OUT | IN OUT ] bindvar1, bindvar2, ... ]
[ RETURNING | RETURN INTO outvar1, outvar2, ... ]; 
B)  EXECUTE IMMEDIATE 'SQL statement'
[ INTO ( var1, var2, ... | record ]
[ RETURNING | RETURN INTO outvar1, outvar2, ... ] 
C)  EXECUTE IMMEDIATE 'SQL statement'
[ INTO ( var1, var2, ... | record ]
[ USING [ IN | OUT | IN OUT ] bindvar1, bindvar2, ... ] 
D)  EXECUTE IMMEDIATE 'SQL statement'
[ USING [ IN | OUT | IN OUT ] bindvar1, bindvar2, ... ]
[ RETURNING | RETURN INTO outvar1, outvar2, ... ];

Question 16

____ establishes a work area for a statement to be handled.

Accepted Answer

A)  OPEN_CURSOR 
B)  PARSE 
C)  CLOSE_CURSOR 
D)  CLOSE_PARSER

Question 17

The UTL_HTTP package provides the capability to make Hypertext Transfer Protocol (HTTP) calls from within PL/SQL programs. _________________________

Accepted Answer

A) True 
 B)False

Question 18

Describe the basic mechanics of the alert process.

Accepted Answer

The answer of Describe the basic mechanics of the alert...

Question 19

A(n) _________________________ is a pointer to a cursor or SQL work area.

Accepted Answer

The answer of A(n) _________________________ is a pointer to a...

Question 20

The basic mechanics of the alert process include registering an alert name, setting up when an alert should signal, and enabling the appropriate users to receive the alert.

Accepted Answer

A) True 
 B)False

Exam 10: Oracle-Supplied Packages, Dynamic SQL, and Hiding Source Code

The UTL_LINE package allows access to files that reside on an operating system and are accessible from the database server. _________________________

In which of the following situations is the use of native dynamic SQL considered inappropriate?

The ____ package allows access to two DDL statements that cannot be used directly within a PL/SQL block: ALTER_COMPILE and ANALYZE_OBJECT.

The array-like processing available in DBMS_SQL makes working with many rows much more cumbersome.

The _________________________ action of the DBMS_DDL package computes statistics on a database object, typically tables and indexes, such as the range of values.

The code fragment ____ would raise an error.

DBMS_DDL.ALTER_COMPILE ( Type VARCHAR2, Schema VARCHAR2, Name VARCHAR2) ; In the header for the ALTER_COMPILE procedure above, the ____ statement refers to the object's owner.

In the DBMS_LOB package, the term ____ represents programs that read LOBs or information about the LOBs.

When executing a stored program, any DBMS_OUTPUT lines are placed in an output buffer, which dumps its contents to the screen when the program has completed execution. _________________________

The util.ora file contains environment settings, such as the UTL_FILE_DIR parameter, that determine if and how certain Oracle features are accessible from within PL/SQL code.

In the DBMS_DDL package, ____ is a valid ANALYZE_OBJECT exception.

All of the following procedures are included in the DBMS_ALERT package, except ____.

What is the goal of dynamic SQL?

The ____ built-in package retrieves information about database objects.

Which of the following is the correct syntax for an EXECUTE IMMEDIATE statement?

____ establishes a work area for a statement to be handled.

The UTL_HTTP package provides the capability to make Hypertext Transfer Protocol (HTTP) calls from within PL/SQL programs. _________________________

Describe the basic mechanics of the alert process.

A(n) _________________________ is a pointer to a cursor or SQL work area.

The basic mechanics of the alert process include registering an alert name, setting up when an alert should signal, and enabling the appropriate users to receive the alert.