It contains data till the last backup
It contains all data from target database until the current time
It contains all data from only the committed transactions in the target database
It contains all data except that which is used by the transactions in the current online redo file of target database
第1题:
A. 90 MB
B. 272 MB
C. 362 MB
D. 1,440 MB
第2题:
Examine the following scenario:The target database instance is running. The most recent backup available for the target database was taken two days ago. Log files switches have occurred in last two days. The target database is duplicated on the same host, using the Recovery Manager (RMAN) duplicate command as follows:Which statement is true about the duplicate database in this scenario?()
A. It contains data till the last backup
B. It contains all data from target database until the current time
C. It contains all data from only the committed transactions in the target database
D. It contains all data except that which is used by the transactions in the current online redo file of target database
第3题:
A. The data files of the read-only tablespaces in the target database are not duplicated
B. The read-only tablespaces in the target database are still defined in new the database
C. The read-only tablespaces in the target database are changed to online after duplication
D. The data files of the read-only tablespaces in the target database get duplicated
E. The read-only tablespaces in the target database are not defined in the new database
第4题:
You work as a database administrator for Supportcenter.cn. The database is open. A media failure has occurred, resulting in loss of all the control files in your database. Which statement regarding the database instance is true in this scenario?()
第5题:
In Recovery Manager (RMAN), you have set control file autobackup to ON by using the following command: CONFIGURE CONTROLFILE AUTOBACKUP ON; Which two events would cause the control file to be backed up automatically? ()
第6题:
Examine the following command that is used to duplicate a database on the same host:RMAN> RUN{ALLOCATE AUXILIARY CHANNEL, aux 1 DEVICE TYPE DISK;DUPLICATE TARGET DATABASE TO auxdb SKIP READONLY; \ }Which two statements describe the effect after the database is duplicated successfully? ()(Choose two)
A. The data files of the read-only tablespaces in the target database are not duplicated
B. The read-only tablespaces in the target database are still defined in new the database
C. The read-only tablespaces in the target database are changed to online after duplication
D. The data files of the read-only tablespaces in the target database get duplicated
E. The read-only tablespaces in the target database are not defined in the new database
第7题:
Examine the following parameters for a database instance: MEMORY_MAX_TARGET=0MEMORY_TARGET=0SGA_TARGET=0PGA_AGGREGATE_TARGET=500mWhich three initialization parameters are not controlled by Automatic Shared Memory Management (ASMM)?()
A. LOG_BUFFER
B. SORT_AREA_SIZE
C. JAVA_POOL_SIZE
D. STREAMS_POOL_SIZE
E. DB_16K_CACHE_SZIE
F. DB_KEEP_CACHE_SIZE
第8题:
A. The MEMORY_MAX_TARGET parameter is automatically set to 500 MB
B. The value of the MEMORY_MAX_TARGET parameter remains zero till it is changed manually
C. The PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set to zero
D. The lower bounds of PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to 90 MB and 270 MB, respectively
第9题:
To implement Automatic Management (AMM), you set the following parameters: When you try to start the database instance with these parameter settings, you receive the following error message: SQL > startup ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information. Identify the reason the instance failed to start.()
第10题:
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?()