Free 1Z0-148 Web TestEngine Demo

Q24 Single choice

The EMPLOYEES table exists in your schema and has columns LAST_NAME of data type VARCHAR2
and DEPARTMENT_ID of data type NUMBER.

There are six employees in DEPARTMENT_ID, 20.

Examine this code:

What will be the outcome on execution?

A
The execution of this code will fail with an invalid cursor error and not display either output message.
B
The number of employees will be displayed as six for both output messages.
C
The number of employees will be displayed as six for the first output message and zero for the second output message.
D
The number of employees will be displayed as six for the first output message and an invalid cursor error will be thrown instead of displaying the second output message.

1Z0-148 Web TestEngine demo