多选题Identify the two direct sources from where SQL plans can be loaded into the SQL plan baselines.（）ACursor cacheBStored outlineCSQL Tuning SetDAutomatic Workload Repository （AWR） snapshots
多选题
Identify the two direct sources from where SQL plans can be loaded into the SQL plan baselines.（）
A
Cursor cache
B
Stored outline
C
SQL Tuning Set
D
Automatic Workload Repository （AWR） snapshots
参考解析
解析：
暂无解析
相关考题：
标准SQL基本查询模块的结构是A）SELECT…FROM…ORDER BYB）SELECT…WHERE…GROUP BYC）SELECT…WHERE…HAVINGD）SELECT…FROM…WHERE
Identify the two direct sources from where SQL plans can be loaded into the SQL plan baselines.() A. Cursor cacheB. Stored outlineC. SQL Tuning SetD. Automatic Workload Repository (AWR) snapshots
Which two client requests are captured during database replay Capture?() (Choose two) A. Flashback queriesB. Shared server requestsC. Login and logoff activities of sessionsD. Direct path load of data from external files by using utilities such as SQL *loaderE. Data definition language (DDL) and data manipulation language (DML) operations
有SQL语句：SELECT * FROM 教师 WHERE NOT(工资3000 OR 工资2000)与如下语句等价的SQL语句是A）SELECT*FROM 教师 WHERE 工资 BETWEEN 2000 AND 3000B) SELECT*FROM 教师 WHERE 工资2000 AND 工资3000C）SELECT*FROM 教师 WHERE 工资2000 OR 工资3000D) SELECT*FROM 教师 WHERE 工资=2000 AND 工资3000
有SQL语句 SELECT * FROM 教师 WHERE NOT(工资＞30000R工资＜2000) 与如上语句等价的SQL语句是A．SELECT * FROM 教师 WHERE 工资 BETWEEN 2000 AND 3000B．SELECT * FROM 教师 WHERE 工资＞2000 AND工资＜3000C．SELECT * FROM 教师 WHERE 工资＞2000 OR工资＜3000D．SELECT * FROM 教师 WHERE 工资＜=2000 AND工资＞=3000
Which two statements about configuration an unconnected Catalyst Express 500 switch from setup mode using a PC are true？（）A、You may use Cisco Network Assistant to set up the initial configurationB、You must use CLI for initial configurationC、You may use either CLI or CAN for configurationD、You may make a direct connection to the PC from any point on the switchE、You may only make a direct connection from the port with the flashing green LED to the PC
Which two statements about subqueries are true? （）A、A single row subquery can retrieve data from only one table.B、A SQL query statement cannot display data from table B that is referred to in its subquery, unless table B is included in the main query's FROM clause.C、A SQL query statement can display data from table B that is referred to in its subquery, without including table B in its own FROM clause.D、A single row subquery can retrieve data from more than one table.E、A single row subquery cannot be used in a condition where the LIKE operator is used for comparison.F、A multiple-row subquery cannot be used in a condition where the LIKE operator is used for comparison.
Which three are the valid statements in relation to SQL plan baselines?（）A、The plans can be manually loaded to the SQL plan baseline.B、The plans in the SQL plan baseline are verified and accepted plans.C、The plans generated for every SQL statement are stored in the SQL plan baseline by default.D、The plan baselines are stored temporarily in the memory as long as the database instance is running.E、 For the SQL plan baselines to be accessible to the optimizer, the SYSAUX tablespace must be online.
While deploying a new application module, the software vendor ships the application software along with appropriate SQL plan baselines for the new SQLs being introduced. Which two statements describe the consequences?（）A、The plan baselines can be evolved over time to produce better performance.B、The newly generated plans are directly placed into the SQL plan baseline without being verified.C、The new SQL statements initially run with the plans that are known to produce good performance under standard test configuration.D、The optimizer does not generate new plans for the SQL statements for which the SQL plan baseline has been imported.
Which two are true regarding direct-path exports？（）A、Direct-path export is typically faster.B、Direct-path export can be invoked interactively.C、Direct-path export is character set independent.D、Direct-path export bypasses the SQL-command processing layer.E、Direct-path export can be used to export rows containing LOBs and BFILEs.
Which two client requests are captured during database replay Capture?（） (Choose two)A、Flashback queriesB、Shared server requestsC、Login and logoff activities of sessionsD、Direct path load of data from external files by using utilities such as SQL *loaderE、Data definition language (DDL) and data manipulation language (DML) operations
Identify the activities performed as part of the Automatic SQL Tuning process in the maintenance window?（）A、generating the SQL profileB、testing and accepting the SQL profileC、generating a list of candidate SQLs for tuningD、adding tuned SQL plans into the SQL plan baselineE、tuning each SQL statement in the order of importanceF、generating baselines that include candidate SQLs for tuning
Identify the activities performed as part of the Automatic SQL Tuning process in the maintenance window？（）A、 generating the SQL profileB、 testing and accepting the SQL profileC、 generating a list of candidate SQLs for tuningD、 adding tuned SQL plans into the SQL plan baselineE、 tuning each SQL statement in the order of importance F、 generating baselines that include candidate SQLs for tuning
Which two statements about subqueries are true? （）A、A single row subquery can retrieve data from only one table.B、A SQL query statement cannot display data from table B that is referred to in its subquery, unless table B is included in the main query's FROM clause.C、A SQL query statement can display data from table B that is referred to in its subquery, without including B in its own FROM clause.D、A single row subquery can retrieve data from more than one table.E、A single row subquery cannot be used in a condition where the LIKE operator is used for comparison.F、A multiple-row subquery cannot be used in an INSERT statement to insert multiple rows at a time.
Identify the two direct sources from where SQL plans can be loaded into the SQL plan baselines.（）A、Cursor cacheB、Stored outlineC、SQL Tuning SetD、Automatic Workload Repository (AWR) snapshots
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
You need to design the consolidation plan for SQL1， SQL2， and SQL3. You need to identify the appropriate combination of SQL Server instances and SQL Server 2005 computers that are needed to fulfill the company’s consolidation plans and security requirements.Which combination should you use？（）A、one SQL Server 2005 computer with one instanceB、two SQL Server 2005 computers， each with two instancesC、two SQL Server computers， one with one instance and one with three instancesD、one SQL Server 2005 computer with two instances
多选题Identify the activities performed as part of the Automatic SQL Tuning process in the maintenance window?（）Agenerating the SQL profileBtesting and accepting the SQL profileCgenerating a list of candidate SQLs for tuningDadding tuned SQL plans into the SQL plan baselineEtuning each SQL statement in the order of importanceFgenerating baselines that include candidate SQLs for tuning
多选题Which two statements about subqueries are true? （）AA single row subquery can retrieve data from only one table.BA SQL query statement cannot display data from table B that is referred to in its subquery, unless table B is included in the main query's FROM clause.CA SQL query statement can display data from table B that is referred to in its subquery, without including table B in its own FROM clause.DA single row subquery can retrieve data from more than one table.EA single row subquery cannot be used in a condition where the LIKE operator is used for comparison.FA multiple-row subquery cannot be used in a condition where the LIKE operator is used for comparison.
多选题While deploying a new application module, the software vendor ships the application software along with appropriate SQL plan baselines for the new SQLs being introduced. Which two statements describe the consequences?（）AThe plan baselines can be evolved over time to produce better performance.BThe newly generated plans are directly placed into the SQL plan baseline without being verified.CThe new SQL statements initially run with the plans that are known to produce good performance under standard test configuration.DThe optimizer does not generate new plans for the SQL statements for which the SQL plan baseline has been imported.
单选题You need to design the consolidation plan for SQL1， SQL2， and SQL3. You need to identify the appropriate combination of SQL Server instances and SQL Server 2005 computers that are needed to fulfill the company’s consolidation plans and security requirements.Which combination should you use？（）Aone SQL Server 2005 computer with one instanceBtwo SQL Server 2005 computers， each with two instancesCtwo SQL Server computers， one with one instance and one with three instancesDone SQL Server 2005 computer with two instances
单选题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? （）Ato minimize plan regression due to the use of a new optimizer versionBto completely avoid the use of new plans generated by a new optimizer versionCto prevent plan capturing when the SQL statement is executed after the database upgradeDto keep the plan in the plan history so that it can be used when the older version of the optimizer is 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?（）ASet OPTIMIZER_USE_PLAN_BASELINES to FALSE to prevent the use of regressed plans.BCapture the plans from the previous version using STS and then load them into the stored outline.CCapture the plans from the previous version using STS and then load them into SQL Management Base (SMB).DSet OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to FALSE to prevent the plans from being loaded to the SQL plan baseline.
多选题Which two statements are true regarding subqueries? （）AA subquery can retrieve zero or more rowsBOnly two subqueries can be placed atone levelCA subquery can be used only in SQL query statementsDA subquery can appear on either side of a comparison operatorEThere is no limit on the number of subquery levels in the WHERE clause of a SELECT statement
多选题Which two statements about subqueries are true? （）AA single row subquery can retrieve data from only one table.BA SQL query statement cannot display data from table B that is referred to in its subquery, unless table B is included in the main query's FROM clause.CA SQL query statement can display data from table B that is referred to in its subquery, without including B in its own FROM clause.DA single row subquery can retrieve data from more than one table.EA single row subquery cannot be used in a condition where the LIKE operator is used for comparison.FA multiple-row subquery cannot be used in an INSERT statement to insert multiple rows at a time.
多选题Which three are the valid statements in relation to SQL plan baselines?（）AThe plans can be manually loaded to the SQL plan baseline.BThe plans in the SQL plan baseline are verified and accepted plans.CThe plans generated for every SQL statement are stored in the SQL plan baseline by default.DThe plan baselines are stored temporarily in the memory as long as the database instance is running.E For the SQL plan baselines to be accessible to the optimizer, the SYSAUX tablespace must be online.
单选题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.