Which three are valid ways to minimize dependency failure? (Choose three)
A.
Querying with the SELECT * notification.
B.
Declaring variables with the %TYPE attribute.
C.
Specifying schema names when referencing objects.
D.
Declaring records by using the %ROWTYPE attribute.
E.
Specifying package.procedure notation while executing procedures.
Explanation:
A: Use the SELECT * notation. This will minimize recompilation failures because SELECT *
will select all the columns of the table. If you add or remove any column from the table,
the SELECT statement will not be impacted by the change in the table and will require no
changes to the program unit.
B, D: Use the %ROWTYPE to declare records and %TYPE to declare variables. This allows you
to declare records and variables that inherit the data types of the underlying columns of the base
tables, rather than defining the data type of each variable in the program unit. The %ROWTYPE
and %TYPE attributes provide you the flexibility to change the data types of the columns of the
table without having to modify the data types specified in the program unit.