Online Access Free 1z1-034 Practice Test

Your database is in NOARCHIVELOG mode.
One of the two data files belonging to the SYSTEM tablespace is corrupt.
You discover that all online redo logs have been overwritten since the last backup.
Which method would you use to recover the data file using RMAN?

• A.Shut down the instance if not already shut down, restart in mount state, restore all data files for the entire database from the last backup, and restart the instance.
• B.Shut down the instance if not already shut down, restart in mount state, restore the corrupted data file belonging to the system tablespace from the last backup, and restart the instance.
• C.Shut down the instance if not already shut down, restart in MOUNT state, restore both data files belonging to the SYSTEM tablespace from the last backup, and restart the instance.
• D.Shut down the instance if not already shut down, restart In NOMOUNT state, restore all data files for the entire database from the last backup, and restart the instance.
• E.Shut down the instance if not already shut down, restart In MOUNT state, restore all data files belonging to the SYSTEM tablespace from the last backup, and restart the instance.

Examine the following set of RMAN commands:
RMAN> CONFIGURE CHANNELdelDEVICETYPEDISK FORMAT '/u02/backup/%U*;
RKAN>RUN
{
ALLOCATECHANNELchlDEVICETYPEDISK;
EXECUTESCRIPTfull_backup;
}
Which statement is true when the RMAN run block is executed?

• A.The persistent configuration parameter DC1 is overridden because a new channel is allocated in the RMAN run block.
• B.The execution of the script fails because multiple channels cannot coexist.
• C.The new channel, CH1, is ignored because a channel has been configured already.
• D.The script is executed and both the channels are used for the script execution.

Examine the following RMAN script:
RMAN> run {
debug on;
allocate channel c1 type disk;
backup datafile 5;
}
Which statement describes the purpose of the script?

• A.The data file is checked for physical corruption and backed up if found clean.
• B.The existing backup for the data file is checked and the backup is performed if there are changes in the data file after the last backup.
• C.The backup of data file 5 is performed and the interactive messages during the backup are suppressed.
• D.The backup of data file 5 is performed and all SQL statements that are executed during RMAN compilation and their results are displayed

You decided to use Direct NFS configuration in a non-RAC Oracle installation and created the oranfstab file in / etc. Which two statements are true regarding this oranfstab file? (Choose two.)

• A.It is globally available to all Oracle 11g databases on the machine.
• B.It contains file systems that have been mounted by the kernel NFS system.
• C.It contains file systems that have been mounted by Direct NFS.
• D.Its entries are specific to a single database.

You observed the following output for a user session:

What do you infer from the preceding output?

• A.The database instance is enabled to use asynchronous commit
• B.The threshold warning limit is exceeded for the tablespace that is used by the user session
• C.Resumable set for session with sid 18
• D.The user session has entered into a deadlock