Because of hardware failure, you decided to drop a redo log member from the database. Which condition should be met to drop a redo log file?()
A、 The redo log file should belong to an active group.
B、 The redo log file should belong to an inactive group.
C、 The redo log file should belong to the current group.
D、 The redo log file can be dropped only if all the transactions are stopped.
E、 Before a redo log file is dropped, it should be deleted from the operating system (OS).
相关问题推荐
-
Your database is in ARCHIVELOG mode. You have two online redo log groups each of which contains one redo member. When you attempt to start the database, you receive the following errors: ORA-00313: open failed for members of log group 1 of thread 1 ORA-00312: online log 1 thread 1: ’D:///REDO01.LOG’ You discover that the online redo log file of the current redo group is corrupted. Which statement should you use to resolve this issue?()
A、 SQL>ALTER DATABASE DROP LOGFILE GROUP 1;
B、 SQL>ALTER DATABASE CLEAR LOGFILE GROUP 1;
C、 SQL>ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;
D、 SQL>ALTER DATABASE DROP LOGFILE MEMBER ’D:///REDO01.LOG’;
-
In which two conditions are resumable statements suspended?()
Awhen a user exceeds the space quota
Bwhen a user session is terminated
Cwhen a table that is being accessed by the current transaction is not found
Dwhen a user manually suspends the statement
Ewhen the maximum extents of a segment is reached
-
You are maintaining the SALES database on Oracle 10g. You have added a new disk to a disk group. Automatic Storage Management performs the rebalancing activity. You want to speed up the rebalancing activity. Which parameter will you specify to control the speed of the rebalancing activity? ()
A、 ASM_POWER_LIMIT
B、 ASM_DISKSTRING
C、 ASM_DISKGROUPS
D、 LARGE_POOL_SIZE
-
What are the two advantages of RMAN Block Media Recovery (BMR) over file/x7flevel recovery?()
ABMR lowers the mean time to recover (MTTR).
BBMR supports pointintime recovery of individual data blocks.
CBMR enables you to use incremental backups for block recovery.
DBMR enables recovery even when the database is not mounted or open.
EBMR enables you to use proxy backups to perform block media recovery.
FBMR enables increased availability of data during recovery because the data file that requires a recovery can remain online.
-
You need to create a schedule that will run a job on the second Friday of each month. What should the repeat interval of the schedule be set to?()
A、 FREQ = MONTHLY; BYDAY = 2FRI;
B、 FREQ = MONTHLY; BYDAY = FRI(2);
C、 FREQ = MONTHLY; BYDAY = FRI2;
D、 FREQ = MONTHLY; BYDAY = -2FRI;