Oracle Database 11g: Program with PL/SQL: 1Z0-144

Which two tasks should be created as functions instead of as procedures? (Choose two.)

A. Reference host or bind variables in a PL/SQL block of code

B. Tasks that compute and return multiple values to the calling environment

C. Tasks that compute a value that must be returned to the calling environment

D. Tasks performed in SQL that increase data independence by processing complex data analysis within the Oracle server, rather than by retrieving the data into an application

Which two statements are true about the INSTEAD OF triggers? (Choose two.)

A. DELETE operations cannot be performed using the INSTEAD OF triggers.

B. The INSTEAD OF triggers must be created to add or modify data through any view.

C. The INSTEAD OF triggers can be written only for views, and the BEFORE and AFTER timing options are not valid.

D. The CHECK option for views is not enforced when insertions or updates to the view are performed by using the INSTEAD OF triggers.

View Exhibit 1 and examine the structure of the EMP table.

View Exhibit 2 and examine the PIVSQL block of code.

What is the outcome?

A. It gives an error because the return type is not valid.

B. It gives an error because the record type is not defined within the function.

C. It gives an error because the function call in DBMS_OUTPUT. PUT__LINE is not valid.

D. It executes successfully and displays the names and salaries of all employees who earn the highest salary.

E. It executes successfully but does not display the names and salaries of all employees who earn the highest salary.