ocp-408

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语句计算执行计划和执行统计。


评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值