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.
A) type
B) schema
C) name
D) ALTER

Question

Quizplus · Accepted Answer

The schema parameter in the header of the ALTER_COMPILE procedure refers to the object's owner. The type parameter refers to the type of object being altered (e.g. table, view, trigger) and the name parameter refers to the name of the object being altered. The ALTER keyword is not a parameter but rather a keyword indicating that a change is being made to an existing object.

DBMS_DDL.ALTER_COMPILE ( Type VARCHAR2