Examine the parameters for your

题目

Examine the parameters for your database instance: Which three statements are true about the process of automatic optimization by using cardinality feedback?()

  • 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、The optimizer can re optimize a query only once using cardinality feedback.
  • C、The optimizer enables monitoring for cardinality feedback after the first execution of a query.
  • D、The optimizer does not monitor cardinality feedback if dynamic sampling and multicolumn statistics are enabled.
  • E、After the optimizer identifies a query as a re-optimization candidate, statistics collected by the collectors are submitted to the optimizer.
参考答案和解析
正确答案:A,C,D
如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

View the Exhibit to examine the parameters set for your database instance.You execute the following command to perform I/O calibration after the declaration of bind variables in the session that are used in the command:Which statement describes the consequence?()

A. The command produces an error.

B. The calibration process runs successfully and populates all the bind variables.

C. The calibration process runs successfully but the latency time is not computed.

D. The calibration process runs successfully but only the latency time is computed.Only users with the SYSDBA privilege can run this procedure. Qualified users must also turn on timed_statistics, and ensure asynch_io is enabled for datafiles.


参考答案:A

第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


参考答案:C

第3题:

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

A.expect

B.expedite

C.exercise

D.examine


参考答案:B

第4题:

下列系统消息中,从寻呼信道(F-PCH)发送的有:()

  • A、CDMA Channel List Msg
  • B、System Parameters Msg
  • C、Extended System Parameters Msg
  • D、Access Parameters Msg
  • E、Neighbor List Msg
  • F、Sync Channel Msg

正确答案:A,D,E

第5题:

Your network consists of a single Active Directory domain that contains two domain controllers. Both domain controllers run Windows Server 2003 Service Pack 2 (SP2). Auditing of successful account logon events is enabled on all computers in the domain. You need to identify the last time a specific user logged on to the domain. What should you do?()

  • A、Examine the System Event Log on the user’s computer.
  • B、Examine the System Event Log on both domain controllers.
  • C、Examine the Security Event Log on both domain controllers.
  • D、Examine the Application Event Log on the user’s computer.

正确答案:C

第6题:

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

第7题:

Examine the following parameters for a database instance: MEMORY_MAX_TARGET=0MEMORY_TARGET=0SGA_TARGET=0PGA_AGGREGATE_TARGET=500mWhich three initialization parameters are not controlled by Automatic Shared Memory Management (ASMM)?()

A. LOG_BUFFER

B. SORT_AREA_SIZE

C. JAVA_POOL_SIZE

D. STREAMS_POOL_SIZE

E. DB_16K_CACHE_SZIE

F. DB_KEEP_CACHE_SIZE


参考答案:A, E, F

第8题:

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

第9题:

Finish project parameters 选项中参数的含义与Rough project parameters选项中参数的含义相同。


正确答案:正确

第10题:

You are trying to change the polling parameters used by the location manager via the Cisco WCS,and your request is being denied. What is wrong?()

  • A、Polling values can be changed only in the maintenance window.
  • B、Polling values can be changed only on the location server.
  • C、Your login does not have the correct permissions.
  • D、You must wait for the location server to become available.

正确答案:C

更多相关问题