View Exhibit1 and examine the structure of the EMPLOYEES table. View Exhibit2 and examine the code in the PL/SQL block. The PL/SQL block fails to execute. What could be the reason?

Question

Exhibits

Options

• ANested tables cannot be returned by a function.
• BThe NEWNAMES nested table has not been initialized.
• CThe assignment operator cannot be used to transfer all the element values from GROUP1 to GROUP2.
• DThe third element of OLDNAMES cannot be assigned to the third element of GROUP1 because they
• ELAST_NAME values cannot be assigned to the V_LAST_NAMES nested table because local collection

• A
  3% (2)
• B
  12% (7)
• C
  5% (3)
• D
  2% (1)
• E
  78% (46)

No community discussion yet for this question.