nerdexam
Oracle

1Z0-043 · Question #172

You lost the index tablespace in your database. You decided to re-create the index tablespace and the indexes in the tablespace. What methods can you use to re-create the indexes? (Choose all that…

The correct answer is A. SQL scripts C. Data Pump. See the full explanation below for the reasoning.

Question

You lost the index tablespace in your database. You decided to re-create the index tablespace and the indexes in the tablespace. What methods can you use to re-create the indexes? (Choose all that apply.)

Options

  • ASQL scripts
  • BRecovery Manager (RMAN) script
  • CData Pump
  • DSQL*Loader
  • EFlashback database

How the community answered

(59 responses)
  • A
    71% (42)
  • B
    5% (3)
  • D
    17% (10)
  • E
    7% (4)

Community Discussion

No community discussion yet for this question.

Full 1Z0-043 Practice