Which statements about the MEMORY_TARGET initialization para

题目
多选题
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

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

第1题:

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

第2题:

Which of the following statements about language is NOT true?

A.Language is a system
B.Language is symbol
C.Animals also have language
D.Language is arbitrary

答案:C
解析:
本题考查语言的定义。
本题要求选不正确的,C选项,动物也有语言,错误。语言是人类在交际中使用的一套任意的声音符号系统。动物没有语言,动物只是本能发出声音。综上,应选C。
A选项,系统的,故排除。
B选项,符号,故排除。
D选项,任意的,故排除。
故正确答案为C项。

第3题:

Which of the following statements about Leopold and Rudolph Blaschka is TRUE?

A. They were brothers.

B. They were artists.

C. They were florists.

D. They were farmers.


正确答案:B

32.答案为B。根据第一段最后一句,the work of two artists-naturalists,Leopold Blaschka and his son Rudolph作出该项选择。

第4题:

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

第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 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

第7题:

Which two statements are true about L2TP tunnels?() (Choose two.)

  • A、Traffic is clear text
  • B、Traffic is encrypted 
  • C、They are initiated by the LNS
  • D、They are initiated by the LAC

正确答案:A,D

第8题:

Which of the following statements about ORACLE is (are) correct?

Ⅰ.ORACLE follows SQL standard

Ⅱ.ORACLE database defines two logical types: table and view

A.Ⅰonly

B.Ⅱ only

C.Ⅰ and Ⅱ

D.none of the above


正确答案:C

第9题:

Which two of these statements best describe the benefits of WPAv1? ()

  • A、 SSID broadcast prevention
  • B、 Improved mutual authentication
  • C、 Improved encryption through AES
  • D、 Improved protection against sniffing initialization vectors
  • E、 RF jamming prevention

正确答案:B,D

第10题:

Which two statements are true about setting the FAST_START_MTTR_TARGET initialization parameter to anonzero value()

  • A、The MTTR advisor will be disabled.
  • B、Automatic checkpoint tuning will be enabled.
  • C、The value for the LOG_CHECKPOINT_INTERVAL initialization parameter will be override the value forFAST_START_MTTR_TARGET.
  • D、The time taken to recover the instance after the crash is always exactly the same as the value given for theinitialization parameter.

正确答案:B,C

更多相关问题