RelationalDBDesign
SiteMap
Database Architecture
Database Admin
Managing Users
Managing Objects
Backup Recovery
Admin Tasks
Controlfile DB Parameters
«Prev
DBA Taks
Database Monitoring
Control File Parameters
Protecting Control Files
Removing Control File
Add Control File
Backingup Control File
Recreating Control Files
Checking Parameter Values
v Parameter Dynamic
Changing DB Parameters
Managing DB Parameters
Managing Redo Log
Protecting redoLog Files
Listing RedoLog Files
Create Redo Log Files
Dropping Redo Log Files
Moving Redo Log Files
Manually Switch Log Files
Managing RedoLog Conclusion
Redolog Files
archivelog-mode
archive-log-destination
naming-archive-log-files
manually-archiving-log-file
archive-log-history
archivelog-mode-conclusion
Manage Tablespace Files
Multiplexing Control Files - Quiz
1.
When deleting a control file, what two things must you do?
Please select
the best answer
.
A.
Remove the file's name from the
control_file
initialization parameter in your database's initialization file and restart the database.
B.
Restart the database and then remove the control file's name from the list specified for the control_files initialization parameter.
C.
Copy the control file and then remove the control file's name from the list specified for the control_files initialization parameter.
D.
Copy the control file and remove the
control_file
initialization parameter from your database's initialization file.
2.
Why should you multiplex your database control file?
Please select
the best answer
.
A.
To spread control file input/output evenly across as many drives as possible
B.
To increase the performance of your database
C.
To ensure that losing any one disk does not cause you to lose the control file
D.
To add more space for Oracle to use in recording information about the database
3.
When adding a new control file to a database, what must you do before copying one of the existing control files?
Please select
the best answer
.
A.
Take that file offline using the
ALTER CONTROLFILE
command.
B.
Place an entry in the parameter file for the new control file.
C.
Turn archiving off so that checkpoints are not recorded.
D.
Shut down the database to ensure that the control file is closed.
4.
What are two key things you must be sure of when adding or removing control files?
Please select
all the correct answers
.
A.
The database is shut down when copying or deleting existing redo log files.
B.
You issue the
ALTER CONTROLFILES
command to tell Oracle of the changes.
C.
Archivelog mode is enabled so that control file changes are recorded in the redo log.
D.
The
control_files
parameter reflects the correct list of files when restarting the database.