Bueno, en primer lugar un saludo a todo el mundo ya que soy nuevo, en segundo a ver si podéis echarme una mano con esta cuestión que me he encontrado referente a la certificación de oracle 1z0-146:
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?
Exhibit:
Options:
1. It is created successfully, but displays the correct output message only for existent employee IDs.
2. It is created successfully and displays the correct output message for both existent and nonexistent employee IDs.
3. It generates an error because the %NOTFOUND attribute cannot be used in combination with a SELECT INTO statement.
4. 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.
Según la respuesta la opción válida sería la primera pero no entiendo porque no se mostrarían los empleados cuyos ID no existen.
A ver si algunos lo sabéis. Saludos y gracias