ExamQuestions.com

Register
Login
Oracle Database 11g Advanced PLSQL Exam Questions

Oracle

Oracle Database 11g Advanced PLSQL

49 / 68

Question 49:

See the Exhibit: 
image
Examine the structure of the EMPLOYEES table in teh SCOTT schema: 
image
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