Oracle
1Z0-074 · Question #34
Which three statements are true about the deferred invalidation clause in DDL statements? (Choose three.)
The correct answer is A. It defers invalidating dependent cursor when possible. C. The CURSOR_INVALIDATION parameter always overrides the deferred invalidation clause. E. It cannot be used for creating a secondary index on index organized tables. Explanation/Reference:
New Features for Performance
Question
Which three statements are true about the deferred invalidation clause in DDL statements? (Choose three.)
Options
- AIt defers invalidating dependent cursor when possible.
- BIt cannot be used for bitmap index creation.
- CThe CURSOR_INVALIDATION parameter always overrides the deferred invalidation clause.
- EIt cannot be used for creating a secondary index on index organized tables
How the community answered
(28 responses)- A75% (21)
- B25% (7)
Explanation
Explanation/Reference:
Topics
#deferred invalidation#cursor invalidation#DDL statements#CURSOR_INVALIDATION
Community Discussion
No community discussion yet for this question.