Question 49:
See the Exhibit:
Examine the structure of the EMPLOYEES table in teh SCOTT schema:
Examine the code for the EMP_TOTSAL procedure created by user SCOTT. Which statement is true regarding the EMP_TOTSAL procedure?
Answer options:
A. It is created successfully but displays the correct output message only for existent employee Ids B. It is created sucessfully 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 includedd whenever the %NOTFOUND attribute is used in combination with a SELECT INTO