nerdexam
Oracle

1Z0-141 · Question #84

How can you restrict a query on a block temporarily, so that the restriction is in effect only for the first query on the block after setting the property?

The correct answer is C. Set the ONETIME_WHERE block property programmatically. See the full explanation below for the reasoning.

Question

How can you restrict a query on a block temporarily, so that the restriction is in effect only for the first query on the block after setting the property?

Options

  • ASet the Where Clause block property at design time.
  • BSet the DEFAULT_WHERE block property programmatically.
  • CSet the ONETIME_WHERE block property programmatically.
  • DSet the Onetime Where Clause block property at design time.
  • ESet the Default Where clause for the block either at design time or programmatically.
  • FSet the Onetime Where clause for the block either at design time or programmatically.

How the community answered

(56 responses)
  • A
    9% (5)
  • B
    2% (1)
  • C
    84% (47)
  • D
    2% (1)
  • F
    4% (2)

Community Discussion

No community discussion yet for this question.

Full 1Z0-141 Practice