ORDER_TOTAL is a column in the orders table with the data type and size as number (8, 2) Examine the following code:

Which statement is correct about the above code?

• A. It gives an error in line 3
• B. It executes successfully and displays the output.
• C. It gives an error in line 6
• D. It gives an error in line 4

Which two statements are true about anonymous blocks and named subprograms?
(Choose two)

• A. Both anonymous blocks and subprograms execute by default with invoker's rights.
• B. The declare section is optional for both anonymous blocks and subprograms.
• C. Subprograms are by default executed with definer's rights.
• D. The declare section is mandatory for anonymous blocks and optional for subprograms.

Which two statements are true about statement-level and row-level triggers? (Choose two.)

• A. Row triggers are useful if the trigger action depends on the data of rows that are affected or on data that is provided by the triggering event itself.
• B. Statement triggers are useful if the trigger action depends on the data of rows that are affected or on data that is provided by the triggering event itself.
• C. A row trigger fires once even if no rows are affected.
• D. A statement trigger fires once even if no rows are affected.

Which two statements are true about PL/SQL exception propagation? (Choose two.)

• A. Exception- can propagate across the remote subprograms that are called through database links.
• B. If you declare a local exception in a subblock and a global exception in the outer block, the global declaration overrides the local exception.
• C. If you declare a local exception in a subblock and a global exception in the outer block, the local declaration overrides the global exception.
• D. The exception reproduces Itself In successive enclosing blocks until a handler is found.

View Exhibit1 and examine the structure of the EMP table.

View Exhibit2 and examine the PIVSQL block of code.

What is the outcome?

• A. It gives an error because the record type is not defined within the function
• B. It gives an error because the return type is not valid.
• C. It executes successfully but does not display the names and salaries of all employees who earn the highest salary.
• D. It executes successfully and displays the names and salaries of all employees who earn the highest salary.
• E. It gives an error because the function call in DBMS_OUTPUT. PUT__LINE is not valid