Moving Redo Log Files - Quiz

Each question is worth one point. Select the best answer for each question.

1.	You need to drop a redo log group, and all you know is that it contains a single member named g:\oracle\oradata\coin\redocoin06a. Which command 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 command will add a redo log 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 redo log member to a new disk, but you cannot disrupt database users by stopping the database. Which approach can you take? Please select the best answer.
A.		Move the file by executing the ALTER DATABASE MOVE LOGFILE MEMBER command.
B.		Copy the file while the database is running, and then issue an ALTER DATABASE RENAME FILE command.
C.		Create a new member file on the new disk, and then drop the unwanted member file from its old location.
D.		While the database is running, issue an ALTER DATABASE RENAME FILE command to have Oracle move the file.