RMAN enables you to open the target database when it is already mounted. Which command must you execute at the RMAN prompt to open the database？（）A、’SQL ALTER DATABASE OPEN’；B、SQL ALTER DATABASE ’OPEN’；C、OPEN DATABASE；D、DATABASE OPEN

题目

RMAN enables you to open the target database when it is already mounted. Which command must you execute at the RMAN prompt to open the database？（）

  • A、’SQL ALTER DATABASE OPEN’；
  • B、SQL ALTER DATABASE ’OPEN’；
  • C、OPEN DATABASE；
  • D、DATABASE OPEN
相似考题

1.Which command is used to open the database after an incomplete recovery？（）A、 alter database openB、 alter database open repairlogC、 alter database open resetlogsD、 alter database open resetlogE、 alter database resetlogs open

2.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.

3. 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

4. You executed the following command in Recovery Manager （RMAN）：  RMAN> RESTORE CONTROLFILE；  Which operation must you perform before this command is executed？（） A、back up the control file to traceB、bring database to the MOUNT stateC、open a connection to the RMAN recovery catalog， which contains the RMAN metadata for the target databaseD、set the database ID （DBID）， but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog

更多“RMAN enables you to open the target database when it is already mounted. Which command must you execute at the RMAN prompt to open the database？（）A、’SQL ALTER DATABASE OPEN’；B、SQL ALTER DATABASE ’OPEN’；C、OPEN DATABASE；D、DATABASE OPEN”相关问题

  • 第1题：

    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

  • 第2题：

    You are using recovery Manager (RMAN) with a recovery catalog to backup up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. The database was open and transactions were recorded in the redo logs. Because of fire in the building you lost your servers having the production database and the recovery catalog database. The archive log files generated after the last backup are intact on one of the remote locations. While performing a disaster recovery of the production database what is the next step that you must perform after restoring the data files and applying archived redo logs?（）

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

    正确答案:D

  • 第3题：

    After the recovery is complete， which command should you execute？（）

    • A、ALTER DATABASE OPEN；
    • B、ALTER DATABASE CLEAR LOGFILE；
    • C、ALTER DATABASE OPEN RESETLOGS；
    • D、ALTER DATABASE OPEN NORESETLOGS；

    正确答案:C

  • 第4题：

    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

  • 第5题：

    Examine this statement：  RMAN >BACKUP FORMAT ’/BACKUP/df_%d_%s_%p.bus1 DATABASE filesperset = 2；  What state must the target database be in for you to use this RMAN command？（）

    • A、The target database must be open.
    • B、The target database must be closed.
    • C、The target database must be mounted.
    • D、The target database must be mounted or open.

    正确答案:D

  • 第6题：

    Given a complete loss of your database， in what order would you need to perform the following RMAN operations to restore it？（）   a. restore controlfile  b. restore database  c. restore spfile  d. recover database  e. alter database open  f. alter database open resetlogs

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

    正确答案:D

  • 第7题：

    单选题
    You executed the following command in Recovery Manager （RMAN）：  RMAN> RESTORE CONTROLFILE；  Which operation must you perform before this command is executed？（）
    A

     back up the control file to trace

    B

     bring database to the MOUNT state

    C

     open a connection to the RMAN recovery catalog， which contains the RMAN metadata for the target database

    D

     set the database ID （DBID）， but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog


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

  • 第8题：

    单选题
    RMAN enables you to open the target database when it is already mounted. Which command must you execute at the RMAN prompt to open the database？（）
    A

    ’SQL ALTER DATABASE OPEN’；

    B

    SQL ALTER DATABASE ’OPEN’；

    C

    OPEN DATABASE；

    D

    DATABASE OPEN


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

  • 第9题：

    单选题
    Examine this statement：  RMAN >BACKUP FORMAT ’/BACKUP/df_%d_%s_%p.bus1 DATABASE filesperset = 2；  What state must the target database be in for you to use this RMAN command？（）
    A

    The target database must be open.

    B

    The target database must be closed.

    C

    The target database must be mounted.

    D

    The target database must be mounted or open.


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

  • 第10题：

    单选题
    When performing a full database disaster recovery with RMAN， in what order would you execute these steps？（）   a. Restore the control file from autobackups.  b. Run the RMAN restore and recover command.  c.Restore the database spfile from autobackups.  d. Make the RMAN backup set pieces available.  e. Open the database with the alter database open resetlogs command.  f.Open the database with the alter database open command.
    A

     a， b， c， d， e， f

    B

     c， d， a， b， f

    C

     d， c， a， b， f

    D

      d， b， d， c， e

    E

      d， c， a， b， e


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

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

    单选题
    You want to configure the Flashback Database feature and retain flashback logs for three days.  Presently the database is open and configured in ARCHIVELOG mode. The following steps must be performed in the correct sequence to do this：   1. Set the retention target：  SQL> ALTER SYSTEM SET DB_FLASHBACK_RETENTION_TARGET=4320；  2. Enable Flashback Database：  SQL> ALTER DATABASE FLASHBACK ON；  3. Mount the database：  SQL> STARTUP MOUNT EXCLUSIVE  4. Shutdown the instance： SQL> SHUTDOWN IMMEDIATE  5. Open the database：  SQL> ALTER DATABASE OPEN；   Choose the correct sequence.（）
    A

     4， 1， 3， 2， 5

    B

     4， 3， 1， 2， 5

    C

     2， 4， 3， 5， 1

    D

     4， 2， 5， 3， 1


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

  • 第13题：

    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

    正确答案:A,B

  • 第14题：

    Which of the following represents the correct way to perform an online recovery of datafile 4， which is assigned to a tablespace called USERS？（）  

    • A、 shutdown restore datafile 4； recover datafile 4； alter database open；
    • B、 Sql alter database datafile 4 offline； restore datafile 4； recover datafile 4； alter database open；
    • C、 Sql alter database datafile 4 offline； restore datafile 4； Sql alter database datafile 4 online；
    • D、 Sql alter database datafile 4 offline； restore database datafile 4； recover database datafile 4；Sql alter database datafile 4 online；
    • E、 Sql alter database datafile 4 offline； restore datafile 4； recover datafile 4； Sql alter database datafile 4 online；

    正确答案:E

  • 第15题：

    When performing a full database disaster recovery with RMAN， in what order would you execute these steps？（）   a. Restore the control file from autobackups.  b. Run the RMAN restore and recover command.  c.Restore the database spfile from autobackups.  d. Make the RMAN backup set pieces available.  e. Open the database with the alter database open resetlogs command.  f.Open the database with the alter database open command. 

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

    正确答案:E

  • 第16题：

    Identify three valid methods of opening, pluggable databases (PDBs).（）

    • A、ALTER PLUGGABLE DATABASE OPEN ALL ISSUED from the root
    • B、ALTER PLUGGABLE DATABASE OPEN ALL ISSUED from a pdb
    • C、ALTER PLUGGABLE DATABASE PDB OPEN issued from the seed
    • D、ALTER DATABASE PDB OPEN issued from the root
    • E、ALTER DATABASE OPEN issued from that pdb 
    • F、ALTER PLUGGABLE DATABASE PDB OPEN issued from another pdb
    • G、ALTER PLUGGABLE DATABASE OPEN issued from that pdb

    正确答案:A,E,G

  • 第17题：

    Flashback is enabled for your multitenant container database (CDB), which contains two pluggable database (PDBs). A local user was accidently dropped from one of the PDBs. You want to flash back the PDB to the time before the local user was dropped. You connect to the CDB and execute the following commands: SQL > SHUTDOWN IMMEDIATE SQL > STARTUP MOUNT SQL > FLASHBACK DATABASE to TIME “TO_DATE (‘08/20/12’ , ‘MM/DD/YY’)”; Examine following commands: 1. ALTER PLUGGABLE DATABASE ALL OPEN; 2. ALTER DATABASE OPEN; 3. ALTER DATABASE OPEN RESETLOGS; Which command or commands should you execute next to allow updates to the flashback back schema?（）

    • A、Only 1
    • B、Only 2
    • C、Only 3
    • D、3 and 1
    • E、1 and 2

    正确答案: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题：

    单选题
    Flashback is enabled for your multitenant container database (CDB), which contains two pluggable database (PDBs). A local user was accidently dropped from one of the PDBs. You want to flash back the PDB to the time before the local user was dropped. You connect to the CDB and execute the following commands: SQL > SHUTDOWN IMMEDIATE SQL > STARTUP MOUNT SQL > FLASHBACK DATABASE to TIME “TO_DATE (‘08/20/12’ , ‘MM/DD/YY’)”; Examine following commands: 1. ALTER PLUGGABLE DATABASE ALL OPEN; 2. ALTER DATABASE OPEN; 3. ALTER DATABASE OPEN RESETLOGS; Which command or commands should you execute next to allow updates to the flashback back schema?（）
    A

    Only 1

    B

    Only 2

    C

    Only 3

    D

    3 and 1

    E

    1 and 2


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

  • 第20题：

    单选题
    Which command is used to open the database after an incomplete recovery？（）
    A

     alter database open

    B

     alter database open repairlog

    C

     alter database open resetlogs

    D

     alter database open resetlog

    E

     alter database resetlogs open


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

  • 第21题：

    单选题
    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
    解析： 暂无解析

  • 第22题：

    单选题
    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
    解析： 暂无解析

  • 第23题：

    单选题
    After the recovery is complete， which command should you execute？（）
    A

    ALTER DATABASE OPEN；

    B

    ALTER DATABASE CLEAR LOGFILE；

    C

    ALTER DATABASE OPEN RESETLOGS；

    D

    ALTER DATABASE OPEN NORESETLOGS；


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

相关内容