Managing Redo log   «Prev  Next»
 

Moving Redo Log Files - Quiz


1. You need to drop a log file group, and all you know is that it contains a single member namedg:\oracle\oradata\coin\redocoin06a. Which of the following commands will delete the group?
Please select the best answer.
  A. alter database drop logfile group 'g:\oracle\oradata\coin\redocoin06a';
  B. alter redo log drop group 'g:\oracle\oradata\coin\redocoin06a';
  C. alter database drop logfile 'g:\oracle\oradata\coin\redocoin06a';
  D. alter redo log drop file 'g:\oracle\oradata\coin\redocoin06a';

2. Which of the following commands will add a member to group 5?
Please select the best answer.
  A. alter logfile group 5 add member 'filename';
  B. alter database alter group 5 add member 'filename';
  C. alter logfile add member 'filename' to group 5;
  D. alter database add logfile member 'filename' to group 5;

3. You want to move a member to a new disk. You can't afford to disrupt your database users by stopping the database. Which of the following approaches can you take?
Please select the best answer.
  A. Move the file by executing thealter database move logfile member command.
  B. Copy the file while the database is running, and then issue analter database rename file command.
  C. Create a new member file on the new disk, and then delete the unwanted member file from its location on the old disk.
  D. While the database is running, issue analter database rename file command to have Oracle move the file.

Correct answers:

Your Score: 0