[Oracle] oracledba8 NOLOGGING, oraclenologging

[Oracle] oracledba8 NOLOGGING, oraclenologging

You noticed that the index tablespace in your database requires

Recovery. However, instead of discovery a media recovery, you decide

D to re-create the indexes in a new tablespace. Which two options wou

Ld you use to reduce the time it takes to re-create the indexes? (Choose two .)

A. ONLINE

B. REVERSE

C. PARALLEL

D. COMPRESS

E. NOLOGGING

F. COMPUTE STATISTICS

Answer: C, E

You noticed that the index tablespace in your database requires recovery. However, if you do not perform media restoration, you decide to re-create an index on a new tablespace. How do you perform this operation to reduce the time required to re-create an index? (Select two .)