单选题You want to enable archiving on your database. Presently， the database is running inNOARCHIVELOG mode. Given below are the steps to accomplish the task in random order：  1：Shut down the instance.  2：Execute the ALTER DATABASE ARCHIVELOG command.  3：Sta

题目
单选题
You want to enable archiving on your database. Presently， the database is running inNOARCHIVELOG mode. Given below are the steps to accomplish the task in random order：  1：Shut down the instance.  2：Execute the ALTER DATABASE ARCHIVELOG command.  3：Start up the instance and mount the database.  4：Set the DB_RECOVERY_FILE_DEST initialization parameter to $ORACLE_HOME/dest_1. 5： Open the database.  Which is the correct sequence of steps for accomplishing the task（）
A

4，1，3，2，5

B

1，3，4，5，2

C

1，3，2，5；4 not required

D

4，1，5，2；3 not required

E

1，3，4，5；2 not required

相似考题

1.You are using Recovery Manager (RMAN) with a recovery catalog to back up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. Because of media failure, you lost your production database completely along with the recovery catalog database. You want to recover the target database and make it functional. You consider performing the following steps to accomplish the task:Which option illustrates the correct sequence that you must use?（）A. 8, 1, 3, 2, 4, 5, 7, 6B. 1, 8, 3, 4, 2, 5, 7, 6C. 1, 3, 4, 2, 8, 5, 6, 7D. 1, 3, 2, 4, 6, 5, 7, 8

2. Consider the recovery steps in each of the cases given below：  Case 1：  Shut down the database and perform a backup.  Restore all the data files.  Mount the database.  Recover the database.  Without applying all the redo log files， open the database using the RESETLOGS option.  Back up the database.  Case 2：  Shut down the database and perform a backup.  Restore only the data files of the tablespace where user error damaged the data.  Mount the database.  Recover the database.  Open the database with the RESETLOGS option.  Back up the database.  Case 3： Shut down the database  Restore the data files  Open the database  Perform recovery to the current point in time.  Which case has the correct steps for an incomplete recovery？（）A、only case 1B、only case 2C、only case 3D、case 1 and 2E、case 2 and 3F、case 1 and 3G、all cases： case 1， case 2 and case 3

3. The list below displays four steps that you need to execute in order to switch from the primary database role to the standby database role. Choose the correct order of execution for the steps.（）  1. Shot down and start up the former primary instance without mounting the instance.  2. Issue the ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL  STANDBY command.  3. Issue the ALTER DATABASE MOUNTS STANDBY DATABASE command.  4. End read or update activity on the former primary and standby database.A、1，2，3，4B、3，2，4，1C、4，2，1，3D、4，3，2，1

4.You are maintaining a database that is in ARCHIVELOG mode. You have configured the flash recovery area in your database. The database is in MOUNT EXCLUSIVE mode， and you want to configure the Flashback Database feature. Which two options are NOT required to configure the Flashback Database feature？ （）A、 Open the database in read-only mode.B、 Set the retention target with the DB_FLASHBACK_RETENTION_TARGET initialization parameter.C、 Enable the block change tracking feature.D、 Execute the ALTER DATABASE FLASHBACK ON statement.

