单选题

The instance abnormally terminates because of a power outage.  Which statement is true about redo log filesduring instance recovery()

AInactive and current redo log files are required to accomplish recovery.

BOnline and archived redo log files are required to accomplish instance recovery.

CAll redo log entries after the last checkpoint are applied from redo log files to data files.

DAll redo log entries recorded in the current redo log file until the checkpoint position are applied to data files

正确答案

来源:www.examk.com

答案解析

相似试题
  • You execute the following command to start an Automatic Storage Management (ASM) instance:   SQL>STARTUP;   In which of the following modes will the ASM instance start?()

    单选题查看答案

  • The SQL Tuning Advisor configuration has default settings in your database instance.  Which recommendation is automatically implemented after the SQL Tuning Advisor is run as part of the automatic maintenance task?()

    单选题查看答案

  • You specify a nonzero value for the MEMORY_TARGET initialization parameter,but do not set the PGA_AGGREGATE_TARGET or the SGA_TARGET parameters. You restart your database instance.  Which statement about the result is true?()

    单选题查看答案

  • Given: What creates the appropriate DateFormat object and adds a day to the Date object?()

    单选题查看答案

  • Your database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.  Which tool or utility would you use to start the listener?()

    单选题查看答案

  • Your database is open and users are connected using the LISTENER listener. The new DBA of the system stops the listener by using the following command: LSNRCTL> STOP  What would happen to the sessions that are presently connected to the database instance?()

    单选题查看答案

  • You are managing an Oracle Database 11g instance and an Oracle Database 10g instance on the same machine. Both instances use the ASM instance as storage. Which statement regarding the ASM disk group compatibility attributes are true in this scenario?()

    多选题查看答案

  • Your database is open and users are connected using the LISTENER listener. The new DBA of the system stops the listener by using the following command:  LSNRCTL> STOP  What would happen to the sessions that are presently connected to the database instance?()

    单选题查看答案

  • in your database instance, the STATISTICS_LEVEL initialization parameter is set to BASIC.  What is the impactof this setting()

    单选题查看答案