AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


READ Free Dumps For Oracle- 1z0-146





Question ID 2845

Which two queries' results cannot be cached? (Choose two.)
 

Option A

A.    queries having the GROUP BY clause
 

Option B

B.    queries having the ORDER BY clause
 

Option C

C.    the query on dictionary and temporary tables
 

Option D

D.    queries having SYSDATE and SYS_TIMESTAMP SQL functions
 

Correct Answer C,D
Explanation


Question ID 2846

View the Exhibit and examine the structures of the EMPLOYEES and DEPARTMENTS tables.
Examine the PL/SQL block that you execute to find the average salary for employees in the
'Sales' department:
DECLARE
TYPE emp_sal IS TABLE OF employees.salary%TYPE INDEX BY VARCHAR2(20);
v_emp_sal emp_sal;
PROCEDURE get_sal(p_dept_name VARCHAR2, p_arr OUT emp_sal) IS
BEGIN
SELECT AVG(salary) INTO p_arr(p_dept_name)
FROM employees WHERE department_id=
(SELECT department_id FROM departments
WHERE department_name=p_dept_name);
END get_sal;
BEGIN
get_sal('Sales',v_emp_sal);
DBMS_OUTPUT.PUT_LINE( v_emp_sal('Sales'));
END;
/
What is the outcome?
 

Option A

A. It executes successfully and gives the correct output.
 
 

Option B

B.    It generates an error because the associative array definition is not valid.
 

Option C

C.    It generates an error because an associative array cannot be passed to a procedure in OUT mode.
 

Option D

D.    It generates an error because an associative array cannot be used with the SELECT INTO statement.
 

Correct Answer A
Explanation

Send email to admin@getfreedumps for new dumps request!!!