[单选]
Your system has been upgraded from Oracle Database 10g to Oracle Database 11g. You imported SQL Tuning Sets （STS） from the previous version. After changing the
OPTIMIZER_FEATURE_ENABLE parameter to 10.2.0.4 and running the SQL Performance Analyzer， you observed performance regression for a few SQL statements.
What would you do with these SQL statements？（）

A . Set OPTIMIZER_USE_PLAN_BASELINES to FALSE to prevent the use of regressed plans.
B . Capture the plans from the previous version using STS and then load them into the stored outline.
C . Capture the plans from the previous version using STS and then load them into SQL Management Base （SMB）
D . Set OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to FALSE to prevent the plans from being loaded to the SQL plan baseline.

异步电动机常用的电气制动方法有反接制动、能耗制动和（）。并接制动。回馈制动。抱闸制动。串接制动。在生产原油量较少的油井采油时，以下哪个是人工采油法？（）间歇气举。连续气举。潜油泵。水力活塞泵。螺杆泵。 At 10：30 A.M.， you ran a batch job by mistake， which executed a transaction in the database. The transaction identifier of the transaction that made to the changes in the database is 0500A00627B000. At 11：10 A.M.， you stopped the batch job. Now， you want to identify the changes made to the database tables by the batch job. Which view will you query？（） DBA_PENDING_TRANSACTIONS。 DBA_AUDIT_STATEMENT。 V$FLASHBACK_DATABASE_STATS。 FLASHBACK_TRANSACTION_QUERY。风景名胜区分级 In which order are job stream / job dependencies resolved？（） predecessor - start time - prompt - file - resource。 start time - prompt - predecessor - resource - file。 prompt - predecessor - start time - file - resource。 file - start time - prompt - resource - predecessor。

Your system has been upgraded from Oracle Database 10g to Oracle Database 11g. You imported SQL Tuning Sets （STS） from the previous version. After changing the
OPTIMIZER_FEATURE_ENABLE parameter to 10.2.0.4 and running the SQL Performance Analyzer， you observed performance regression for a few SQL statements.
What would you do with these SQL statements？（）

参考答案：

● 参考解析

本题暂无解析

当前位置：1Z0-053题库

相关题目: