Which statement should you use to resolve this issue?
A. ALTER DATABASE DROP LOGFILE GROUP 1;
B. ALTER DATABASE CLEAR LOGFILE GROUP 1;
C. ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;
D. ALTER DATABASE DROP LOGFILE MEMBER ‘D:\REDO01.LOG’;
Answer:C
Which statement should you use to resolve this issue?
A. ALTER DATABASE DROP LOGFILE GROUP 1; B. ALTER DATABASE CLEAR LOGFILE GROUP 1; C. ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1; D. ALTER DATABASE DROP LOGFILE MEMBER ‘D:\REDO01.LOG’;