单项选择题
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.()
单项选择题 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?()
多项选择题 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.)