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

If a table contains any LOB columns, client tools such as SQL Developer cannot display the images, however, the GETLENGTH function can be used to confirm a file was loaded into the LOB column.

(True/False)

4.8/5

(30)

Question 61

In the UTL_FILE package, the ____ program unit is used to read a line from a file.

(Multiple Choice)

4.8/5

(37)

Question 62

Alerts are transaction based and are sent only if the transaction is committed. _________________________

(True/False)

4.8/5

(35)

Question 63

The _________________________ package provides the capabilities of a job scheduler that sets up programs to run at specified times.

(Short Answer)

5.0/5

(39)

Question 64

When the SQL statement is built in the PL/SQL block, placeholders with colon prefixes are used to mark where values are supplied at runtime. _________________________

(True/False)

4.9/5

(36)

Question 65

The ____ parameter of the ANALYZE_OBJECT procedure dictates that the value provided must be either TABLE, INDEX, or CLUSTER.

(Multiple Choice)

4.9/5

(34)

Question 66

In the DBMS_DDL package, the ____ procedure creates statistics for database objects to be utilized to enhance performance.

(Multiple Choice)

4.9/5

(31)

Question 67

____ will cause an error if used directly within PL/SQL.

(Multiple Choice)

4.9/5

(31)

Question 68

The programs within the ____ package can be grouped into two sets: mutators and observers.

(Multiple Choice)

4.9/5

(36)

Question 69

In the DBMS_LOB package, which of the following represents the programs that add, change, or remove the large objects (LOBs)?

(Multiple Choice)

4.8/5

(28)

Question 70

What is the difference between a mutator and an observer?

(Essay)

4.9/5

(31)

Question 71

The DBMS_ALERT package allows two or more sessions, in the same instance, to communicate. _________________________

(True/False)

4.7/5

(37)

Question 72

____ and PL/SQL allow the construction and parsing of statements at runtime rather than compile time.

(Multiple Choice)

5.0/5

(34)

Question 73

The ____ package allows parameters to be directly used as identifiers, such as column names and table names.

(Multiple Choice)

4.8/5

(37)

Question 74

All of the following except ____ require parameters.

(Multiple Choice)

4.8/5

(33)

Question 75

Which of the following is a procedure in the DBMS_DDL package that will assist to hide source code?

(Multiple Choice)

4.9/5

(40)

Question 76

The _________________________ package is used to display messages to the screen from a stored program unit or an anonymous block.

(Short Answer)

4.9/5

(38)

Question 77

Support for DBMS_SQL statements is built into the PL/SQL interpreter.

(True/False)

4.8/5

(32)

Question 78

The UTL_FILE package contains a PUT_LINE data type that is used to declare a file variable.

(True/False)

4.8/5

(32)

Question 79

To successfully compile a program, you must either own the object or you must be granted the ____ privilege to compile an object in another schema.

(Multiple Choice)

5.0/5

(32)

Question 80

Showing 61 - 80 of 85

If a table contains any LOB columns, client tools such as SQL Developer cannot display the images, however, the GETLENGTH function can be used to confirm a file was loaded into the LOB column.

In the UTL_FILE package, the ____ program unit is used to read a line from a file.

Alerts are transaction based and are sent only if the transaction is committed. _________________________

The _________________________ package provides the capabilities of a job scheduler that sets up programs to run at specified times.

When the SQL statement is built in the PL/SQL block, placeholders with colon prefixes are used to mark where values are supplied at runtime. _________________________

The ____ parameter of the ANALYZE_OBJECT procedure dictates that the value provided must be either TABLE, INDEX, or CLUSTER.

In the DBMS_DDL package, the ____ procedure creates statistics for database objects to be utilized to enhance performance.

____ will cause an error if used directly within PL/SQL.

The programs within the ____ package can be grouped into two sets: mutators and observers.

In the DBMS_LOB package, which of the following represents the programs that add, change, or remove the large objects (LOBs)?

What is the difference between a mutator and an observer?

The DBMS_ALERT package allows two or more sessions, in the same instance, to communicate. _________________________

____ and PL/SQL allow the construction and parsing of statements at runtime rather than compile time.

The ____ package allows parameters to be directly used as identifiers, such as column names and table names.

All of the following except ____ require parameters.

Which of the following is a procedure in the DBMS_DDL package that will assist to hide source code?

The _________________________ package is used to display messages to the screen from a stored program unit or an anonymous block.

Support for DBMS_SQL statements is built into the PL/SQL interpreter.

The UTL_FILE package contains a PUT_LINE data type that is used to declare a file variable.

To successfully compile a program, you must either own the object or you must be granted the ____ privilege to compile an object in another schema.

Introduction To PL/SQL

Basic PL/SQL Block Structures

Handling Data In PL/SQL Blocks

Cursors and Exception Handling

Procedures

Functions

PL/SQL Packages

Program Unit Dependencies

Database Triggers

Filters