Oracle Database 19c: Program with PL/SQL: 1Z0-149

Which three are true about user-defined functions? (Choose three.)

A. They can be used in ORDER BY and GROUP BY clauses.

B. They can be executed as standalone commands.

C. They must be defined with at least one parameter.

D. They need not return any values.

E. They can appear in the select list of a SELECT statement.

F. Functions can call only other functions.

G. They can be used in CONNECT BY and START WITH clauses.

Which three are true about DDL triggers? (Choose three.)

A. They cannot include the WHEN clause.

B. They must be created in an enabled state.

C. They can be fired when a table is truncated.

D. They fire only when a DDL statement is executed by the owner of the trigger.

E. They can be fired either before or after a DDL statement executes.

F. They can be fired when a privilege is granted to a user.

G. They must be created in a disabled state.

Examine the SH.PRODUCTS table:

A row exists in SH.PRODUCTS with PDT_ID = 1. Now, examine this code and output executed by SH:

Now, examine this block of code:

Which error message(s) does it display on execution by user SH?

A. Error in inner block

B. Error in inner block Error in outer block

C. Error in inner block Error in calling block

D. Error in inner block Error in outer block Error in calling block