搜题

【单选题】

Examine the parameter for your database instance:<br /> 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:<br /> 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.

查看正确答案

更多“ Examine the parameter for your database instance:<br /> 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:<br /> Identify the reason why the optimizer chose different execution plans.（）”相关的问题

第1题

[单选题] Examine the exhibit to view the parameters set in your parameter file. (Click the Exhibit(s) button.) You restart the instance. To what value will the MEMORY_MAX_TARGET parameter be set by default?（）

A、120M B、320M C、480M D、600M

点击查看答案

第2题

[单选题] View the Exhibit to examine the parameter values. You are planning to set the value for the MEMORY_TARGET parameter of your database instance. What value would you recommend?（）

A、90 MB B、272 MB C、362 MB D、1,440 MB

点击查看答案

第3题

[多选题] View the Exhibit to examine the replay settings for replay parameters.What is the implication for setting the values for replay parameters?（）

A、The COMMIT order in the captured workload is preserved during replay. B、The value 100 in the THINK_TIME_SCALE parameter attempts to make the replay client shorten the think time between calls. C、The value 100 in the CONNECT_TIME_SCALE parameter attempts to connect all sessions as captured. D、The value 100 in the THINK_TIME_SCALE parameter attempts to match the captured user think time while replaying. E、The value 100 in the CONNECT_TIME_SCALE parameter attempts to connect all sessions immediately as soon as the replay begins.

点击查看答案

第4题

[] View the Exhibit and examine the initialization parameter settings. Which three initialization parameters are to be set manually as they are not automatically tuned（） View the Exhibit and examine the initialization parameter settings. Which three initialization parameters are to be set manually as they are not automatically tuned（）

A、A.LOG_BUFFER B、B.SORT_AREA_SIZE C、C.JAVA_POOL_SIZE D、D.STREAMS_POOL_SIZE E、E.DB_16K_CACHE_SIZE F、F.DB_KEEP_CACHE_SIZE

点击查看答案

第5题

[单选题] View the Exhibit and examine the output of the query. What do you infer from this（）

A、The SGA_TARGET is a static parameter. B、The instance is started， but the database is not yet open. C、The server parameter file （SPFILE） was used to start the instance. D、The SGA_TARGET parameter does not have any effect onthe databaseinstance untiltheSGA_MAX_SIZE parameter is specified.

点击查看答案

第6题

[单选题] View the Exhibit and examine the output of the query. What do you infer from this（）

A、The SGA_TARGET is a static parameter. B、The instance is started， but the database is not yet open. C、The server parameter file （SPFILE） was used to start the instance. D、The SGA_TARGET parameter does not have any effect on the database instance until theSGA_MAX_SIZE parameter is specified

点击查看答案

第7题

[] The following parameter are set for your Oracle 12c database instance: OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSE OPTIMIZER_USE_SQL_PLAN_BASELINES=TRUE You want to manage the SQL plan evolution task manually. Examine the following steps: 1. Set the evolve task parameters. 2. Create the evolve task by using the DBMS_SPM.CREATE_EVOLVE_TASK function. 3. Implement the recommendations in the task by using the DBMS_SPM.IMPLEMENT_EVOLVE_TASK function. 4. Execute the evolve task by using the DBMS_SPM.EXECUTE_EVOLVE_TASK function. 5. Report the task outcome by using the DBMS_SPM.REPORT_EVOLVE_TASK function. Identify the correct sequence of steps:（） The following parameter are set for your Oracle 12c database instance: OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSE OPTIMIZER_USE_SQL_PLAN_BASELINES=TRUE You want to manage the SQL plan evolution task manually. Examine the following steps: 1. Set the evolve task para

A、A.2，4，5 B、B.2，1，4，3，5 C、C.1，2，3，4，5 D、D.1，2，4，5

点击查看答案

第8题

[] Examine the parameters for your database instance: Which three statements are true about the process of automatic optimization by using cardinality feedback?（） Examine the parameters for your database instance: Which three statements are true about the process of automatic optimization by using cardinality feedback?（）

A、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、B. The optimizer can re optimize a query only once using cardinality feedback. C、C. The optimizer enables monitoring for cardinality feedback after the first execution of a query. D、D. The optimizer does not monitor cardinality feedback if dynamic sampling and multicolumn statistics are enabled. E、E. After the optimizer identifies a query as a re-optimization candidate, statistics collected by thecollectors are submitted to the optimizer.

点击查看答案

第9题

[多选题] You set the following parameters in the parameter file and restarted the database: Which two statements are true regarding these parameters after the database instance is restarted?（）

A、The MEMORY_MAX_TARGET parameter is automatically set to 500 MB B、The value of the MEMORY_MAX_TARGET parameter remains zero till it is changed manually C、The PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set to zero D、The lower bounds of PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to 90 MB and 270 MB, respectively

点击查看答案

第10题

[单选题] You have a computer that runs Windows 7. You configure the computer to automatically install all updates.You need to verify whether a specific update is installed. What should you do?（）

A、In Event Viewer， examine the Application log. B、In Windows Update， examine the update history. C、At the command prompt， run Wusa.exe and specify the /kb parameter. D、At the command prompt， run Verifier.exe and specify the /query parameter.

点击查看答案

账号：登录

答题记录

我的收藏

我的题库

客服

TOP

请使用微信扫码支付

订单号：
遇到问题请联系在线客服