1Z0-146 Real Exam Questions

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?

To examine the dependencies between all PL/SQL objects and the tables and views they reference, you executed the following query as the user OE: SQL> SELECT owner || '.' || NAME refs_table , referenced_owner || '.' || referenced_name AS table_referenced FROM all_dependencies WHERE owner = USER AND TYPE IN ('PACKAGE', 'PACKAGE BODY','PROCEDURE', 'FUNCTION') AND referenced_type IN ('TABLE', 'VIEW') AND referenced_owner NOT IN ('SYS', 'SYSTEM') ORDER BY owner, NAME, referenced_owner, referenced_name; Which statement is true about the output of the query?

Given this executable section of a PL/SQL block: BEGIN FOR employee_record IN salary_cursor LOOP employee_id_table(employee_id) := employee_record.last_name; END LOOP; CLOSE salary_cursor; END; Why does this section cause an error?