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)- A9% (5)
- B2% (1)
- C84% (47)
- D2% (1)
- F4% (2)
Community Discussion
No community discussion yet for this question.