RelationalDBDesign
RelationalDBDesign
SiteMap
Architecture
DB Admin
Connect
Objects
Backup Recovery
Admin Tasks
Manual | Automatic Archiving
«Prev
Next»
Backup Recovery
Backup Considerations
Oracle Memory Processes
Oracle Recovery Data Structures
Archivelog Noarchivelog
Archiving Options
Manually Archiving - Quiz
Each question is worth one point. Select the best answer or answers for each question.
1.
When using server manager, which command(s) can be used to manually archive all the online redo log file groups?
Please select
all the correct answers
.
A.
alter system archive log all;
B.
alter system archive log current;
C.
alter system archive log group;
D.
archive log group;
2.
When using server manager, which command will enable
ARCH
to automatically archive the redo log files?
Please select
the best answer
.
A.
alter system archive log start to ‘e:\oracle8\archive’;
B.
alter archive log start to ‘e:\oracle8\archive’;
C.
alter system start archive log to ‘e:\oracle8\archive’;
D.
alter system start archive log to ‘e:\oracle8\archive’;
3.
What is the proper setting of the init.ora parameter to start automatic archiving of redo logs at instance startup?
Please select
the best answer
.
A.
LOG_ARCHIVE=
TRUE
B.
LOG_ARCHIVE_START=
TRUE
C.
ARCH
IVE_LOG_START=
TRUE
D.
ARCH
IVE_LOG=START
4.
Your init.ora parameter to enable automatic archive of redo logs at instance startup is set to
TRUE
. While the database is running you issue the following command in server manager; alter system archive log stop. You then bring your database down and back up. What will be the state of your archiving?
Please select
the best answer
.
A.
The init.ora parameter is FALSE, archiving is enabled and set for manual archiving.
B.
The init.ora parameter is
TRUE
, archiving is enabled and set for automatic archiving.
C.
The init.ora parameter is
TRUE
, archiving is disabled.
D.
The init.ora parameter is set to FALSE and archiving is disabled.