BTQ
LTQ
IP
DTQ
During Company.com planning session，Company.com presents the details of the current Network design. The network design serves four separate company facilities， each on as separate subnet. As part of a disaster recovery plan， the customer is evaluating the use of HACMP. Specifically， the have reviewed IPAT via IP aliasing and are questioning the number of IP subnets required. Given the customer’s current configuration，what is the recommended minimum number of IP subnets that would be required？（）A、 4B、 5C、 6D、 8
点击查看答案
In which two environments would intra-partition parallelism be used? （）A、Single database partition, single processor B、Single database partition, multiple processors C、Multiple database partitions, single processor D、Multiple database partitions, multiple processors
What would indicate intra-partition parallelism in an Optimizer Plan?（）A、BTQ B、LTQ C、IP D、DTQ
Examine the parameter for your database instance: You generated the execution plan for the following query in the plan table and noticed that the nested loop join was done. After actual execution of the query, you notice that the hash join was done in the execution plan: Identify the reason why the optimizer chose different execution plans.（）A、The optimizer used a dynamic plan for the query.B、The optimizer chose different plans because automatic dynamic sampling was enabled.C、The optimizer used re-optimization cardinality feedback for the query.D、The optimizer chose different plan because extended statistics were created for the columns used.
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.
You perform the following activities during the database upgrade from Oracle Database 10g to Oracle Database 11g: 1. Capture plans for a SQL workload into a SQL Tuning Set (STS) before upgrade. 2. Load these plans from the STS into the SQL plan baseline immediately after the upgrade. What is the reason for performing these activities? （）A、to minimize plan regression due to the use of a new optimizer versionB、to completely avoid the use of new plans generated by a new optimizer versionC、to prevent plan capturing when the SQL statement is executed after the database upgradeD、to keep the plan in the plan history so that it can be used when the older version of the optimizer is used
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.
