RelationalDBDesign
SiteMap
Database Architecture
Database Admin
Managing Users
Managing Objects
Backup Recovery
Admin Tasks
Recovery File Structures
«Prev
Backup Recovery
Backup Considerations
DBA Responsibilities
DBA Role Considerations
Operational Considerations
Technical Considerations
Disaster Recovery Plan
Plans Testing
Backup Recovery Strategy
Oracle Memory Processes
Oracle Instance Structure
DBWR Arch Process
Oracle Recovery Data Structures
DB Configuration File
Database Control File
Control File Maintenance
RedoLog Files
Writing Redo Log Files
Multiplexing Redo Log
Archive Log Files
Checkpoint Process
Physical File Placement
State Structure Database
File Components Conclusion
Archivelog Noarchivelog
Physical Logical Backups
Archivelog Mode
Archiving Options
Archive Process Options
Normal Arch Processing
Manual Archiving
Auto ArchiveLog Options
Retrieve ArchiveLog
Standby Database
VM Conclusion
Oracle Database Installation - Quiz
Each question is worth one point. Select the best answer or answers for each question.
1.
In a default installation with your ORACLE_HOME as c:\oracle8 and your database as ORC1, where will you likely find the file initorc1.ora?
Please select
the best answer
.
A.
C:\oracle8
B.
C:\oracle8\bin
C.
C:\oracle8\database
D.
C:\oracle8\sysman
2.
Which of the following files should you backup on a regular basis?
Please select
all the correct answers
.
A.
initorc1.ora
B.
ctr1orc1.ora
C.
index table spaces
D.
All the files in the ORACLE_HOME directory
3.
Assuming that you have made no database structure modifications, what will guarantee a point in time recovery of your database after a complete system crash two days after your last complete system backup?
Please select
the best answer
.
A.
Backed up copies of your control files, init.ora files, and your redo log files from both days
B.
Backed up copies of your redo log files from both days and your control files
C.
Backed up copies of your redo log files from both days
D.
Backed up copies of your archive log files
4.
What will happen if
LGWR
has a problem writing to one redo log member in a multiplexed redo log group?
Please select
the best answer
.
A.
LGWR
will terminate bringing the database down.
B.
LGWR
will continue writing to the other redo log file.
C.
LGWR
will close the bad redo log file, create a new one and then continue processing.
D.
LGWR
will drop the group and continue processing as long as there are two groups available.
5.
If your control files are corrupt and you cannot bring the database back up, how can you recreate them?
Please select
the best answer
.
A.
Delete the bad control file and restore a backup copy.
B.
Using server manager, connect as internal and start the database with nomount. Then issue the command
C.
Alter database restore backup controlfile.
D.
Using server manager, connect as internal and start the database with nomount. Use the output from alter database backup controlfile to trace to recreate the control file. Then restart the database.
E.
Using server manager, connect as internal and start the database with nocontrolfile. Then issue the command Alter database create controlfile c:\oracle8\database\ctl1orc1.ora. Bring the database down and then back up.
6.
A control file contains the following information:
Please select
all the correct answers
.
A.
Names and locations of associated data files and redo log files
B.
Current log sequence number
C.
Checkpoint information
D.
Archive log information