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
MEMORY_MAX_TARGET defaults to a value of zero if MEMORY_TARGET is not set
MEMORY_TARGET represents the total amount of memory that can be allocated to SGA and PGA memory structures.
MEMORY_TARGET is static and cannot be modified without shutting down the instance
第1题:
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.
第2题:
第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.
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?()
第5题:
Which statements about the MEMORY_TARGET initialization parameter are true?()
第6题:
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
第7题:
Which two statements are true about L2TP tunnels?() (Choose two.)
第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
第9题:
Which two of these statements best describe the benefits of WPAv1? ()
第10题:
Which two statements are true about setting the FAST_START_MTTR_TARGET initialization parameter to anonzero value()