Examine the structure of the EMPLOYEES table in the SCOTT schema.
Name Null? Type
———————– ————— —————
EMPLOYEE_ID NOT NULL NUMBER(6)
FIRST_NAME VARCHAR2(20)
LAST_NAME NOT NULL VARCHAR2(25)
SALARY NOT NULL NUMBER(8,2)
COMMISSION_PCT NUMBER(2,2)
DEPARTMENT_ID NUMBER(4)
View the Exhibit and examine the code for the EMP_TOTSAL procedure created by user SCOTT.
Which statement is true regarding the EMP_TOTSAL procedure?
A.
It is created successfully, but displays the correct output message only for existent employee
IDs.
B.
It is created successfully and displays the correct output message for both existent and
nonexistent employee IDs.
C.
It generates an error because the %NOTFOUND attribute cannot be used in combination with
a SELECT INTO statement.
D.
It generates an error because a user-defined exception has to be included whenever the
%NOTFOUND attribute is used in combination with a SELECT INTO statement.
A