nerdexam
Oracle

1Z0-054 · Question #195

The steps involved in copying statistics from the source database to the target database are given below in random order: 1)Export the statistics table from the source database and then import it…

The correct answer is C. 3, 2, 1, 4; 5 and 6 are not required. See the full explanation below for the reasoning.

Question

The steps involved in copying statistics from the source database to the target database are given below in random order:

1)Export the statistics table from the source database and then import it into the target database. 2)Copy the statistics to a table in the source database. 3)Create a table to hold the statistics in the source database. 4)Copy the statistics into the data dictionary in the target database. 5)Run the Oracle-supplied csminst.sql script to create a schema and a table to hold the statistics in the source database. 6)Collect the system statistics in the target database. What is the correct order to accomplish this task?

Options

  • A3, 2, 4, 1; 5 and 6 are not required
  • B5, 2, 1, 4; 3 and 6 are not required
  • C3, 2, 1, 4; 5 and 6 are not required
  • D5, 2, 1, 6; 3 and 4 are not required
  • E3, 4, 2, 1; 5 and 6 are not required

How the community answered

(50 responses)
  • A
    10% (5)
  • B
    6% (3)
  • C
    80% (40)
  • D
    2% (1)
  • E
    2% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-054 Practice