ocp-408

来源：互联网发布：xp仿苹果mac界面主题编辑：程序博客网时间：2024/04/26 06:45

QUESTION NO: 408
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.
Answer: A,C

你要在测试数据库中使用SQL性能分析器分析SQL调优集（ STS）。关于在SQL调优集中
SQL测试执行的活动，哪两个描述是真实的？

A.在SQL调优集中每个SQL语句被认为是只执行一次。C.
C.为SQL调优集中的每个SQL语句计算执行计划和执行统计。

0 1