The latest Oracle 1Z0-043 exam demo(2)

High quality and Value for the 1Z0-043 Exam.
Killtest Practice Exams for oracle database 10g:administration ii 1Z0-043 are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development.

100% Guarantee to Pass Your 10g DBA exam and get your 10g DBA Certification. We guarantee your success in the first attempt. If you do not pass the 1Z0-043 exam (oracle database 10g:administration ii) on your first attempt we will give you a FULL REFUND of your purchasing fee AND send you another same value product for free.

6. In the parameter file of your production database, the CONTROL_FILE_RECORD_KEEP_TIME parameter isset to 31. What would be the impact of this setting on the backup that is being performed by using RecoveryManager (RMAN)?
A. The backup would be retained on the media for 31 days.
B. The backup would be maintained in the recovery catalog for 31 days.
C. The backup metadata would be retained in the control file for 31 days.
D. The backup metadata would be maintained in the recovery catalog for 31 days.
E. Automatic backups of the control file will be retained in the flash recovery area for 31 days.
Answer:C

7. You observe that the senior database administrator always uses the following command when connecting toRecovery Manager (RMAN), and then starts executing commands to backup the database files:$ rman target /What would be the effect of this command?
A. RMAN would use the current operating system location to place the backup.
B. RMAN would use the control file of the target database to maintain the backup.
C. RMAN would use the recovery catalog of the target database to maintain the backup.
D. RMAN would use the control file of the target database to maintain the backup metadata.
E. RMAN would use the recovery catalog of the target database to maintain the backup metadata.
Answer:D

8. You execute the following command to perform a backup by using Recovery Manager (RMAN):RMAN> run{allocate channel c1 type sbt;backup datafile 1;The command errors out. A part of the error message is as follows:RMAN-03009: failure of allocate command on c1 channelORA-19554: error allocating device, device type: SBT_TAPE, device name:What could explain why the statement failed?
A. sbt is not a valid device type.
B. Media Management Library was not loaded.
C. The sbt device cannot be used for data file backups.
D. No path was defined in the ALLOCATE CHANNEL command.
E. The channel is currently being used by another RMAN session.
Answer:B

9. View the Exhibit.You executed the following command to perform a backup of the USERS tablespace: BACKUP TABLESPACE USERS;Which three types of files are backed up? (Choose three.)
A. password file
B. online redo log files
C. the current control file
D. archived redo log files
E. the current server parameter file
F. all the data files belonging to the USERS tablespace
G. data files belonging to the USERS tablespace and all the default tablespaces
Answer:CEF

10. You executed the following command in Recovery Manager (RMAN) to perform a backup of the DETTBStablespace:RMAN> BACKUP TABLESPACE DETTBS;Under which conditions would this command execute successfully? (Choose all that apply.)
A. The database is in NOMOUNT state.
B. The database is in ARCHIVELOG mode and the tablespace is online.
C. The database is in ARCHIVELOG mode and the tablespace is offline.
D. The database is in NOARCHIVELOG mode and the tablespace is online.
E. The database is in NOARCHIVELOG mode and the tablespace is offline.
Answer:BCE