Oracle

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题：

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.


参考答案：C, D, F

第2题：

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

A. NOMOUNT

B. MOUNT

C. OPEN


参考答案A

第3题：

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

A.mount-a

B.mount/mnt/*

C.mount

D.mount/etc/fstab


正确答案：A

第4题：

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

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

正确答案:C

第5题：

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

第6题：

如何装载(mount)上在/etc/fstab文件中定义的所有文件系统()。

A.mount-a

B.mount/mnt/*

C.mount

D.cat/etc/fstab|mount


正确答案：A

第7题：

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

第8题：

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

第9题：

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

第10题：

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

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

正确答案:C

更多相关问题
相关内容