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

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.

1. You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameter in the parameter file toYYYY-MM-DD. The default format of which two data types would be affected by this setting? (Choose two.)
A. DATE
B. TIMESTAMP
C. INTERVAL YEAR TO MONTH
D. INTERVAL DAY TO SECOND
E. TIMESTAMP WITH LOCAL TIME ZONE
Answer:BE

2. The database is running in ARCHIVELOG mode and the FORMAT option is not configured in RMAN for diskbackups. You configured the flash recovery area location and size by using the DB_RECOVERY_FILE_DESTand DB_RECOVERY_FILE_DEST_SIZE initialization parameters.Which statement is correct in this scenario?
A. If no other destination is configured for recovery files, then RMAN places the control file autobackups in theflash recovery area by default.
B. If any local destinations for LOG_ARCHIVE_DEST_n are set, then archived redo logs are stored in thesedestinations as well as in the flash recovery area.
C. If the flash recovery area location is configured using the DB_RECOVERY_FILE_DEST initializationparameter, then the RMAN backup of Oracle managed datafiles (OMF) only will go to the flash recovery area bydefault.
D. If the FORMAT option to the RMAN BACKUP command is specified, then RMAN creates backup pieces andimage copies in the flash recovery area with names in the Oracle Managed Files (OMF) format.
Answer:A

3. You defined the Recovery Manager (RMAN) retention policy to recovery window of 7 days by executing thefollowing command:RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;When a backup is performed, what would be the status of this backup after seven days?
A. The backup would be marked as invalid.
B. The backup would be marked as obsolete.
C. The backup would be removed from the media.
D. The backup would be removed from the RMAN repository
Answer:B

4. You set the recovery window to seven days and the backup optimization to ON using the CONFIGUREcommand of Recovery Manager (RMAN). The most recent backup of the TOOLS tablespace to disk was taken onJanuary 3. The TOOLS tablespace is read-only.On February 21, when you execute a command to back up all the tablespaces to disk, you find that RMAN backsup the TOOLS tablespace also, even though the contents of the tablespace have not changed after the backup onJanuary 3.Because there are no changes made to the TOOLS tablespace, you decide that the tablespace should not be backedup by RMAN. What can you to do skip backing up the TOOLS tablespace without changing the current backupoptimization setting?
A. configure a default device for RMAN backups
B. temporarily disable the retention policy for RMAN backups
C. configure automatic channel allocation for RMAN backups
D. use the CONFIGURE command to reconfigure the recovery window to 60 days
Answer:B

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? (Choose two.)
A. a tablespace is taken offline
B. the database instance is restarted
C. a new data file is added to an existing tablespace
D. a successful backup is recorded in the RMAN repository
E. the RMAN connection is disconnected from the target database
Answer:CD