RelationalDBDesign
RelationalDBDesign
SiteMap
Architecture
DB Admin
Connect
Objects
Backup Recovery
Admin Tasks
Recovery File Structures
«Prev
Next»
Backup Recovery
Backup Considerations
Oracle Memory Processes
Oracle Recovery Data Structures
Archivelog Noarchivelog
Archiving Options
Oracle Redo log - quiz
1.
What information will
V$LOG
provide about your redo logs?
Please select
the best answer
.
A.
Control file log history information
B.
Log file member information
C.
Log file group information
D.
User connection logins
2.
If we have a multiplexed redo logs with two members per group, which answer below would add redo log group 3?
Please select
the best answer
.
A.
Alter database add logfile group 3
(‘c:\oracle8\database\g3_loga.ora’)
B.
Alter database modify logfile group 3
(‘c:\oracle8\database\g3_loga.ora’)
C.
Alter database add logfile group 3
(‘c:\oracle8\database\g3_loga.ora’,)
‘c:\oracle8\database\g3_logb.ora’)
D.
Alter logfile add group 3
(‘c:\oracle8\database\g3_loga.ora’,
‘c:\oracle8\database\g3_logb.ora’)
3.
When using server manager, which of the following would drop the redo log group 3 created in the previous question?
Please select
the best answer
.
A.
svrmgr>alter logfile drop group 3
B.
svrmgr>alter database remove group 3
C.
svrmgr>alter database drop group 3
D.
svrmgr>update database remove logfile 3