Oracle OCP 1Z0-053 Q487(SQL Workload)

abstractcyj發表於2016-03-22
487.When executing a SQL workload, you choose to generate execution plans only, without collecting
execution statistics.
Which two statements describe the implications of this? (Choose two.)
A. It produces less accurate results of the comparison analysis.
B. It automatically calls the SQL Tuning Advisor for recommendations.
C. It shortens the time of execution and reduces the impact on system resources.
D. Only the changes in the execution plan, and not performance regression, are detected.
Answer: AC

只產生執行計劃可以更少的去計算結果,同時減少對系統資源的影響

參考:http://blog.itpub.net/17013648/viewspace-1305129/

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/8520577/viewspace-2061886/,如需轉載,請註明出處,否則將追究法律責任。

相關文章