Oracle 11G OCP 1Z0-053 207

LuiseDalian發表於2014-09-03
(207)You want to analyze a SQL Tuning Set(STS) using SQL Performance Analyzer in a test database.

Which two statements are true regarding the activities performed during the test execution of SQLs in a SQL Tuning Set?(Choose two.)

A. Every SQL statement in the STS is considered only once for execution.

B. The SQL statements in the STS are executed concurrently to produce the execution plan and execution statistics.

C. The execution plan and execution statistics are computed for each SQL statement in the STS.

D. The effects of DDL and DML are considered to produce the execution plan and execution statistics.

答案:(A、C)

解析:

《Performance Tuning》 17.2.1

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

相關文章