Oracle Database Advanced PL SQL 12c 1z0 148

Question : 31 of 54

Marks: +1, -0

Examine the EMPLOYEE_IDS table its data:

Examine this PL/SQL block:

What is the result of executing this PL/SQL block with SERVEROUTPUT enabled?

It executes successfully and outputs:
Fetched: 1011, JJONES, 3789
Fetched: 1012, SSMITH, -1
Compilation fails saying EMP_TAXID must be declared
An exception is thrown at runtime saying EMP_TAXID is not visible.
It executes successfully and outputs:
Fetched: 1011, JJONES,
Fetched: 1012, SSMITH,
It executes successfully and outputs:
Fetched: 1011, JJONES, -1
Fetched: 1012, SSMITH, -1

Go to Question:

Prev Question

Next Question