Oracle Database Advanced PL SQL 12c 1z0 148
© examsiri.com
Question : 44 of 54
Marks:
+1,
-0
Examine these statements regarding the DBMS_RESULT_CACHE package:
1. DBMS_RESULT_CACHE provides subprograms to administer the part of the shared pool used by the PL/SQL function result cache only.
2. DBMS_RESULT_CACHE provides subprograms to administer the part of the shared pool used by both the PL/SQL function result cache and the SQL resultcache.
3. DBMS_RESULT_CACHE package is owned by the SYS user.
4. RESULT_CACHE_MODE can be set using a subprogram defined in the DBMS_RESULT_CACHE package.
Which set of statements is correct?
1. DBMS_RESULT_CACHE provides subprograms to administer the part of the shared pool used by the PL/SQL function result cache only.
2. DBMS_RESULT_CACHE provides subprograms to administer the part of the shared pool used by both the PL/SQL function result cache and the SQL resultcache.
3. DBMS_RESULT_CACHE package is owned by the SYS user.
4. RESULT_CACHE_MODE can be set using a subprogram defined in the DBMS_RESULT_CACHE package.
Which set of statements is correct?
Go to Question: