多选题What are the consequences of executing the SHUTDOWN ABORT command？ （）AThe database files are synchronized.BUncommitted changes are not rolled back.CThe database is closed， but the instance is still started.DDatabase buffers and redo buffers are not wri

题目
多选题
What are the consequences of executing the SHUTDOWN ABORT command？ （）
A

The database files are synchronized.

B

Uncommitted changes are not rolled back.

C

The database is closed， but the instance is still started.

D

Database buffers and redo buffers are not written to the disk.

E

The database undergoes automatic media recovery during the next startup.

相似考题

1.What are the consequences of executing the SHUTDOWN ABORT command？ （）A、The database files are synchronized.B、Uncommitted changes are not rolled back.C、The database is closed， but the instance is still started.D、Database buffers and redo buffers are not written to the disk.E、The database undergoes automatic media recovery during the next startup.

2. You are in the middle of a transaction updating a very important table. The machine on which a database wasrunning reboots because of power outage. This caused a database instance failure. Which statement is true inthis situation（）A、The online redo log files and archived redo log files are required to accomplish the recovery.B、The uncommitted transaction will be committed at the next startup of the database instance.C、The uncommitted transaction is rolled back automatically at the next opening of the database.D、The DBA has to perform the recovery on the database to recover the uncommitted transaction

3. Your database is configured in NOARCHIVELOG mode. All the control files have been lost due to a hard disk failure but the data files are not lost. You have the closed whole database backup available to you.  Which two statements are true in this scenario？（）A、The instance aborts.B、The database cannot be recovered.C、The database can be recovered by restoring the control files from the backup.D、The database remains opened and you have to shut it down with the ABORT option.E、The database can be restored till the point of the last closed whole database backup.

4. Upon starting your database， you receive the following error：   SQL> startup ORACLE instance started.  Total System Global Area 171581440 bytes Fixed Size 1298640 bytes Variable Size 146804528 bytes Database Buffers 20971520 bytes Redo Buffers 2506752 bytes Database mounted.  ORA-00313： open failed for members of log group 1 of thread 1  ORA-00312： online log 1 thread 1： ’/oracle01/oradata/orcl/redo01.log’ ORA-00312： online log 1 thread 1： ’/oracle01/oradata/orcl/redo01a.log’   You can choose from the following steps：   a. Restore the database datafiles.  b. Issue the alter database clear unarchived logfile group 1 command. c. Issue the alter database open command.  d. Issue the alter database open resetlogs command.  e. Recover the database using point-in-time recovery. f. Issue the Startup Mount command to mount the database.  g. Back up the database.  Which is the correct order of these steps in this case？（）A、a， f， e， d， gB、f， e， dC、f， b， c， gD、a， f， cE、The database cannot be recovered.

