Triggers in PL/SQL can be: Statement-level. Row-level. Block-level.
We can use single-line and multiline comments in PL/SQL. True or False? True False.
There are no composite data types in PL/SQL. True or False? True False.
Blocks in PL/SQL: Cannot be nested. Can be nested as needed. Can only be nested at one level.
In a row trigger, we cannot access the table on which the trigger is defined because it is mutating. True or False? True False.
Among other features, PL/SQL allows: Executing functions and procedures in our programs through sophisticated drivers. Reducing network traffic in client-server environments. The functionality of SQL and the power of a declarative language.
Error management in PL/SQL We cannot control it since we will never know the errors that can occur. It is controlled by the compiler. It is controlled through exceptions.
We can define triggers when inserting but not when deleting. True or False? True False.
In PL/SQL, we can use different notations when passing parameters to subprograms: We can only use named notation. We can only use positional notation. No, we cannot pass parameters to subprograms. We can use both positional and named notation.
Indicate which of the following statements referring to VARRAY is correct. We can delete elements from a VARRAY. LAST and COUNT will always return the same value. COUNT and LIMIT will always return the same value.
|
