违法和不良信息举报 联系客服
免费注册 登录

You specify a nonzero value for the MEMORY_TARGET initializa

题目
单选题
You specify a nonzero value for the MEMORY_TARGET initialization parameter, but do not set the PGA_AGGREGATE_TARGET or the SGA_TARGET parameters. You restart your database instance. Which statement about the result is true?（）
A

The database instance starts, and Oracle sets the default value of SGA_TARGET to the same value as SGA_MAX_SIZE

B

The database instance starts, and Oracle automatically tunes memory and allocates 60 percent to the SGA and 40 percent to the PGA

C

The database instance starts, but Automatic Memory Management is disabled

D

The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter

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

第1题：

You want to enable resumable space allocation at the instance level.Which two actions would enable resumable space allocation at the instance level?()

A. issuing the ALTER SYSTEM ENABLE RESUMABLE; statement

B. issuing the ALTER SESSION ENABLE RESUMABLE; statement

C. modifying the RESUMABLE_TIMEOUT initialization parameter to a nonzero value

D. issuing the ALTER SYSTEM SET RESUMABLE_TIMEOUT=<nonzero value>; statement


参考答案：C, D

第2题：

Which statements about the MEMORY_TARGET initialization parameter are true?() (Choose all that apply.)

A. MEMORY_TARGET can be increased up to the value of MEMORY_MAX_TARGET, if MEMORY_MAX_TARGET is set to a value greater than zero

B. MEMORY_MAX_TARGET defaults to a value of zero if MEMORY_TARGET is not set

C. MEMORY_TARGET represents the total amount of memory that can be allocated to SGA and PGA memory structures.

D. MEMORY_TARGET is static and cannot be modified without shutting down the instance


参考答案：A

第3题：

Regarding the extended ping command; which of the statements below are true?

(Select all valid answer choices)

A．The extended ping command is supported from user EXEC mode.

B．The extended ping command is available from privileged EXEC mode.

C．With the extended ping command you can specify the TCP and UDP port to be pinged.

D．With the extended ping command you can specify the timeout value.

E．With the extended ping command you can specify the datagram size.


正确答案：BDE
解析：Explanation:
The extended ping command works only at the privileged EXEC command line.
Some of the extended ping command values include the datagram size and timeout value as shown:

Datagram size [100]: Size of the ping packet (in bytes). Default: 100 bytes.

Timeout in seconds [2]: Timeout interval. Default: 2 (seconds). The ping is declared successful only if the ECHO REPLY packet is received before this time interval.

Incorrect Answers:
A. Regular pings are available in both user and privileged mode, but not extended pings.
C. Ports can not be specified.

第4题：

To enable resumable space allocation for the instance， which of the following initialization parameters should you set to a nonzero value？（）

  • A、 RESUMABLE_SPACE_TIME
  • B、 RESUMABLE_SPACE
  • C、 RESUMABLE_TIME
  • D、 RESUMABLE_TIMEOUT
  • E、 TIME_RESUMABLE

正确答案:D

第5题：

Which statements about the MEMORY_TARGET initialization parameter are true？（） 

  • A、 MEMORY_TARGET can be increased up to the value of MEMORY_MAX_TARGET， if  MEMORY_MAX_TARGET is set to a value greater than zero
  • B、 MEMORY_MAX_TARGET defaults to a value of zero if MEMORY_TARGET is not set
  • C、 MEMORY_TARGET represents the total amount of memory that can be allocated to SGA and PGA memory structures.
  • D、 MEMORY_TARGET is static and cannot be modified without shutting down the instance

正确答案:A,B,C

第6题：

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

第7题：

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

第8题：

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

第9题：

You specify a nonzero value for the MEMORY_TARGET initialization parameter，but do not set the PGA_AGGREGATE_TARGET or the SGA_TARGET parameters. You restart your database instance.  Which statement about the result is true？（）

  • A、 The database instance starts，and Oracle sets the default value of SGA_TARGET to the same value as SGA_MAX_SIZE
  • B、 The database instance starts，and Oracle automatically tunes memory and allocates 60 percent to the  SGA and 40 percent to the PGA
  • C、 The database instance starts，but Automatic Memory Management is disabled
  • D、 The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter

正确答案:B

第10题：

Which of the following Oracle features is enabled by setting a nonzero value for the MEMORY_TARGET initialization parameter？（）  

  • A、 Automatic PGA Memory Management
  • B、 Automatic SGA Memory Management
  • C、 Automatic Shared Memory Management
  • D、 Automatic Memory Management
  • E、 Manual SGA Memory Management
  • F、 None of the above

正确答案:D

更多相关问题
相关内容