Set the BACKUP_TAPE_IO_SLAVES parameter to FALSE
Set the BACKUP_TAPE_IO_SLAVES parameter to TRUE
Use compression when performing tape backups
Configure multiple SBT channels
第1题:
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.)
第2题:
You work as a database administrator for Certkiller .com. You want to create your database with the automatic undo management feature enable.Which two tasks must you perform to achieve this?()
第3题:
You want to enable automatic PGA memory management in your database. Which setting is required to achieve this?()
第4题:
You are tuning RMAN to optimize performance. You want tape I/O to be asynchronous when you perform tape backups.Which action should you take?()
第5题:
You want to check all the data blocks being written to the datafiles by analyzing the data on each block every time the DBWn process writes. Which action will you perform to check the data blocks?()
第6题:
You want to monitor and control the resource usage by sessions. You want to be warned automatically when more than 100 sessions are opened with your database. What action would you take to achieve this?()
第7题:
You want to perform a backup of your database to tape. Which backup format can you use?()
第8题:
CONFIGURE DEFAULT DEVICE TYPE TO TAPE MEDIA
CONFIGURE DEFAULT DEVICE TYPE TO TAPE
CONFIGURE DEFAULT DEVICE TYPE TO SBT
CONFIGURE DEFAULT DEVICE TYPE TO SBT_TAPE
第9题:
Set the DB_SECUREFILE parameter to PERMITTED
Set the DB_ULTRA_SAFE parameter to DATA_ONLY
Set the DB_LOCK_CHECKSUM parameter to TYPICAL
Set the DB_LOST_WRITE_PROTECT parameter to TYPICAL
第10题:
Set the BACKUP_TAPE_IO_SLAVES parameter to FALSE
Set the BACKUP_TAPE_IO_SLAVES parameter to TRUE
Use compression when performing tape backups
Configure multiple SBT channels
第11题:
Set MEMORY_TARGET to zero
Set the STATISTICS_LEVEL parameter to BASIC
Set the WORKAREA_SIZE_POLICY parameter to MANUAL
Set the PGA_AGGREGATE_TARGET parameter to nonzero value
第12题:
backup set only
image copy only
only user-managed backup
both image copy and backup set
only incremental image copy backup
第13题:
You are tuning RMAN to optimize performance. You want tape I/O to be asynchronous when you perform tape backups. Which action should you take?()
第14题:
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 the RMAN. To accomplish the backup, you issued the following RMAN command: RMAN> BACKUP SECTION SIZE 300M TABLESPACE users; Which two statements are true regarding the execution of the above command?()
第15题:
You are managing an Oracle Database 11g database. You want to take a backup on tape drives of the USERS tablespace that has a single data file of 900 MB. You have tape drives of 300 MB each. To accomplish the backup, you issued the following RMAN command: RMAN> BACKUP SECTION SIZE 300M TABLESPACE users; Identify the appropriate configuration to accomplish faster and optimized backups using the above command.()
第16题:
You are tuning RMAN to optimize performance.You want tape I/O to be asynchronous when you perform tape backups. Which action should you take?()
第17题:
You have the following requirements in relation to the detection of block corruption for your database instance: Check for logical self-consistency of data blocks when modified in memory. Checksums are calculated before and after the block change. Checks are performed for the lost writes to the physical standby database. Which method would help you perform the above checks automatically?()
第18题:
You are managing an Oracle Database 11g database. You want to take a backup on tape drives of the USERS tablespace that has a single data file of 900 MB. You have tape drives of 300 MB each. To accomplish the backup, you issued the following RMAN command: RMAN>BACKUP SECTION SIZE 300M TABLESPACE users; What configuration should be effected to accomplish faster and optimized backups by using the above command?()
第19题:
Set the BACKUP_TAPE_IO_SLAVES parameter to FALSE
Set the BACKUP_TAPE_IO_SLAVES parameter to TRUE
Use compression when performing tape backups
Configure multiple SBT channels
第20题:
The SBT channel must be configured, with the default parallelism setting for the SBT device set to 1
The COMPATIBLE initialization parameter for the database instance must be set to at least 10.0
The SBT channel must be configured, with the parallelism setting for the SBT device set to 3
The SBT channel must be configured, with the MAXPIECESIZE set to 300 MB
第21题:
Set the BACKUP_TAPE_IO_SLAVES parameter to FALSE
Set the BACKUP_TAPE_IO_SLAVES parameter to TRUE
Use compression when performing tape backups
Configure multiple SBT channels
第22题:
The tape I/O performed is asynchronous
The tape buffer is allocated from the System Global Area (SGA)
The tape buffer is allocated from the Program Global Area (PGA)
Oracle I/O uses an interrupt mechanism to determine when each I/O completes
第23题:
The SBT channel must be configured, with the MAXPIECESIZE set to 300 mb.
The SBT channel must be configured, with the parallelism setting for the SBT devices set to 3.
The COMPATIBLE initialization parameter for the database instance must be set to at least 10.0.
The SBT channel must be configured, with the default parallelism setting for the SBT devices set to 1
第24题:
Set the value of the DB_BLOCK_CHECKING initialization parameter to TRUE
Use the ANALYZE utility.
Use the DBVERIFY utility.
Use the DBMS_REPAIR package.