Oracle

1Z0-514 · Question #22

Whit h two of the following tasks must you perform in order to benefit from the SQL. Query Result Cache?

The correct answer is A. Use a SQL_QUERY_RESULT_CACHEhint in your SQL statement. C. Make sure the RESULT_CACHE_MAX_SIZE is greater than 0. See the full explanation below for the reasoning.

Question

Whit h two of the following tasks must you perform in order to benefit from the SQL. Query Result Cache?

Options

AUse a SQL_QUERY_RESULT_CACHEhint in your SQL statement.
BSet RESULT_CACHE_MODE to FORCE
CMake sure the RESULT_CACHE_MAX_SIZE is greater than 0.
DHave SQL statements that are executed repeatedly.
EUse temporary tables.
FNot use bind variables in your query.

How the community answered

(39 responses)

A
77% (30)
B
3% (1)
D
3% (1)
E
5% (2)
F
13% (5)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion

Full 1Z0-514 Practice