单项选择题
Which statement is true about the loss of system-critical data files in ARCHIVELOG mode？（）
A.The data files can be recovered till the last committed transaction.
B.The data files can be recovered without shutting down the database.
C.The data file is taken offline automatically； the database remains open.
D.The data files can be recovered to the time of the most recent backup.
相关考题
-
单项选择题
You executed the following command to start the database： SQL> STARTUP ORACLE instance started. Total System Global Area 281018368 bytes Fixed Size 789000 bytes Variable Size 229635576 bytes Database Buffers 50331648 bytes Redo Buffers 262144 bytes ORA-00205： error in identifying controlfile， check alert log for more info Which view would you query at this stage to investigate this missing control file？（）
A.V$INSTANCE
B.V$CONTROLFILE
C.DBA_CONTROL_FILES
D.V$DATABASE_PROPERTIES
E.V$CONTROLFILE_RECORD_SECTION -
多项选择题
Inyourdatabase，theLogWriter（LGWR）processisunabletowritetoamemberofacurrentredologgroupduetoread/writefailure.Whichtwoeffectswouldyouseeinyourdatabase？（）
A.The database instance aborts.
B.The database operation temporarily halts till the member becomes available.
C.Writing proceeds as normal. LGWR writes to the available members of a group and ignores the unavailable members.
D.The member would be marked as STALE and an error message would be written to the alert log file and LGWR trace file.
E.The status of the group changes to INACTIVE and an error message would be written to the alert log file and LGWR trace file. -
多项选择题
WhichthreepiecesofinformationaretobemandatorilyprovidedwhilecreatinganewlistenerusingEnterpriseManagerDatabaseControl？（）
A.the port used by the listener
B.the protocol used by the listener
C.the server name where the listener runs
D.the log file and trace file destination for the listener
E.the database services to be registered with the listener
