题目
A. The optimizer automatically changes a plan during subsequent execution of a SQL statement if there is a huge difference in optimizer estimates and execution statistics.
B. The optimizer can re optimize a query only once using cardinality feedback.
C. The optimizer enables monitoring for cardinality feedback after the first execution of a query.
D. The optimizer does not monitor cardinality feedback if dynamic sampling and multicolumn statistics are enabled.
E. After the optimizer identifies a query as a re-optimization candidate, statistics collected by thecollectors are submitted to the optimizer.
第2题
23 Which of the following actions is an example of risk response:
A. adjust project parameters (scope, time, quality ...)
B. reduce the probability of potential project risk events C. reduce the consequences of potential project risk events
D. wait until a problem actually happens, then deal with it in the most effective and efficient manner.
E. A, B and C only
第3题
To implement Automatic Management (AMM), you set the following parameters: When you try to start the database instance with these parameter settings, you receive the following error message:SQL > startupORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information.Identify the reason the instance failed to start.()
A.The PGA_AGGREGATE_TARGET parameter is set to zero.
B.The STATISTICS_LEVEL parameter is setto basic.
C.Both the SGA_TARGETandMEMORY_TARGET paramete rsareset.
D.The SGA_MAX_SIZEandSGA_TARGET parameter value sare note qual.
第5题
A.examined
B.to examine
C.examining
D.examine
第8题
A.A.Use a hole instrument to examine the turbine internally
B.B.Use a borescope to examine the combustor internally
C.C.Use a hole instrument to examine the combustor externally
为了保护您的账号安全,请在“赏学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!