Online Test Oracle 9i Recovery and Backup (RMAN)

The strategy pursued in backing up a database using RMAN consists of creating backup data files to be stored on disk for later usage. In RMAN terminology, this strategy is better known as which of the following choices?
Backup sets
Tags
Image copies
Incremental
The DBA is reviewing the alert log for a database and encounters an ORA-00600 error containing numerous codes. This error seems to occur at intervals that coincide with the execution of an important batch process. Which choice best identifies how the DBA should proceed?
Attempt review of all datafiles using DBVERIFY
Ensure that the core dump directory is empty and contact Oracle Support
Stop running the batch process
Remove all background and user trace files and contact Oracle Support
The DBA is planning backup capacity using RMAN. Which of the following choices best describes streaming?
The process by which RMAN communicates with the underlying OS
The method used for writing backup sets to tape
The ability RMAN has to take multiple backups of multiple databases at the same time
The performance gain added by parallel processing in RMAN
The DBA has executed a level 0 backup and a level 1 backup. If the DBA then executes another level 1 backup, what information in the database will be backed up?
All changed blocks since the level 1 backup only
All changed blocks since the level 2 backup
All blocks in the database
No changes will be saved
While backing up the Oracle database, the machine hosting Oracle loses power unexpectedly. After restarting the machine, what must be done to recover the database?
Issue the ALTER DATABASE DATAFILE END BACKUP command and open the database
Recover the database using offline backups and open the database using the RESETLOGS option
Recover the database using logical exports and open the database
Restore the database from the most recent backup, roll forward, and open the database
The DBA needs to find information about RMAN backups in the Oracle database. She or he queries the contents of the V$BACKUP_CORRUPTION view to determine specific information. From where does Oracle draw the information found in this view?
Control file
Recovery catalog
SGA
RMAN
Instance failure has occurred as the result of the DBA tripping over the host machine’s power cord. Which of the following steps does Oracle perform first as part of crash recovery on an Oracle database?
Server process rolls back uncommitted transactions
DBW0 uses redo information to write data to datafiles.
SMON detects unsynchronization between datafiles
The database opens
At the command prompt, the DBA executes DBVERIFY using the following command: dbv blocksize=4096 logfile=dbv.log feedback=0 Which of the following choices best identifies the result of this command?
The execution will corrupt all datafiles.
DBVERIFY will detect corruption in all datafiles.
DBVERIFY will return an error.
DBVERIFY will change all block sizes to 4096.
Which oracle background process frees SGA resources that were allocated to a user process that failed?
PMON
SMON
CKPT
LGWR
If you cross check the back up piece that was previously Marked as EXPIRED but is now available, what would the status of this backup piece be in the RMAN repository?
EXPIRED
AVAILABLE
UNAVAILABLE
ACCESSIBLE
Which of the following files contains records that do not meet the specified load criteria in the SQL* loader control file?
Log file
Discard file
Parameter file
Bad file
Which server stack communication layer corresponds to the client application layer in a distributed environment?
RDBMS
Application
Oracle Net Foundation
Network protocol
Which one of the following files includes the parameter NAMES.DIRECTORY_PATH(HOSTNAME)?
Listener.ora
Trasnames.ora
Cman.ora
Sqlnet.ora
Which of the following parameters must be specified to define the number of dispatchers that need to be started ?
MAX_DISPATCHERS
DISPATCHERS
MIN_DISPATCHERS
SHARED-SERVERS
As a DBA which of the following methods can you use to make a backup of your table?
RMAN UTILITY
IMPORT UTILITY
EXPORT UTILITY
O/S BACKUP COMMAND
What is the maximum data base block size supported for oracle 9i database?
16 KB
32 KB
64 KB
128 KB
Which data dictionary views displays the error information related to a data file, when internal read fails on that file?
V$DATAFILE
V$DATAFILE_HEADER
V$DBFILE
V$DATAFILE_ERRORS
Which of the following views must you query to identify any corrupt data file blocks that have been detected during backup set creation?
V$COPY_CORRUPT
V$COPY-CORRUPTION
V$ BACKUP-CORRUPT
V$BACKUP-CORRUPTION
Which of the following commands can not be executed when the database open?
RECOVER DATABASE
RECOVER TABLE SPACE
RECOVER DATAFILE
ALTER DATABASE RECOVER DATA FILE
Which of the following dynamic view would you query to identify the online CURRENT REDOLOG GROUP?
V$LOG
V$LOGHIST
V$LOGFILE
V$LOG_HISTORY
Description:

This test is focused more on Recovery Management(RMAN) and Database restoring and back up skills of a DBA
Disclaimer: Content, such as images used in the questions (if any), have been picked up from various places for the sole purpose of Instruction.

Discussion

Vali Bawany

I got 20/20

1753 days 3 hours 58 minutes ago

Your Facebook Friends on WizIQ

More Tests By Author

ASP Server Controls
10 Questions | 667 Attempts

ASP.NET, Namespaces ASP.NET
10 Questions | 2028 Attempts

An ASP.NET Application
10 Questions | 437 Attempts

Explore Similar Courses

Oracle ADF Online

Price:$100