Oracle
1Z0-062 · Question #10
Examine this command: SQL > exec DBMS_STATS.SET_TABLE_PREFS (SH', CUSTOMERS', PUBLISH', false'); Which three statements are true about the effect of this command?
Sign in or unlock 1Z0-062 to reveal the answer and full explanation for question #10. The question stem and answer options stay visible for context.
Managing Performance
Question
Examine this command:
SQL > exec DBMS_STATS.SET_TABLE_PREFS (SH', CUSTOMERS', PUBLISH', false'); Which three statements are true about the effect of this command?
Options
- AStatistics collection is not done for the CUSTOMERS table when schema stats are gathered.
- BStatistics collection is not done for the CUSTOMERS table when database stats are gathered.
- CAny existing statistics for the CUSTOMERS table are still available to the optimizer at parse time.
- DStatistics gathered on the CUSTOMERS table when schema stats are gathered are stored as
- EStatistics gathered on the CUSTOMERS table when database stats are gathered are stored as
Unlock 1Z0-062 to see the answer
You've previewed enough free 1Z0-062 questions. Unlock 1Z0-062 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#DBMS_STATS#Optimizer statistics#Table preferences#Pending statistics