OCP-1Z0-053-V13.02-42题

42.You plan to use SQL Performance Analyzer to analyze the SQL workload. You created a SQL Tuning

Set as a part of the workload capturing. What information is captured as part of this process? (Choose all that apply.)

A. the SQL text

B. the execution plan

C. the execution context

D. the execution frequency

E. the system change number (SCN)

Answer: ACD

答案解析:

参考:http://www.oracle.com/technetwork/cn/articles/o69ocp-099954.html



You plan to use SQL Performance Analyzer to analyze a SQL workload, and you’ve created a SQL tuning set as a part of the workload capture. What information is captured as part of this process?

A. The SQL text 
B. The execution context 
C. The execution frequency 
D. The performance statistics

The correct answers are A, B, and C. While creating the SQL tuning set, SQL Performance Analyzer captures the SQL text, the execution context, and the number of times the statement is executed. SQL Performance Analyzer then uses that information to analyze the performance of the SQL statement.

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值