Online Comptia Certification Exam Braindumps–Pass4side

Get more exam demo?
Visit  www.pass4side.com

1. You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameter in the parameter file to
YYYY-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 disk
backups. You configured the flash recovery area location and size by using the DB_RECOVERY_FILE_DEST
and 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 the
flash recovery area by default.
B. If any local destinations for LOG_ARCHIVE_DEST_n are set, then archived redo logs are stored in these
destinations as well as in the flash recovery area.
C. If the flash recovery area location is configured using the DB_RECOVERY_FILE_DEST initialization
parameter, then the RMAN backup of Oracle managed datafiles (OMF) only will go to the flash recovery area by
default.
D. If the FORMAT option to the RMAN BACKUP command is specified, then RMAN creates backup pieces and
image 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 the
following 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.
Pass4Side Orcal 1Z0-043
Pass4Side Help you pass any IT Exams! Page 3 of 9
Answer:B

4. You set the recovery window to seven days and the backup optimization to ON using the CONFIGURE
command of Recovery Manager (RMAN). The most recent backup of the TOOLS tablespace to disk was taken on
January 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 backs
up the TOOLS tablespace also, even though the contents of the tablespace have not changed after the backup on
January 3.
Because there are no changes made to the TOOLS tablespace, you decide that the tablespace should not be backed
up by RMAN. What can you to do skip backing up the TOOLS tablespace without changing the current backup
optimization 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

6. In the parameter file of your production database, the CONTROL_FILE_RECORD_KEEP_TIME parameter is
set to 31. What would be the impact of this setting on the backup that is being performed by using Recovery
Manager (RMAN)?
A. The backup would be retained on the media for 31 days.
Pass4Side Orcal 1Z0-043
Pass4Side Help you pass any IT Exams! Page 4 of 9
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 to
Recovery 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 channel
ORA-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.
Pass4Side Orcal 1Z0-043
Pass4Side Help you pass any IT Exams! Page 5 of 9
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:<
RMAN> 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 DETTBS
tablespace:
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

Powered by MightyAdsense