单项选择题
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
相关考题
-
单项选择题
You want to configure the Flashback Database feature and retain flashback logs for three days. Presently the database is open and configured in ARCHIVELOG mode. The following steps must be performed in the correct sequence to do this: Choose the correct sequence.（）
A.4，1，3，2，5
B.4，3，1，2，5
C.2，4，3，5，1
D.4，2，5，3，1 -
单项选择题
The following command is executed to create the baseline template： SQL> EXECUTEDBMS_WORKLOAD_REPOSITORY.CREATE_BASELINE_TEMPLATE（START_TIME=> TO_TIESTAMP（SYSDATE+2）， END_TIME=>TO_TIMESTAMP（SYSDATE+10）， BASELINE_NAME=>’Mybase4’， TEMPLATE_NAME=>’Mytemp4’， EXPIRATION=>NULL）； Which statement is true about the effect of the above command？（）
A. It creates a baseline template that never expires.
B. It produces an error because no snapshot information is provided to create the baseline.
C. It creates a baseline template that expires after the Automatic Workload Repository （AWR） retention period.
D. It creates a repeating baseline template that repeats after the Automatic Workload Repository （AWR） retention period. -
多项选择题
You want to take the backup of the USERS tablespace. It has a single data file of 900 MB. You have tape drives of 300 MB each. The SBT channel is configured for Recovery Manager (RMAN). To accomplish the backup, you issued the following RMAN command: RMAN> BACKUP SECTION SIZE 300M TABLESPACE users; Which two statements are true about the execution of the above command? （）(Choose two.)
A. The backup piece size will be limited to 300 MB
B. The RMAN uses multiplexing to perform backup
C. The operation is accomplished using the default channel available
D. The RMAN parallelizes the backup although the parallelism is not set for a channel
