A.It executes successfully.

B.It gives an error because decode cannot be used in a PL/SQL block.

C.It gives an error because the AVG function cannot be used in a PL/SQL block

D.It gives an error because the MONTHS_BETWEEN function cannot be used in a PL/SQL block.

E.It gives an error because both the AVG and decode functions cannot be used in a PL/SQL block.

A.It gives an error because the variable name and column name are the same in the where clause of the select statement.

B.It gives an error because group functions cannot be used in anonymous blocks

C.It executes successfully and incorrectly gives the result of the sum of salaries in department 60.

D.It executes successfully and correctly gives the result of the sum of salaries in
department 60.

A.The code executes successfully and gives the desired output.

B.The code generates an error because the EMP_RECORD variable is not declared.

C.The code generates an error because the cursor is not opened before the FOR loop.

D.The code generates an error because the loop does not have the exit when clause.

A.It displays null if no employee with employee_id 123 exists.

B.It produces the ora-01403: no data found error if no employee with employee_id 123 exists.

C.It displays an error because the select * into clause cannot be used to populate the PL/SQL record type.

D.The code executes successfully even if no employee with employee_id 123 exists and displays Record Not Found.

A.You do not know how many columns a select statement will return, or what their data types will.

B.TheSELECTlist is not known until run time.

C.You must use the %found SQL cursor attribute after issuing a dynamic SQL statement that is an insert or update statement.

D.The dynamic SQL statement retrieves rows into records.