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 |
Question ID 2846 | View the Exhibit and examine the structures of the EMPLOYEES and DEPARTMENTS tables. |
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 |