Examine the following PL/SQL code: The server output is on for the session. Which statement is true about the execution of the code?

Question

Exhibit

Options

• AIt displays null if no employee with employee_id 123 exists.
• BIt produces the ora-01403: no data found error if no employee with employee_id 123 exists.
• CIt displays an error because the select into clause cannot be used to populate the PL/SQL record
• DThe code executes successfully even if no employee with employee_id 123 exists and displays

• A
  9% (3)
• B
  84% (27)
• C
  3% (1)
• D
  3% (1)

No community discussion yet for this question.