nerdexam
Oracle

1Z0-043 · Question #117

You need to check the EMP_EAST partition in the EMPLOYEES table for physical corruptions. You also need to verify that the rows belong to the correct partition. Which option could you use?

The correct answer is D. The ANALYZE command. See the full explanation below for the reasoning.

Question

You need to check the EMP_EAST partition in the EMPLOYEES table for physical corruptions. You also need to verify that the rows belong to the correct partition. Which option could you use?

Options

  • ALogMiner
  • BThe DBNEWID utility
  • CThe DBVERIFY utility
  • DThe ANALYZE command
  • EThe RMAN REPORT command
  • FThe RMAN CROSSCHECK command.
  • GThe RMAN BLOCKRECOVER command.

How the community answered

(29 responses)
  • A
    14% (4)
  • D
    76% (22)
  • F
    3% (1)
  • G
    7% (2)

Community Discussion

No community discussion yet for this question.

Full 1Z0-043 Practice