Multiple choice technology databases

Which statement adds a member /logs/redo22.log to redo log file group 2?

  1. ALTER DATABASE ADD LOGFILE ‘/logs/redo22.log’ TO GROUP 2;

  2. ALTER DATABASE ADD LOGFILE MEMBER ‘/logs/redo22.log’ TO GROUP 2;

  3. ALTER DATABASE ADD MEMBER ‘/logs/redo22.log’ TO GROUP 2;

  4. ALTER DATABASE ADD LOGFILE ‘/logs/redo22.log’;
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The ADD LOGFILE MEMBER clause adds a redo log member to an existing group. The syntax requires both LOGFILE MEMBER keywords, not just MEMBER.

AI explanation

To answer this question, you need to understand how to add a member to a redo log file group in a database.

Let's go through each option to understand why it is correct or incorrect:

Option A) ALTER DATABASE ADD LOGFILE ‘/logs/redo22.log’ TO GROUP 2; This option is incorrect because it uses the keyword "LOGFILE" instead of "LOGFILE MEMBER". The correct syntax to add a member to a redo log file group is "LOGFILE MEMBER".

Option B) ALTER DATABASE ADD LOGFILE MEMBER ‘/logs/redo22.log’ TO GROUP 2; This option is correct because it uses the correct syntax to add a member to a redo log file group. The keyword "LOGFILE MEMBER" is used to specify the path of the member to be added.

Option C) ALTER DATABASE ADD MEMBER ‘/logs/redo22.log’ TO GROUP 2; This option is incorrect because it uses the keyword "ADD MEMBER" instead of "ADD LOGFILE MEMBER". The correct syntax to add a member to a redo log file group is "ADD LOGFILE MEMBER".

Option D) ALTER DATABASE ADD LOGFILE ‘/logs/redo22.log’; This option is incorrect because it does not specify the group to which the redo log file should be added. The correct syntax to add a member to a redo log file group requires specifying the group number.

The correct answer is Option B) ALTER DATABASE ADD LOGFILE MEMBER ‘/logs/redo22.log’ TO GROUP 2. This option is correct because it uses the correct syntax to add a member to the redo log file group 2.

Keep practicing — related questions