Recovery File Structures   «Prev  Next»
 

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