READ Free Dumps For Oracle- 1z0-146
Question ID 2763 | Which two statements are true about the tuning of PL/SQL code? (Choose two.) |
Option A | A. Redundant SQL statements in PL/SQL code should be avoided. |
Option B | B. Implicit data type conversion in PL/SQL code can improve performance. |
Option C | C. Usage of the NOT NULL constraint in PL/SQL code can degrade performance. |
Option D | D. If you have one PL/SQL program unit instead of multiple smaller executable sections, performance can be improved. |
Correct Answer | A,C |
Question ID 2764 | You created a PL/SQL function with the RESULT_CACHE and RELIES_ON clauses. In which |
Option A | A. when the size for the memory allocated for the result cache is increased |
Option B | B. when the function is executed in a session frequently with the same parameter value |
Option C | C. when the database administrator has disabled the use of the result cache during application patching |
Option D | D. when a data manipulation language (DML) statement is executed in a session on a table or view that was specified in the RELIES_ON clause of a result-cached function |
Correct Answer | C,D |