Oracle数据库启动时需要经历三个步骤和状态变换，以下顺序正确的是（）。A、mount→open→nomountB、mount→open→closeC、close→open→mountD、nomount→mount→open

题目

Oracle数据库启动时需要经历三个步骤和状态变换，以下顺序正确的是（）。

  • A、mount→open→nomount
  • B、mount→open→close
  • C、close→open→mount
  • D、nomount→mount→open
相似考题

1.如何装载(mount)上在/etc/fstab文件中定义的所有文件系统()A.mount-aB.mount/mnt/*C.mountD.mount/etc/fstab

2.Your multitenant container database (CDB) contains three pluggable database (PDBs). You find that the control file is damaged. You plan to use RMAN to recover the control file. There are no startup triggers associated with the PDBs.Which three steps should you perform to recover the control file and make the database fully operational?（）A. Mount the container database (CDB) and restore the control file from the control file auto backup.B. Recover and open the CDB in NORMAL mode.C. Mount the CDB and then recover and open the database, with the RESETLOGS option.D. Open all the pluggable databases.E. Recover each pluggable database.F. Start the database instance in the nomount stage and restore the control file from control file auto backup.

3.如何装载(mount)上在/etc/fstab文件中定义的所有文件系统()。A.mount-aB.mount/mnt/*C.mountD.cat/etc/fstab|mount

4.You realize that the control file is damaged in your production database.After restoring the control file from autobackup, what is the next step that you must do to proceed with the database recovery?（）A. Mount the databaseB. Open the database in NORMAL modeC. Open the database in RESTRICTED modeD. Open the database with the RESETLOGS option

更多“Oracle数据库启动时需要经历三个步骤和状态变换，以下顺序正确的是（）。A、mount→open→nomountB、mount→open→closeC、close→open→mountD、nomount→mount→open”相关问题

  • 第1题：

    数据库启动到什么状态会加载参数文件:()

    A. NOMOUNT

    B. MOUNT

    C. OPEN


    参考答案A

  • 第2题：

    You are working on the PROD database， which is in NOARCHIVELOG mode. You lost the active online redo log group due to a media failure. How should you recover your database？（）

    • A、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， open the database with the RESETLOGS option after performing a cancel-based recovery.
    • B、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， drop the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.
    • C、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， clear the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.
    • D、 Do nothing. You do not need to recover the database in this case； an instance recovery will be performed by the SMON process on startup.

    正确答案:A

  • 第3题：

    用rman对数据库进行冷备份，数据库必须在（）状态才能进行。

    • A、shutdown
    • B、nomount
    • C、mount
    • D、Open

    正确答案:C

  • 第4题：

    如何装载（mount）上在/etc/fstab文件中定义的所有文件系统？（）

    • A、mount -a
    • B、mount/mnt/*
    • C、mount
    • D、cat/etc/fstab

    正确答案:A

  • 第5题：

    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

    正确答案:A,B

  • 第6题：

    You realize that the control file is damaged in your production database.After restoring the control file from autobackup, what is the next step that you must do to proceed with the database recovery?（）

    • A、Mount the database
    • B、Open the database in NORMAL mode
    • C、Open the database in RESTRICTED mode
    • D、Open the database with the RESETLOGS option

    正确答案:A

  • 第7题：

    You are managing a single instance Oracle 10g database that utilizes the following parameters：  Which of the following set of commands must you execute to enable Flashback Database？（）

    • A、  STARTUP MOUNT EXCLUSIVE  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN；
    • B、  STARTUP MOUNT  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN RESETLOGS；
    • C、  STARTUP MOUNT EXCLUSIVE  ATLER DATABASE ARCHIVELOG；  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN RESETLOGS；
    • D、  STARTUP MOUNT  ALTER DATABASE ARCHIVELOG；  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN；

    正确答案:D

  • 第8题：

    You are performing an incomplete recovery because certain important tables were deleted and purged from the Recycle Bin. In which mode will you perform the recovery？（）

    • A、 MOUNT mode
    • B、 RESTRICTED mode
    • C、 OPEN mode
    • D、 NOMOUNT mode

    正确答案:A

  • 第9题：

    TARTUP的（）选项启动实例装载数据库，但不打开数据库。

    • A、STARTUP NOMOUNT
    • B、STARTUP MOUNT
    • C、STARTUP OPEN

    正确答案:B

  • 第10题：

    单选题
    Given  the  following  output，  recommend  corrective  action  that  should  be  undertaken  to  increase   protection（） # Isvg -I rootvg rootvg：  LV NAME TYPE LPs PPs PVs LV STATE MOUNT POINT  hd5 boot 1 2 2 closed/syncd N/A  hd6 paging 16 32 2 open/syncd N/A  hd8 jfslog 1 2 2 open/syncd N/A  hd4 jfs 2 4 2 open/syncd /  hd2 jfs 53 106 2 open/syncd /usr  hd9var jfs 16 32 2 open/syncd /var  hd3 jfs 4 8 2 open/syncd /tmp  hdl jfs 1 2 2 open/syncd /home  hdlOopt jfs 2 4 2 open/syncd /opt  loglvOO jfs2log 1 1 1 open/syncd N/A  fslvOO jfs2 ’ 2 4 2 open/syncd /datafs
    A

    add a copy of the log for/datafs

    B

    open hd5

    C

    mirrorvg rootvg

    D

    split /usr as it is too big


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

  • 第11题：

    单选题
    You have to shut down the database instance with the ABORT option because of a hardware failure. Which statement is true about the subsequent opening of the database？（）
    A

    The database would open normally.

    B

    The database would not open， and it would stop at mount stage.

    C

    The database would open after automatically performing instance recovery.

    D

    The database would not open， and you have to perform database recovery to open it.


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

  • 第12题：

    单选题
    You are managing a single instance Oracle 10g database that utilizes the following parameters：  Which of the following set of commands must you execute to enable Flashback Database？（）
    A

      STARTUP MOUNT EXCLUSIVE  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN；

    B

      STARTUP MOUNT  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN RESETLOGS；

    C

      STARTUP MOUNT EXCLUSIVE  ATLER DATABASE ARCHIVELOG；  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN RESETLOGS；

    D

      STARTUP MOUNT  ALTER DATABASE ARCHIVELOG；  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN；


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

  • 第13题：

    At database startup， you discover that one of the disks containing an index tablespace has been lost due to a media failure. A backup of the lost index tablespace is not available. You have all the necessary scripts to recreate the indexes. You need to re-create the indexes in a new index tablespace. Which action must you perform before re-creating the indexes？（）

    • A、 Start the database in OPEN mode， and create a new index tablespace.
    • B、 Start the database in OPEN mode， and drop the lost index tablespace from the database.
    • C、Start the database in MOUNT mode， create a new index tablespace， and drop the lost index tablespace from the database.
    • D、 Start the database in MOUNT mode， drop the lost index tablespace from the database， open the database， and create a new index tablespace.

    正确答案:D

  • 第14题：

    Given  the  following  output，  recommend  corrective  action  that  should  be  undertaken  to  increase   protection（） # Isvg -I rootvg rootvg：  LV NAME TYPE LPs PPs PVs LV STATE MOUNT POINT  hd5 boot 1 2 2 closed/syncd N/A  hd6 paging 16 32 2 open/syncd N/A  hd8 jfslog 1 2 2 open/syncd N/A  hd4 jfs 2 4 2 open/syncd /  hd2 jfs 53 106 2 open/syncd /usr  hd9var jfs 16 32 2 open/syncd /var  hd3 jfs 4 8 2 open/syncd /tmp  hdl jfs 1 2 2 open/syncd /home  hdlOopt jfs 2 4 2 open/syncd /opt  loglvOO jfs2log 1 1 1 open/syncd N/A  fslvOO jfs2 ’ 2 4 2 open/syncd /datafs

    • A、add a copy of the log for/datafs
    • B、open hd5
    • C、mirrorvg rootvg
    • D、split /usr as it is too big

    正确答案:A

  • 第15题：

    oracle数据库在nomount模式时，以下（）命令将数据库启动到mount模式。

    • A、startup
    • B、startup mount
    • C、alter database mount
    • D、alter database open

    正确答案:C

  • 第16题：

    You have to shut down the database instance with the ABORT option because of a hardware failure. Which statement is true about the subsequent opening of the database？（）

    • A、The database would open normally.
    • B、The database would not open， and it would stop at mount stage.
    • C、The database would open after automatically performing instance recovery.
    • D、The database would not open， and you have to perform database recovery to open it.

    正确答案:C

  • 第17题：

    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

    正确答案:B,E

  • 第18题：

    You have lost all your SYSTEM tablespace datafiles （system_01.dbf and system_02.dbf） nd the database has crashed.  What would be the appropriate order of operations to correct the situation？（）   a. Mount the database with the startup mount command.  b. Take the SYSTEM datafile offline with the alter database command.  c. Restore the SYSTEM_01.dbf datafile from backup media with the required archived redo logs.  d. Restore all SYSTEM tablespace-related datafiles from backup media. e. Issue the recover tablespace SYSTEM command.  f. Issue the recover datafile SYSTEM_01.dbf command.  g. Open the database with the alter database open command.  h. Open the database with the alter database open resetlogs command.

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

    正确答案:D

  • 第19题：

    Which three statements are true about the stages of database startup？（）

    • A、Data files and redo log files can be renamed at the MOUNT stage.
    • B、Control files are read at the OPEN stage for the location of data files.
    • C、Control files are required to bring the database to the NOMOUNT stage.
    • D、Data files and redo log files are made available to users at the OPEN stage.
    • E、Data files and online redo log files are checked for consistency while opening the database

    正确答案:A,D,E

  • 第20题：

    In your multitenant container database (CDB) with two pluggable database (PDBs). You want to create a new PDB by using SQL Developer. Which statement is true?（）

    • A、The CDB must be open.
    • B、The CDB must be in the mount stage.
    • C、The CDB must be in the nomount stage.
    • D、Alt existing PDBs must be closed.

    正确答案:A

  • 第21题：

    多选题
    our 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 log files are opened

    C

    The password file is opened.

    D

    The parameter file is opened.

    E

    All online data files are opened.


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

  • 第22题：

    单选题
    You are performing an incomplete recovery because certain important tables were deleted and purged from the Recycle Bin. In which mode will you perform the recovery？（）
    A

     MOUNT mode

    B

     RESTRICTED mode

    C

     OPEN mode

    D

     NOMOUNT mode


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

  • 第23题：

    单选题
    In your multitenant container database (CDB) with two pluggable database (PDBs). You want to create a new PDB by using SQL Developer. Which statement is true?（）
    A

    The CDB must be open.

    B

    The CDB must be in the mount stage.

    C

    The CDB must be in the nomount stage.

    D

    Alt existing PDBs must be closed.


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

相关内容