nerdexam
Oracle

1Z0-146 · Question #116

Which two queries' results cannot be cached? (Choose two.)

The correct answer is C. the query on dictionary and temporary tables D. queries having SYSDATE and SYS_TIMESTAMP SQL functions. See the full explanation below for the reasoning.

Question

Which two queries' results cannot be cached? (Choose two.)

Options

  • Aqueries having the GROUP BY clause
  • Bqueries having the ORDER BY clause
  • Cthe query on dictionary and temporary tables
  • Dqueries having SYSDATE and SYS_TIMESTAMP SQL functions

How the community answered

(26 responses)
  • A
    8% (2)
  • B
    8% (2)
  • C
    85% (22)

Community Discussion

No community discussion yet for this question.

Full 1Z0-146 Practice