nerdexam
Oracle

1Z0-043 · Question #47

You lost a temporary file that belongs to the default temporary tablespace in your database. From the options provided, which approach would you take to solve the problem?

The correct answer is D. Do not perform a recovery, but create a new temporary tablespace, make it the default temporary. See the full explanation below for the reasoning.

Question

You lost a temporary file that belongs to the default temporary tablespace in your database. From the options provided, which approach would you take to solve the problem?

Options

  • Aflash back the database
  • Bimport the temporary tablespace from the last export
  • Crestore all the data files and temporary files from the last full database backup and perform a recovery
  • DDo not perform a recovery, but create a new temporary tablespace, make it the default temporary

How the community answered

(56 responses)
  • A
    14% (8)
  • B
    4% (2)
  • C
    5% (3)
  • D
    77% (43)

Community Discussion

No community discussion yet for this question.

Full 1Z0-043 Practice