1Z0-146 · Question #57
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…
The correct answer is A. It is created successfully, but displays the correct output message only for existent employee IDs. See the full explanation below for the reasoning.
Question
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
- AIt is created successfully, but displays the correct output message only for existent employee IDs.
- BIt is created successfully and displays the correct output message for both existent and nonexistent
- CIt generates an error because the %NOTFOUND attribute cannot be used in combination with a
- DIt generates an error because a user-defined exception has to be included whenever the %NOTFOUND
How the community answered
(26 responses)- A85% (22)
- B4% (1)
- C8% (2)
- D4% (1)
Community Discussion
No community discussion yet for this question.