nerdexam
Oracle

1Z0-146 · Question #147

Examine the settings for a user session given below: RESULT_CACHE_MODE= FORCE What would be the implications of this setting on query execution? (Choose all that apply.)

The correct answer is A. All query results are stored in the result cache if possible. B. Query results that are bigger than the available space in the result cache are not cached. See the full explanation below for the reasoning.

Question

Examine the settings for a user session given below:

RESULT_CACHE_MODE= FORCE What would be the implications of this setting on query execution? (Choose all that apply.)

Options

  • AAll query results are stored in the result cache if possible.
  • BQuery results that are bigger than the available space in the result cache are not cached.
  • CQuery results are stored only when you explicitly use the /*+ result_cache */ hint in your query.
  • DQuery results are stored even when you explicitly use the /*+ no_result_cache */ hint in your query.

How the community answered

(56 responses)
  • A
    77% (43)
  • C
    9% (5)
  • D
    14% (8)

Community Discussion

No community discussion yet for this question.

Full 1Z0-146 Practice