Test Index

Oracle Database Advanced PL SQL 12c 1z0 148

© examsnet.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?

2, 3 and 4
1 and 4
2 and 4
1 and 3
2 and 3

Go to Question:

Prev Question

Next Question