更多“多选题What are the consequences of executing the SHUTDOWN ABORT command？ （）AThe database files are synchronized.BUncommitted changes are not rolled back.CThe database is closed， but the instance is still started.DDatabase buffers and redo buffers are not wri”相关问题

  • 第1题：

    Which of the following options is true about shutting down an Automatic Storage Management （ASM） instance？（）  

    • A、 If the SHUTDOWN IMMEDIATE command is issued to the ASM instance， the ASM instance immediately shuts down.
    • B、 If the SHUTDOWN ABORT command is issued to the ASM instance， the ASM instance will shut down all the database instances and then shut down immediately.
    • C、 If the SHUTDOWN NORMAL command is issued to the ASM instance， before shutting down， the ASM instance waits for the dependent database instances to shut down.
    • D、 If the SHUTDOWN TRANSACTIONAL command is issued to the ASM instance， the ASM instance passes the same SHUTDOWN command to the dependent database instances， but does not wait for any active transactions to complete before it shuts down.

    正确答案:C

  • 第2题：

    You have three production databases, HRDB, FINDB, and ORGDB, that use the same ASM instance. At the end of the day, while all three production database instances are running, you execute the following command on the ASM instance : SQL> shutdown immediate; What is the result of executing this command?（）

    • A、The ASM instance is shut down, but the other instances are still running.
    • B、It results in an error because other database instances are connected to it.
    • C、All the instances, including the ASM instance, are shut down in the IMMEDIATE mode.
    • D、HRDB, FINDB, and ORGDB instances are shut down in the ABORT mode and the ASM instance is shut down in the IMMEDIATE mode.

    正确答案:B

  • 第3题：

    Which two statements about the background process of the database writer are true（）

    • A、It is possible to have multiple database writers in an Oracle instance.
    • B、It writes dirty buffers， if any， to data files whenever a checkpoint occurs.
    • C、It writes dirty buffers， if any， to data files whenever a transaction commits.
    • D、It writes dirty buffers， if any， to data files before the log writer （LGWR） writes

    正确答案:A,B

  • 第4题：

    You are working on a database， where you have three redo log groups. When the database is down for a backup， an operating system （OS） user deletes all the redo log files in a group. What will happen when you open your database？（）

    • A、 The instance starts， the database is mounted， but efforts to open the database fail， and an error about the missing redo log group is displayed.
    • B、 Before the instance starts， you receive an error about the missing redo log files of a group.
    • C、 The instance starts and the database opens with an error message written to the alert log file.
    • D、 The instance starts and the database opens because two redo log groups still exist.
    • E、 The instance starts and the database opens， but every attempt to write to redo log files fails with an error.

    正确答案:A

  • 第5题：

    单选题
    What happens if you shutdown abort ASM instance?（）
    A

    The RDBMSs connected will shutdown abort too

    B

    CLUSTER SERVICE will shutdown

    C

    ASM wil do instance recovery after startup


    正确答案： B
    解析： 暂无解析

  • 第6题：

    单选题
    ou are in the middle of a transaction updating a very important table. The machine on which adatabase was running reboots because of power outage. This caused a database instance failure.  Which statement is true in this situation（）
    A

    The online redo log files and archived redo log files are required to accomplish the recovery.

    B

    The uncommitted transaction will be committed at the next startup of the database instance.

    C

    The uncommitted transaction is rolled back automatically at the next opening of the database.

    D

    The DBA has to perform the recovery on the database to recover the uncommitted transaction.


    正确答案： C
    解析： 暂无解析

  • 第7题：

    多选题
    Which two statements about the background process of the database writer are true（）
    A

    It is possible to have multiple database writers in an Oracle instance.

    B

    It writes dirty buffers， if any， to data files whenever a checkpoint occurs.

    C

    It writes dirty buffers， if any， to data files whenever a transaction commits.

    D

    It writes dirty buffers， if any， to data files before the log writer （LGWR） writes


    正确答案： A,D
    解析： 暂无解析

  • 第8题：

    多选题
    What are the consequences of executing the SHUTDOWN ABORT command？ （）
    A

    The database files are synchronized.

    B

    Uncommitted changes are not rolled back.

    C

    The database is closed， but the instance is still started.

    D

    Database buffers and redo buffers are not written to the disk.

    E

    The database undergoes automatic media recovery during the next startup.


    正确答案： B,C
    解析： 暂无解析

  • 第9题：

    多选题
    Your database is configured in NOARCHIVELOG mode. All the control files have been lost due to a hard disk failure but the data files are not lost. You have the closed whole database backup available to you. Which two statements are true in this scenario？（）
    A

    The instance aborts.

    B

    The database cannot be recovered.

    C

    The database can be recovered by restoring the control files from the backup.

    D

    The database remains opened and you have to shut it down with the ABORT option.

    E

    The database can be restored till the point of the last closed whole database backup.


    正确答案： A,E
    解析： 暂无解析

  • 第10题：

    单选题
    You have three production databases, HRDB, FINDB, and ORGDB, that use the same ASM instance. At the end of the day, while all three production database instances are running, you execute the following command on the ASM instance : SQL> shutdown immediate; What is the result of executing this command?（）
    A

    The ASM instance is shut down, but the other instances are still running.

    B

    It results in an error because other database instances are connected to it.

    C

    All the instances, including the ASM instance, are shut down in the IMMEDIATE mode.

    D

    HRDB, FINDB, and ORGDB instances are shut down in the ABORT mode and the ASM instance is shut down in the IMMEDIATE mode.


    正确答案： D
    解析： 暂无解析

  • 第11题：

    多选题
    After performing a clean shut down of the database instance for maintenance， you mount thedatabase and then execute a command to open the database： SQL> ALTER DATABASE OPEN；  Which two statements are true（）
    A

    The online redo log files and online data files are opened.

    B

    All the online data file headers are checked for consistency.

    C

    Instance recovery is performed before opening the database.

    D

    The path and existence of all the log file members are checked


    正确答案： D,C
    解析： 暂无解析

  • 第12题：

    单选题
    If you issue the command shutdown abort prior to trying to put the database in ARCHIVELOG mode， what will be the result when you issue the command alter database archivelog？（）
    A

     The alter database archivelog command will fail

    B

     The alter database archivelog inconsistent command must be used to put the database in ARCHIVELOG mode

    C

     The alter database archivelog command will succeed

    D

     The alter database archivelog command will ask if you want to make the database consistent first

    E

     There is no alter database archivelog command. The correct command is alter database alterlogging


    正确答案： E
    解析： 暂无解析

  • 第13题：

    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

    正确答案:B

  • 第14题：

    What is the proper command to shut down the database in a consistent manner?（）

    • A、shutdown abort 
    • B、shutdown kill 
    • C、Shutdown nowait 
    • D、shutdown immediate
    • E、shutdown halt

    正确答案:D

  • 第15题：

    Which two statements about the background process of thedatabase writerare true（） 

    • A、It is possible to have multiple database writers in an Oracle instance.
    • B、It writes dirty buffers， if any， to data files whenever a checkpoint occurs.
    • C、It writes dirty buffers， if any， to data files whenever a transaction commits.
    • D、It writes dirty buffers， if any， to data files before the log writer （LGWR） writes.

    正确答案:A,B

  • 第16题：

    You have lost all your online redo logs. As a result， your database has crashed. You have tried to restart the database and clear the online redo log files， but when you try to open the database you get the following error.   SQL> startup ORACLE instance started.  Total System Global Area 167395328 bytes Fixed Size 1298612 bytes Variable Size 142610252 bytes Database Buffers 20971520 bytes Redo Buffers 2514944 bytes Database mounted.  ORA-00313： open failed for members of log group 2 of thread 1 ORA-00312： online log 2 thread 1： ，，/oracle01/oradata/orcl/redo02a.log ORA-27037： unable to obtain file status Linux Error： 2： No such file or directory Additional information： 3  ORA-00312： online log 2 thread 1： ，，/oracle01/oradata/orcl/redo02.log ORA-27037： unable to obtain file status Linux Error： 2： No such file or directory Additional information： 3  SQL> alter database clear logfile group 2； alter database clear logfile group 2 * ERROR at line 1：  ORA-01624： log 2 needed for crash recovery of instance orcl （thread 1） ORA-00312： online log 2 thread 1： ，，/oracle01/oradata/orcl/redo02.log ORA-00312： online log 2 thread 1： ，，/oracle01/oradata/orcl/redo02a.log   What steps must you take to resolve the error？（） a. Issue the recover database redo logs command.  b. Issue the Startup Mount command to mount the database.  c. Restore the last full database backup.  d. Perform a point-in-time recovery， applying all archived redo logs that are available.  e. Restore all archived redo logs generated during and after the last full database backup.  f. Open the database using the alter database open resetlogs command.  g. Issue the alter database open command.

    • A、b， a， f
    • B、e， b， a， f
    • C、e， b， a， g
    • D、b， a， g
    • E、c， e， b， d， f

    正确答案:E

  • 第17题：

    单选题
    Which of the following options is true about shutting down an Automatic Storage Management （ASM） instance？（）
    A

     If the SHUTDOWN IMMEDIATE command is issued to the ASM instance， the ASM instance immediately shuts down.

    B

     If the SHUTDOWN ABORT command is issued to the ASM instance， the ASM instance will shut down all the database instances and then shut down immediately.

    C

     If the SHUTDOWN NORMAL command is issued to the ASM instance， before shutting down， the ASM instance waits for the dependent database instances to shut down.

    D

     If the SHUTDOWN TRANSACTIONAL command is issued to the ASM instance， the ASM instance passes the same SHUTDOWN command to the dependent database instances， but does not wait for any active transactions to complete before it shuts down.


    正确答案： C
    解析： 暂无解析

  • 第18题：

    多选题
    After performing a clean shut down of the database instance for maintenance， you mount the database andthen execute a command to open the database：SQL> ALTER DATABASE OPEN； Which two statements are true（）
    A

    The online redo log files and online data files are opened.

    B

    All the online data file headers are checked for consistency.

    C

    Instance recovery is performed before opening the database.

    D

    The path and existence of all the log file members are checked


    正确答案： C,A
    解析： 暂无解析

  • 第19题：

    多选题
    Which two statements are true about checkpointing（）
    A

    The checkpoint frequency decreases with the smaller redo log file size.

    B

    It ensures that all committed data is written to the data files during normal shutdown.

    C

    The frequent full checkpoint in a database can cause the overall degradation of the database performance.

    D

    It prompts the Checkpoint （CKPT） process to write data to the data files and redo information to the online redo log files.


    正确答案： B,D
    解析： 暂无解析

  • 第20题：

    单选题
    You are working on a database， where you have three redo log groups. When the database is down for a backup， an operating system （OS） user deletes all the redo log files in a group. What will happen when you open your database？（）
    A

     The instance starts， the database is mounted， but efforts to open the database fail， and an error about the missing redo log group is displayed.

    B

     Before the instance starts， you receive an error about the missing redo log files of a group.

    C

     The instance starts and the database opens with an error message written to the alert log file.

    D

     The instance starts and the database opens because two redo log groups still exist.

    E

     The instance starts and the database opens， but every attempt to write to redo log files fails with an error.


    正确答案： C
    解析： 暂无解析

  • 第21题：

    多选题
    Which two statements about the background process of thedatabase writerare true（）
    A

    It is possible to have multiple database writers in an Oracle instance.

    B

    It writes dirty buffers， if any， to data files whenever a checkpoint occurs.

    C

    It writes dirty buffers， if any， to data files whenever a transaction commits.

    D

    It writes dirty buffers， if any， to data files before the log writer （LGWR） writes.


    正确答案： C,B
    解析： 数据库写进程(DBWn) 可以将缓冲区的内容写入数据文件。DBWn进程负责将数据库缓冲区高速缓存中经过修改的缓冲区（脏数据缓冲区）写入磁盘。虽然对于大多数系统来说，一个数据库写进程(DBW0) 已经足够，但如果系统需要频繁修改数据，则可以配置附加进程（DBW1到DBW9以及DBWa到DBWj）以改进写性能（A正确，可以有很多个dbwr进程）。这些附加DBWn进程在单处理器系统中没有用。 
    当数据库缓冲区高速缓存中的某个缓冲区被修改时，系统会将其标记为脏数据缓冲区，并将其添加到按SCN 顺序存放的灰数据缓冲区的LRUW（LRU 写）列表中。因此，该顺序与为这些更改的缓冲区写入重做日志的重做操作的顺序相匹配。当缓冲区高速缓存中的可用缓冲区的数量低于某个内部阈值（达到服务器进程发现很难获取可用缓冲区的程度）时，DBWn会将灰数据缓冲区写入数据文件，写入顺序与按照LRUW 列表的顺序修改灰数据缓冲区的顺序相同。 SGA 包含的内存结构具有重做流中的某个位置的重做字节地址(RBA)，当实例发生故障时，将从该位置开始恢复。此结构充当指向重做的指针，并且由CKPT 进程按照每三秒一次的频率写入控制文件。由于DBWn按照SCN 顺序写入灰数据缓冲区，而重做按照SCN 顺序执行，因此每当DBWn从LRUW 列表写脏数据缓冲区时，还会将SGA 内存结构中保持的指针前移，以便实例恢复（如果需要）从近似正确的位置开始读取重做，并避免不需要的I/O。这称为―增量检查点‖。 
    注：还有其它一些DBWn可能会执行写操作的情况，例如，当表空间被设置为只读或被置于脱机状态时。在这些情况下，不会出现增量检查点，因为仅属于相应数据文件的灰数据缓冲区在写入数据库时的顺序与SCN 顺序无关。 
    LRU 算法将更频繁访问的块保存在缓冲区高速缓存中，这样，在将缓冲区写入磁盘时，缓冲区不大可能包含将很快有用的数据。 
    DB_WRITER_PROCESSES初始化参数指定DBWn进程数。DBWn进程的最大数目为20。 
    如果用户在启动过程中未指定该进程数，Oracle DB 将根据CPU 和处理器组的数量来决定如何设置DB_WRITER_PROCESSES。 
    在以下情况下，DBWn进程将脏数据缓冲区写入磁盘： 
    • 当服务器进程在扫描阈值数目的缓冲区之后找不到干净的可重用缓冲区时，通知DBWn执行写操作。DBWn在执行其它处理的同时，将灰数据缓冲区异步写入磁盘。 
    •DBWn定期写缓冲区以推进检查点。检查点是重做线程（日志）中开始执行实例恢复的位置。该日志位置由缓冲区高速缓存中最旧的脏数据缓冲区确定。 
    在所有情况下，DBWn均执行成批（多块）写操作以提高效率。多块写操作中写入的块数因操作系统而异。 C答案：是LGWR进程 
    D答案：LGWR先记，DBWR后写。 
    LGWR 的写入速度通常足够快，可以确保缓冲区中始终有空间可供新条目使用，即使对重做日志的访问量很大时也是如此。LGWR 将缓冲区的一个连续部分写入磁盘。 LGWR 在以下情况下执行写操作： • 用户进程提交事务处理时 
    • 重做日志缓冲区的三分之一已满时 • 重做日志缓冲区达到1M的redo条目 
    • 在DBWn进程将经过修改的缓冲区写入磁盘（如果需要）之前 • 每隔3 秒 
    必须在与缓冲区更改相关联的所有重做记录写入磁盘后，DBWn才可以向磁盘写入经过修改的缓冲区（先行写协议）。

  • 第22题：

    单选题
    You are in the middle of a transaction updating a very important table. The machine on which a database wasrunning reboots because of power outage. This caused a database instance failure. Which statement is true inthis situation（）
    A

    The online redo log files and archived redo log files are required to accomplish the recovery.

    B

    The uncommitted transaction will be committed at the next startup of the database instance.

    C

    The uncommitted transaction is rolled back automatically at the next opening of the database.

    D

    The DBA has to perform the recovery on the database to recover the uncommitted transaction


    正确答案： C
    解析： 暂无解析

  • 第23题：

    多选题
    In the parameter file of your production database， the FAST_START_MTTR_TARGET parameter is set to 300 to optimize instance recovery. While observing the performance of the database during instance recovery， you find that the redo log files are not sized properly to support this activity. Which two sources could you use to determine the optimal size of the redo log files？（）
    A

    the V$LOG view

    B

    the V$DBFILE view

    C

    the V$LOGFILE view

    D

    the V$INSTANCE_RECOVERY view

    E

    Oracle Enterprise Manager Database Control


    正确答案： A,C
    解析： 暂无解析

  • 第24题：

    多选题
    You work as a database administrator for Certkiller .com. Your database is in the MOUNT state and you execute the following command to open it ALTER DATABASE OPEN； What two actions are performed as a result of this command？（）
    A

    All control files are opened

    B

    All redo files are opened

    C

    The password file is opened

    D

    The parameter file is opened

    E

    All online data files are opened


    正确答案： C,D
    解析： 暂无解析

相关内容