[多选]
The OPTIMIZER_USE_PLAN_BASELINES parameter is set to TRUE. The optimizer generates a plan for a SQL statement but does not find a matching plan in the SQL plan baseline.
Which two operations are performed by the optimizer in this scenario?（）

A . The optimizer adds the new plan to the plan history.
B . The optimizer selects the new plan for the execution of the SQL statement.
C . The optimizer adds the new plan to the SQL plan baseline as an accepted plan.
D . The optimizer adds the new plan to the SQL plan baseline but not in the ENABLED state.
E . The optimizer costs each of the accepted plans in the SQL plan baseline and picks the one with the lowest cost.

王某，48岁，休克患者，进行扩容疗法快速输液时，检测得中心静脉压1.47kPa（15cmH2O），血压10.7/8kPa（80/60mmHg）。应采取的措施是（）大量输液，加快速度。控制速度，减慢输液。减慢输液，加用强心剂。暂停输液。用升压药。 Identity two advantages of using a recovery catalog in-load of the control File of the target database Recovery Manager （RMAN）.（） You can use RMAN stored scripts.。 Recovery is faster if data is stored in catalog in addition to the control file.。 You can store backup Information of all registered databases in one place.。 Database backups are automatically deleted when they are older than the specified time period.。 When considering Dynamic Infrastructure, which IBM storage technology is the IBMrecommended solution for small and medium businesses?（） IBM System Storage DS3500 Express 。 IBM System Storage DS5300 。 IBM XIV Storage System 。 IBM N series 6240。 An administrator suspects problems on a SCSI hard disk， but upon running diagnostics， no errors were found. What must be done to check the condition of the drive？（） Run diag and select the ’Certify Media’ task.。 Perform a read and write test on the disk and monitor errorlog.。 Update the disk firmware to the latest level and monitor errorlog.。 Format the disk to ensure bad blocks are omitted from the disk layout.。嗜碱微生物是指那些能够（）生长的微生物在冷的温度下。在高压下。在高温下。在高pH值下。

The OPTIMIZER_USE_PLAN_BASELINES parameter is set to TRUE. The optimizer generates a plan for a SQL statement but does not find a matching plan in the SQL plan baseline.
Which two operations are performed by the optimizer in this scenario?（）

参考答案：

● 参考解析

本题暂无解析

当前位置：OCP 11G认证考试题库

[多选] The OPTIMIZER_USE_PLAN_BASELINES parameter is set to TRUE. The optimizer generates a plan for a SQL statement but does not find a matching plan in the SQL plan baseline. Which two operations are performed by the optimizer in this scenario?（）

相关题目:

[多选]
The OPTIMIZER_USE_PLAN_BASELINES parameter is set to TRUE. The optimizer generates a plan for a SQL statement but does not find a matching plan in the SQL plan baseline.
Which two operations are performed by the optimizer in this scenario?（）