Which of these tools are used to copy statistics between databases? (Choose three.)
A . SQL*Plus copy
B. import
C. DBMS_STATS
D. export
E . DBMS_JOB
Explanation:
Answer B, C and D: DBMS_STATS is used to create and populate the statistics table in a schema. The export and import utilities are used to extract the object from the source database and bring it into the target database. DBMS_STATS is then used on the target database to move the statistics into the data dictionary.
No comments:
Post a Comment