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 th

题目

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.

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

相似问题和答案

第1题：

You want to enable automatic PGA memory management in your database. Which setting is required to achieve this?()

A. Set MEMORY_TARGET to zero

B. Set the STATISTICS_LEVEL parameter to BASIC

C. Set the WORKAREA_SIZE_POLICY parameter to MANUAL

D. Set the PGA_AGGREGATE_TARGET parameter to nonzero value

参考答案：D

第2题：

Which statement about Automatic Memory Management with Oracle 11g is true?()

A. You cannot specify MEMORY_TARGET if you explicitly specify SGA_TARGET or PGA_AGGREGATE_TARGET values that are greater than zero in your parameter file.

B. Oracle can reallocate memory between the SGA and PGA automatically as needed.

C. To use Automatic Memory Management, you must explicitly set both the MEMORY_TARGET and MEMORY_MAX_TARGET parameters in your parameter file.

D. You can set the MEMORY_TARGET parameter to a maximum value of the current SGA size plus the current PGA size.

参考答案：B

第3题：

We will do our best to ( ) shipment to meet your requirements in time.

A.expect

B.expedite

C.exercise

D.examine

参考答案：B

第4题：

Your database is started by using the server parameter file （SPFILE）. You issued this command to change the value of the LOG_BUFFER initialization parameter： ALTER SYSTEM SET LOG_BUFFER=24M SCOPE=BOTH; What would be the outcome of this command？（）

A、The command would return an error because LOG_BUFFER is a static parameter.
B、The parameter value would be changed and it would come into effect immediately.
C、You need to restart the database so that parameter changes can come into effect.
D、The command would succeed only if initialization parameter LOG_ARCHIVE_MAX_PROCESS is set to value 2.

正确答案:A

第5题：

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

参考答案：C

第6题：

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.

参考答案：A, C, D

第7题：

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

参考答案：D

第8题：

You are writing a method that accepts a string parameter named message.Your method must break the message parameter into individual lines of text and pass each line to a second method named Process.Which code segment should you use?（）

参考答案：D

第9题：

Your boss at Certkiller .com wants you to clarify Oracle 10g. Which statement regarding the contents of the V$PARAMETER view is true？（）

A、Displays only the list of default values
B、Displays only the list of all basic parameters
C、Displays the currently in effect parameter values
D、Displays only the list of all advanced parameters
E、Displays the list of all the parameter files of a database
F、Displays the current contents of the server parameter file.

正确答案:C

第10题：

Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt： RMAN> CONFIGURE CONTROLFILE AUTOBACKUP OFF； RMAN> BACKUP DATABASE； Which files from the database will be backed up as a result of this BACKUP command？（）

A、 control file
B、 all datafiles
C、 password file
D、 online redo log file
E、 archive redo log file
F、 server parameter file
G、 only the SYSTEM datafile

正确答案:A,B,F

Examine the parameter for your

题目

相似问题和答案

更多相关问题

相关内容