Oracle
1Z0-043 · Question #50
You noticed that the index tablespace in your database requires a recovery. However, instead of performing a media recovery, you decided to re-create the indexes in a new tablespace. Which two…
The correct answer is C. PARALLEL E. NOLOGGING. See the full explanation below for the reasoning.
Question
You noticed that the index tablespace in your database requires a recovery. However, instead of performing a media recovery, you decided to re-create the indexes in a new tablespace. Which two options would you use to reduce the time it takes to re-create the indexes? (Choose two.)
Options
- AONLINE
- BREVERSE
- CPARALLEL
- DCOMPRESS
- ENOLOGGING
- FCOMPUTE STATISTICS
How the community answered
(38 responses)- A13% (5)
- B5% (2)
- C71% (27)
- D3% (1)
- F8% (3)
Community Discussion
No community discussion yet for this question.