单选题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 wi

题目
单选题
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

相似考题

1.Upon starting your database, you receive the following error:You can choose from the following steps:1.Restore the database datafiles.2.Issue the alter database clear unarchived logfile group 1 command.3.Issue the alter database open command.4.Issue the alter database open resetlogs command.5.Recover the database using point-in-time recovery.6.Issue the Startup Mount command to mount the database.7.Back up the database.Which is the correct order of these steps in this case?（）A. 1,6,5,4,7B. 6,5,4C. 6,2,3,7D. 1,6,3E. The database cannot be recovered

2.What is the correct order of steps for upgrading a cisco wcs？（）A、back up the database， stop the wcs， upgrade the wcs， restore the database， start the wcs B、stop the wcs， back up the database， upgrade the wcs， restore the database， start the wcsC、back up the database， stop the wcs， upgrade the wcs， start the wcs， restore the database D、stop the wcs， back up the database， upgrade the wcs， start the wcs， restore the database

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 the administrator of three SQL Server 2000 computers at Five Lakes Publishing. One server, FLPSQL01, stores order data. You want to be able to use the other two servers, FLPSQL02 and FLPSQL03, to answer queries and run report. The planned network configuration is shown in the exhibit.You want to use the database Maintenance Plan wizard to configure log shipping from FLPSQL01 to FLPSQL02 and FLPSQL03. You do not want users to add any new data on FLPSQL02 and FLPSQL03, but they must be able to run queries and reports.Which two actions should you take? (Each correct answer presents part of the solution. Choose two)A．Set the database load state for each destination server to No recovery mode.B．Set the database load state for each destination server to standby mode.C．Enable the allow database to assume primary role option for both destination servers.D．Enable the allow database to assume primary role option for one destination server and then disable this option for other destination server.E．Disable the allow database to assume primary role option for both destination servers.

参考答案和解析
正确答案： B
解析： 暂无解析
更多“单选题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 wi”相关问题

  • 第1题：

    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

  • 第2题：

    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

  • 第3题：

    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

  • 第4题：

    What is the correct order of steps to perform an online database backup？（）   a. alter database begin backup b. alter database end backup c. Back up the database datafiles d. Back up the archive log files e. alter system switch logfile

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

    正确答案:E

  • 第5题：

    You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named Dworks in the instance. You are log shipping the Adventureworks database to a remote SQL Server 2008 instance. The primary SQL Server instance required a restart during the weekend. But you notice that log shipping has stopped working after the weekend. You have to check log shipping of the Adventureworks database and find out the problem. What should you do? （） 

    • A、You should use the EXTENDED_LOGICAL_CHECKS option to execute a DBCC CHECKDB statement on the AdventureWorks database by. 
    • B、You should identify whether the SQL Server Agent is started on the primary server. 
    • C、You should identify whether the AdventureWorks database uses the Simple recovery model. 
    • D、You should identify whether the SQL Server Volume Shadow Copy Service (VSS) Writer is started on the primary server

    正确答案:B

  • 第6题：

    多选题
    User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, whichcommands must you execute to enable SCOTT to flash back the transactions? （）(Choose four.)
    A

    ALTER DATABASE FLASHBACK ON;

    B

    GRANT SELECT any transaction TO scott;

    C

    GRANT EXECUTE ON dbms_flashback TO scott;

    D

    ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;

    E

    ALTER TABLESPACE undots1 RETENTION GUARANTEE;

    F

    ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;


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

  • 第7题：

    多选题
    You need to design the database permissions for access from the terminals to the database server. Which action or actions should you perform?（）
    A

    Create a database role named BankTerminals.

    B

    Grant the BankTerminals role the Execute permission for the WoodgroveBanking database.

    C

    Grant database access to the Windows Bank Terminals group， and add the group to the BankTerminals role.

    D

    Grant the BankTerminals role the Execute permission for the Bank schema.

    E

    Grant the Windows Bank Terminals group the Execute permission for the Bank schema.

    F

    Grant the BankTerminals role the Execute permission for all stored procedures and user-defined functions in the Bank schema.


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

  • 第8题：

    单选题
    What is the correct order of steps to perform an online database backup？（）   a. alter database begin backup b. alter database end backup c. Back up the database datafiles d. Back up the archive log files e. alter system switch logfile
    A

    a， b， c， d， e

    B

    e， d， a， b， c

    C

    a， c， b， d， e

    D

    d， b， c， a， e

    E

    a， c， b， e， d


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

  • 第9题：

    单选题
    You used the IMMEDIATE option to shut down your database instance. Consider the steps that may occurwhen a database instance is started and database is opened： 1. SGA is allocated. 2. Control file is read. 3. Redo log files are opened.4. Instance recovery is started. 5. Background processes are started. 6. Data file headers are checked for consistency. 7. Server parameter file or the initialization parameter file is read.  Which option has the correct order in which these steps occur（）
    A

    7， 1， 5， 2， 3， 6， 4

    B

    1， 5， 7， 2， 3， 6； step 4 is not required

    C

    7， 1， 5， 2， 3， 6； step 4 is not requiredThis document was downloaded from =>> http：//www.amaderforum.com

    D

    1， 2， 3， 5， 6， 4； step 7 is not required


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

  • 第10题：

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

  • 第11题：

    单选题
    In which situation would you use static database registration for a listener（）
    A

    when multiple databases are to be registered with the listener

    B

    when DBAs need to connect remotely to start up the database instance

    C

    when users need to connect the database instance using the host naming method

    D

    when the database instance that is to be registered with the listener is configured in shared server mode


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

  • 第12题：

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

  • 第13题：

    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

  • 第14题：

    In which situation would you use static database registration for a listener（）

    • A、when multiple databases are to be registered with the listener
    • B、when DBAs need to connect remotely to start up the database instance
    • C、when users need to connect the database instance using the host naming method
    • D、when the database instance that is to be registered with the listener is configured in shared server mode

    正确答案:B

  • 第15题：

    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

  • 第16题：

    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

  • 第17题：

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

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

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

  • 第21题：

    单选题
    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


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

  • 第22题：

    单选题
    What is the correct order of steps for upgrading a cisco wcs？（）
    A

    back up the database， stop the wcs， upgrade the wcs， restore the database， start the wcs 

    B

    stop the wcs， back up the database， upgrade the wcs， restore the database， start the wcs

    C

    back up the database， stop the wcs， upgrade the wcs， start the wcs， restore the database 

    D

    stop the wcs， back up the database， upgrade the wcs， start the wcs， restore the database


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

  • 第23题：

    单选题
    What is the correct order of steps to perform an online database backup？（）   a. alter database begin backup b. alter database end backup c. Back up the database datafiles d. Back up the archive log files e. alter system switch logfile
    A

    a， b， c， d， e

    B

    e， d， a， b， c

    C

    a， c， b， d， e

    D

    d， b， c， a， e

    E

    a， c， b， e， d


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

  • 第24题：

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

相关内容