RelationalDBDesign
SiteMap
Recovery Methods
Oracle Recovery
Database Backup
Backup Recovery
«Prev
Next»
Oracle Backup Recovery
Backup Recovery Features
Recovery Manager Features
Oracle Backup Strategies
Backup Features
Backup Recovery Tasks
Using OEM
Using OEM Interface
OEM Conclusion
Recovery Manager Enhancements
RMAN Format Parameter
Executing Backup Scripts
Control File Character
Line Command RMAN
Perform Tablespace Recovery
Perform Database Recovery
Backup Recovery Strategies
Fast-Start Recovery Components
Recovery Components
Understanding Faststart Checkpointing
Faststart Ondemand Rollback
Faststart Parallel Rollback
Automated Standby
Read Only Database.
fast-start Fault Recovery
Backup Recovery Improvements
Oracle Export Import
Duplex Multiple ArchiveLogs
Repairing Corrupted Blocks
Oracle Logminer
Database Backup Reports
Design Report Backup
Data Dictionary Views
Backup Recovery Conclusion
Backup using OEM
Configuring OEM to Use RMAN
Configuring OEM
run From Enterprise Manager
Schedule Enterprise Manager Backup
Backup Strategies
Schedule using backup Wizard
Configuration Manager Conclusion
Recovery Manager Enhancements - Quiz
Oracle Backup
Select the best answer or answers for each question.
1.
What is the utility of a control file within a database environment?
Please select all the correct answers.
A.
The control file is simply another copy of the initialization parameter file. Hence, it is not very important for a database.
B.
The control file has information about the database. It is maintained by the DBA and not used by the database, hence it is not useful to the database.
C.
The control file has critical information about the database, including the name of the database, tablespaces within it, the redo log file and datafiles within it, and the character set. This is a very critical file for a database.
D.
The Oracle database does not have a control file, hence it is not useful to the database.
2.
How important is the character set within a control file?
Please select all the correct answers.
A.
The character set information is not very critical, because it is passed to the database during its creation and is maintained within the database.
B.
The control file does not have any character set information within it, because the file is maintained within the database.
C.
The character set information maintained within the control file is redundant, because this information is maintained within the initialization parameter file.
D.
The database character set information is stored within the control file. This allows access to the database character set before a database is opened. This is necessary for the Recovery Manager to correctly interpret the tablespace names prior to opening the database.
3.
RMAN allows the user to complete the following process:
Please select all the correct answers.
A.
Import a database, but not export a database
B.
Export a database, but not import a database
C.
Import and export a database
D.
Generate the control file
4.
How does the incremental backup within RMAN differ from the incremental backup within export utility?
Please select all the correct answers.
A.
The incremental backup within RMAN and export utility are conducted in exactly the same way.
B.
The export utility performs an incremental backup based on the tables within a schema. Within RMAN, the incremental backup is based on the changed data block within a tablespace, which is faster.
C.
The export utility for Oracle8i does not support incremental backups.
D.
RMAN for Oracle8i does not support incremental backups.
5.
Where does the recovery catalog obtain the details about the target database?
Please select all the correct answers.
A.
From the control file
B.
From the target database
C.
From the initialization parameter file
D.
Scanning the file system that has the target database
6.
What is the best solution for the location of the recovery catalog?
Please select all the correct answers.
A.
The recovery catalog is within the target database, because all the information is in a single place and the backup and recovery will be faster and safer.
B.
It is preferable to have the recovery catalog within another database. This is because if the target database is corrupted or it fails, the recovery by using RMAN and its recovery catalog is extremely difficult.
C.
The target database is the best place to keep the recovery catalog, because when doing a complete backup of the target database, the recovery catalog will also be backed up.
D.
The location of the recovery catalog is not important.
x