View the Exhibit and examine the structure of the employees table. Examine the following block of code: What is the outcome when the above code is executed?

Question

Exhibits

Options

• AIt executes successfully.
• BIt gives an error because decode cannot be used in a PL/SQL block.
• CIt gives an error because the AVG function cannot be used in a PL/SQL block
• DIt gives an error because the MONTHS_BETWEEN function cannot be used in a PL/SQL block.
• EIt gives an error because both the AVG and decode functions cannot be used in a PL/SQL block.

• A
  74% (20)
• B
  4% (1)
• D
  15% (4)
• E
  7% (2)

No community discussion yet for this question.