参考答案和解析
正确答案： B
解析： 暂无解析
更多“单选题You want to enable archiving on your database. Presently， the database is running inNOARCHIVELOG mode. Given below are the steps to accomplish the task in random order：  1：Shut down the instance.  2：Execute the ALTER DATABASE ARCHIVELOG command.  3：Sta”相关问题

  • 第1题：

    In order to perform Flashback Transaction Query operations， which of these steps are required？（）

    • A、 Ensure that database is running with version 10.1 compatibility.
    • B、 Enable Flashback Logging.
    • C、 Enable Supplemental Logging.
    • D、 Ensure that the database is running with version 10.0 compatibility.
    • E、 Ensure that the database is in ARCHIVELOG mode.

    正确答案:C,D

  • 第2题：

    Which two statements are true regarding the database in ARCHIVELOG mode？（）

    • A、You have to shut down the database to perform the backups.
    • B、Archiving information is written to the data files and redo log files.
    • C、You can perform complete database backups without closing the database.
    • D、Online redo log files have to be multiplexed before putting the database in ARCHIVELOG mode.
    • E、All the previous database backups become invalid after you configure the database to ARCHIVELOG mode.

    正确答案:C,E

  • 第3题：

    You want to enable archiving on your database. Presently， the database is running in NOARCHIVELOG mode.Given below are the steps to accomplish the task in random order： 1. Shut down the instance. 2. Execute the ALTER DATABASE ARCHIVELOG command. 3. Start up the instance and mount the database. 4. Set the DB_RECOVERY_FILE_DEST initialization parameter to $ORACLE_HOME/dest_1. 5. Open the database. Which is the correct sequence of steps for accomplishing the task（）

    • A、4， 1， 3， 2， 5
    • B、1， 3， 4， 5， 2
    • C、1， 3， 2， 5； 4 not required
    • D、4， 1， 5， 2； 3 not required
    • E、1， 3， 4， 5； 2 not required

    正确答案:C

  • 第4题：

    You want to enable archiving on your database. Presently， the database is running inNOARCHIVELOG mode. Given below are the steps to accomplish the task in random order：  1：Shut down the instance.  2：Execute the ALTER DATABASE ARCHIVELOG command.  3：Start up the instance and mount the database.  4：Set the DB_RECOVERY_FILE_DEST initialization parameter to $ORACLE_HOME/dest_1. 5： Open the database.  Which is the correct sequence of steps for accomplishing the task（）

    • A、4，1，3，2，5
    • B、1，3，4，5，2
    • C、1，3，2，5；4 not required
    • D、4，1，5，2；3 not required
    • E、1，3，4，5；2 not required

    正确答案:C

  • 第5题：

    You are working on an instance started using the SPFILE. You want to move the Flash Recovery Areaof your database to a new location. You want the Flashback log files to be stored in the new location. Given below are the steps to accomplish the task in random order：  1）Shut down the instance.  2）Change the value of the DB_RECOVERY_FILE_DEST initialization parameter to a new value.  3）Execute the ALTER DATABASE FLASHBACK OFF command.  4）Start up the instance and mount the database.  5）Execute the ALTER DATABASE FLASHBACKON command.  6）Open the database.  Select the correct order in which these tasks need to be performed. （）

    • A、2，1，4，3，5，6
    • B、1，4，3，2，6，5
    • C、1，4，2，6，3，5
    • D、3，2，1，4，5，6

    正确答案:A

  • 第6题：

    单选题
    You are working on an instance started using the SPFILE. You want to move the Flash Recovery Area of yourdatabase to a new location. You want the Flashback log files to be stored in the new location. Given below are the steps to accomplish the task in random order： 1.Shut down the instance. 2.Change the value of the DB_RECOVERY_FILE_DEST initialization parameter to a new value. 3.Execute the ALTER DATABASE FLASHBACK OFF command. 4.Start up the instance and mount the database. 5.Execute the ALTER DATABASE FLASHBACK ON command. 6.Open the database. Select the correct order in which these tasks need to be performed.（）
    A

    2，1，4，3，5，6

    B

    1，4，3，2，6，5

    C

    1，4，2，6，3，5

    D

    3，2，1，4，5，6


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

  • 第7题：

    单选题
    Consider the recovery steps in each of the cases given below：  Case 1：  Shut down the database and perform a backup.  Restore all the data files.  Mount the database.  Recover the database.  Without applying all the redo log files， open the database using the RESETLOGS option.  Back up the database.  Case 2：  Shut down the database and perform a backup.  Restore only the data files of the tablespace where user error damaged the data.  Mount the database.  Recover the database.  Open the database with the RESETLOGS option.  Back up the database.  Case 3： Shut down the database  Restore the data files  Open the database  Perform recovery to the current point in time.  Which case has the correct steps for an incomplete recovery？（）
    A

    only case 1

    B

    only case 2

    C

    only case 3

    D

    case 1 and 2

    E

    case 2 and 3

    F

    case 1 and 3

    G

    all cases： case 1， case 2 and case 3


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

  • 第8题：

    单选题
    The list below displays four steps that you need to execute in order to switch from the primary database role to the standby database role. Choose the correct order of execution for the steps.（）  1. Shot down and start up the former primary instance without mounting the instance.  2. Issue the ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL  STANDBY command.  3. Issue the ALTER DATABASE MOUNTS STANDBY DATABASE command.  4. End read or update activity on the former primary and standby database.
    A

    1，2，3，4

    B

    3，2，4，1

    C

    4，2，1，3

    D

    4，3，2，1


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

  • 第9题：

    单选题
    You are using Recovery Manager (RMAN) with a recovery catalog to back up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. Because of media failure, you lost your production database completely along with the recovery catalog database. You want to recover the target database and make it functional. You consider performing the following steps to accomplish the task: Which option illustrates the correct sequence that you must use?（）
    A

    8, 1, 3, 2, 4, 5, 7, 6

    B

    1, 8, 3, 4, 2, 5, 7, 6

    C

    1, 3, 4, 2, 8, 5, 6, 7

    D

    1, 3, 2, 4, 6, 5, 7, 8


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

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

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

  • 第12题：

    单选题
    Your ARCHIVELOG-mode database has lost three datafiles and shut down. One is assigned to the SYSTEM tablespace and two are assigned to the USERS tablespace. You can choose from the following steps to recover your database：   a. Restore the three database datafiles that were lost.  b. Issue the Startup Mount command to mount the database.  c. Issue the alter database open command.  d. Issue the alter database open resetlogs command.  e. Recover the database using the recover database command. f. Recover the datafiles with the recover datafile command.  g. Take the datafiles offline.  Which is the correct order of these steps in this case？（）
    A

    a， b， e， c

    B

    b， e， d

    C

    a， b， d， c

    D

    b， g， c， f

    E

    a， b， d， f


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

  • 第13题：

    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

  • 第14题：

    You work as a database administrator for Supportcenter.cn. Your database is opened inNOARCHIVEKLOG mode. You decide to place the database in ARCHIVELOG mode. How would you do this？（）

    • A、Execute the ALTER DATABASE ARCHIVELOG statement
    • B、Select ARCHIVELOG option in the database control and restart the database to apply the changes.
    • C、Shut down and start the instance， and in the NOMOUNT state execute the ALTER DATABASE ARCHIVELOG statement.
    • D、Shut down and start the instance， mount the database， then execute the ALTER DATABASE ARCHIVELOG statement.

    正确答案:B,D

  • 第15题：

    Which are the correct steps， in order， to deal with the loss of an online redo log if the database has not yet crashed？（）   a. Issue a checkpoint.  b. Shut down the database.  c. Issue an alter database open command to open the database.  d. Startup mount the database.  e. Issue an alter database clear logfile command.  f. Recover all database datafiles.

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

    正确答案:C

  • 第16题：

    You are working on an instance started using the SPFILE. You want to move the Flash Recovery Area of yourdatabase to a new location. You want the Flashback log files to be stored in the new location. Given below are the steps to accomplish the task in random order： 1.Shut down the instance. 2.Change the value of the DB_RECOVERY_FILE_DEST initialization parameter to a new value. 3.Execute the ALTER DATABASE FLASHBACK OFF command. 4.Start up the instance and mount the database. 5.Execute the ALTER DATABASE FLASHBACK ON command. 6.Open the database. Select the correct order in which these tasks need to be performed.（）

    • A、2，1，4，3，5，6
    • B、1，4，3，2，6，5
    • C、1，4，2，6，3，5
    • D、3，2，1，4，5，6

    正确答案:A

  • 第17题：

    Your ARCHIVELOG-mode database has lost three datafiles and shut down. One is assigned to the SYSTEM tablespace and two are assigned to the USERS tablespace. You can choose from the following steps to recover your database：   a. Restore the three database datafiles that were lost.  b. Issue the Startup Mount command to mount the database.  c. Issue the alter database open command.  d. Issue the alter database open resetlogs command.  e. Recover the database using the recover database command. f. Recover the datafiles with the recover datafile command.  g. Take the datafiles offline.  Which is the correct order of these steps in this case？（）

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

    正确答案:A

  • 第18题：

    单选题
    You want to enable archiving on your database. Presently， the database is running in NOARCHIVELOG mode.Given below are the steps to accomplish the task in random order： 1. Shut down the instance. 2. Execute the ALTER DATABASE ARCHIVELOG command. 3. Start up the instance and mount the database. 4. Set the DB_RECOVERY_FILE_DEST initialization parameter to $ORACLE_HOME/dest_1. 5. Open the database. Which is the correct sequence of steps for accomplishing the task（）
    A

    4， 1， 3， 2， 5

    B

    1， 3， 4， 5， 2

    C

    1， 3， 2， 5； 4 not required

    D

    4， 1， 5， 2； 3 not required

    E

    1， 3， 4， 5； 2 not required


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

  • 第19题：

    单选题
    You want to enable archiving on your database. Presently， the database is running in NOARCHIVELOG mode.Given below are the steps to accomplish the task in random order： 1. Shut down the instance. 2. Execute the ALTER DATABASE ARCHIVELOG command. 3. Start up the instance and mount the database. 4. Set the DB_RECOVERY_FILE_DEST initialization parameter to $ORACLE_HOME/dest_1. 5. Open the database. Which is the correct sequence of steps for accomplishing the task（）
    A

    4， 1， 3， 2， 5

    B

    1， 3， 4， 5， 2

    C

    1， 3， 2， 5； 4 not required

    D

    4， 1， 5， 2； 3 not required

    E

    1， 3， 4， 5； 2 not required


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

  • 第20题：

    单选题
    Which are the correct steps， in order， to deal with the loss of an online redo log if the database has not yet crashed？（）   a. Issue a checkpoint.  b. Shut down the database.  c. Issue an alter database open command to open the database.  d. Startup mount the database.  e. Issue an alter database clear logfile command.  f. Recover all database datafiles.
    A

    a， b， c， d

    B

    b， d， e， c

    C

    a， b， d， e， c

    D

    b， f， d， f， c

    E

    b， d， a， c


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

  • 第21题：

    单选题
    You are working on an instance started using the SPFILE. You want to move the Flash Recovery Areaof your database to a new location. You want the Flashback log files to be stored in the new location. Given below are the steps to accomplish the task in random order：  1）Shut down the instance.  2）Change the value of the DB_RECOVERY_FILE_DEST initialization parameter to a new value.  3）Execute the ALTER DATABASE FLASHBACK OFF command.  4）Start up the instance and mount the database.  5）Execute the ALTER DATABASE FLASHBACKON command.  6）Open the database.  Select the correct order in which these tasks need to be performed. （）
    A

    2，1，4，3，5，6

    B

    1，4，3，2，6，5

    C

    1，4，2，6，3，5

    D

    3，2，1，4，5，6


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

  • 第22题：

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

  • 第23题：

    多选题
    You work as a database administrator for Supportcenter.cn. Your database is opened inNOARCHIVEKLOG mode. You decide to place the database in ARCHIVELOG mode. How would you do this？（）
    A

    Execute the ALTER DATABASE ARCHIVELOG statement

    B

    Select ARCHIVELOG option in the database control and restart the database to apply the changes.

    C

    Shut down and start the instance， and in the NOMOUNT state execute the ALTER DATABASE ARCHIVELOG statement.

    D

    Shut down and start the instance， mount the database， then execute the ALTER DATABASE ARCHIVELOG statement.


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

相关内容