Oracle OCP 1Z0-053 Q487(SQL Workload)
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/
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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle OCP 1Z0-053 Q516(Workload Capture)OracleAPT
- Oracle OCP 1Z0-053 Q137(Workload Capture&Replay)OracleAPT
- Oracle OCP 1Z0-053 Q412(Workload Replay report difference)Oracle
- Oracle OCP 1Z0-053 Q80(SQL Profile)OracleSQL
- Oracle OCP IZ0-053 Q257(workload capture)OracleAPT
- Oracle OCP 1Z0-053 Q252(SQL Plan Baseline)OracleSQL
- Oracle OCP 1Z0-053 (ASM)OracleASM
- Oracle OCP IZ0-053 Q692(Workload Capture and Replay)OracleAPT
- Oracle OCP IZ0-053 Q411(Workload Capture of RAC)OracleAPT
- Oracle OCP 1Z0-053 (System Partitioning)Oracle
- Oracle OCP 1Z0-053 Q445Oracle
- Oracle OCP 1Z0 053 Q479(Workload Capture&Replay)OracleAPT
- Oracle OCP 1Z0-053 Q207(SQL Tuning Set&Analyzer)OracleSQL
- Oracle OCP 1Z0 053 Q409(Workload Capture&Replay)OracleAPT
- Oracle OCP 1Z0 053 Q410(Workload Capture&Replay)OracleAPT
- Oracle 11G OCP 1Z0-053 600Oracle
- Oracle 11G OCP 1Z0-053 581Oracle
- Oracle 11G OCP 1Z0-053 582Oracle
- Oracle 11G OCP 1Z0-053 583Oracle
- Oracle 11G OCP 1Z0-053 584Oracle
- Oracle 11G OCP 1Z0-053 585Oracle
- Oracle 11G OCP 1Z0-053 586Oracle
- Oracle 11G OCP 1Z0-053 587Oracle
- Oracle 11G OCP 1Z0-053 588Oracle
- Oracle 11G OCP 1Z0-053 589Oracle
- Oracle 11G OCP 1Z0-053 590Oracle
- Oracle 11G OCP 1Z0-053 591Oracle
- Oracle 11G OCP 1Z0-053 592Oracle
- Oracle 11G OCP 1Z0-053 593Oracle
- Oracle 11G OCP 1Z0-053 594Oracle
- Oracle 11G OCP 1Z0-053 595Oracle
- Oracle 11G OCP 1Z0-053 596Oracle
- Oracle 11G OCP 1Z0-053 597Oracle
- Oracle 11G OCP 1Z0-053 598Oracle
- Oracle 11G OCP 1Z0-053 563Oracle
- Oracle 11G OCP 1Z0-053 564Oracle
- Oracle 11G OCP 1Z0-053 565Oracle
- Oracle 11G OCP 1Z0-053 566Oracle