Oracle
1Z0-052 · Question #157
1Z0-052 Question #157: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-052 to reveal the answer and full explanation for question #157. The question stem and answer options stay visible for context.
Managing Schema Objects
Question
Examine the command: SQL>DBMS_STATS.SET_TABLE_PREFS('SH','CUSTOMERS','PUBLISH','false'); Which statement describes the effect of the above command?
Options
- AAutomatic statistics collection is stopped for the CUSTOMERS table
- BStatistics for the CUSTOMERS table are locked and cannot be overwritten
- CExisting statistics for the CUSTOMERS table become unusable for the query optimizer
- DSubsequently, statistics gathered on the CUSTOMERS table are stored as pending statistics
Unlock 1Z0-052 to see the answer
You've previewed enough free 1Z0-052 questions. Unlock 1Z0-052 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#pending statistics#SET_TABLE_PREFS#PUBLISH preference