1Z0-146 · Question #34
Examine the structure of the EMPLOYEES table that exists in your schema. Name Null? Type ---------------- ----------- -------------- EMPLOYEE_ID NOT NULL NUMBER(6) FIRST_NAME VARCHAR2(20) LAST_NAME…
The correct answer is A. It executes successfully and gives the required output. See the full explanation below for the reasoning.
Question
Examine the structure of the EMPLOYEES table that exists in your schema. Name Null? Type ---------------- ----------- -------------- EMPLOYEE_ID NOT NULL NUMBER(6) FIRST_NAME VARCHAR2(20) LAST_NAME NOT NULL VARCHAR2(25) JOB_ID NOT NULL VARCHAR2(10) SALARY NUMBER(8,2) COMMISSION_PCT NUMBER(2,2) DEPARTMENT_ID NUMBER(4) You successfully create a GET_MAX procedure to find the maximum salary in the department of a specified employee. You then code a PL/SQL block to display the maximum salary in the departments of the first five employees in the EMPLOYEES table. View the Exhibit. Examine the procedure and the block of PL/SQL code. What is the outcome of executing the block of PL/SQL code?
Exhibit
Options
- AIt executes successfully and gives the required output.
- BIt gives an error because ROWNUM cannot be used in cursor definitions.
- CIt gives an error because usage of the %ROWCOUNT attribute is not valid.
- DIt executes successfully, but does not give the required output because the procedure call resets
How the community answered
(51 responses)- A78% (40)
- B4% (2)
- C12% (6)
- D6% (3)
Community Discussion
No community discussion yet for this question.