单选题What type of protection is implemented when the DBA issues the ALTER DATABASE SET STANDBY DATABASE PROTECTED； command？（）A The standby database is protected against write operations. B The primary database is protected against write operations. C The pr

题目
单选题
What type of protection is implemented when the DBA issues the ALTER DATABASE SET STANDBY DATABASE PROTECTED； command？（）
A

The standby database is protected against write operations. 

B

The primary database is protected against write operations. 

C

The primary database is protected against data loss and data divergence. 

D

The standby database is protected against data loss and data divergence. 

相似考题

1.What are three purposes of the RMAN “FROM” clause?()A. to support PUSH-based active database duplicationB. to support synchronization of a standby database with the primary database in a Data environmentC. To support PULL-based active database duplicationD. To support file restores over the network in a Data Guard environmentE. To support file recovery over the network in a Data Guard environment

2. While an electrician was adding additional circuits for the Data Center， the system running the Database inadvertently powered down. The fallover of the service IP labels and volume groups to the hot standby node completed as expected； however， the database did not start. The database log file indicated that the database was already started.  What is the most likely cause of this problem？（）  A、 The shared logical volumes and filesystems did not have database permissions.B、 There was a test instance running on the standby system that must be shutdown.C、 The tablespaces had an indicator indicating that the database had not shutdown properly.D、 The startup script for the highly available instance did not first perform cleanup operations.

3.You find today’s performance of your production database to be the best ever. Therefore， you want to be notified in the future whenever the performance degrades by 10% of today’s performance. What is the first step that you would take to ensure this？（）A、create baseline metrics for today’s performanceB、write the current database metrics to a database table and create a trigger to compare with future database statisticsC、write the current database metrics to a flat file and create an operating script to compare with future database statisticsD、write the current database metrics to a database table and create a procedure to compare with future database statisticsE、write the current database metrics to a database table and submit a job using DBMS_JOB to compare with future database statistics

4.Which three attributes of the LOG_ARCHIVE_DEST_n initialization parameter control the data availability mode of a Data Guard standby database？ （）A、SYNC or ASYNC to identify the network transmission mode. B、LGWR or ARCH to identify the primary database process responsible for sending redo information to the standby. C、AFFIRM or NOAFFIRM to control whether log archiving disk write operations are to be performed synchronously or asynchronously. D、PROTECTED or UNPROTECTED to control the degree of divergence and data loss at the standby database.

更多“单选题What type of protection is implemented when the DBA issues the ALTER DATABASE SET STANDBY DATABASE PROTECTED； command？（）A The standby database is protected against write operations. B The primary database is protected against write operations. C The pr”相关问题

  • 第1题：

    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

    正确答案:C

  • 第2题：

    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

    正确答案:C

  • 第3题：

    What type of protection is implemented when the DBA issues the ALTER DATABASE SET STANDBY DATABASE PROTECTED； command？（）

    • A、The standby database is protected against write operations. 
    • B、The primary database is protected against write operations. 
    • C、The primary database is protected against data loss and data divergence. 
    • D、The standby database is protected against data loss and data divergence. 

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

     A user issues a SELECT command against the Oracle database. Which of the following choices describes a step that Oracle will execute in support of this statement?（）

    • A、Acquire locks on table queried 
    • B、Generate redo for statement 
    • C、Fetch data from disk into memory 
    • D、Write changes to disk

    正确答案:C

  • 第6题：

    You are a database administrator for your company. The company uses a vendor company’s application that is based on a proprietary database. You query data from the application database and import the data into a SQL Server 2005 database. The application vendor provides you with a new OLE DB driver to be used when querying the application database. Company policy prohibits connections between the SQL Server database and the application database， except when querying this data. You need to provide a way to query data from the application database. What should you？（）

    • A、Configure a Linked Server connection to the application database.
    • B、Write a query that uses an OPENDATASOURCE command.
    • C、Write a query that uses an OPENQUERY command.
    • D、Configure a Remote Server connection to the application database.

    正确答案:B

  • 第7题：

    单选题
    Which command will result in a trace file being created with the create controlfile command contained in it？（）
    A

     alter database backup controlfile

    B

     alter database backup controlfile to trace

    C

     alter database controlfile backup

    D

     alter database controlfile backup to ’/ora01/oracle/ctrl_backup.ctl’

    E

     alter database begin controlfile backup


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

  • 第8题：

    单选题
    What type of protection is implemented when the DBA issues the ALTER DATABASE SET STANDBY DATABASE PROTECTED； command？（）
    A

    The standby database is protected against write operations. 

    B

    The primary database is protected against write operations. 

    C

    The primary database is protected against data loss and data divergence. 

    D

    The standby database is protected against data loss and data divergence. 


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

  • 第9题：

    单选题
    Adam is working as a Database Administrator （DBA） for TeleSoft Corporation. His database is running in the ARCHIVELOG mode. During database startup， he discovers that one of the disks crashed， resulting in the permanent loss of a read-write USERS tablespace. The USERS01.dbf datafile belongs to the USERS tablespace and is 500 MB in size. He needs to recover the USERS tablespace from the backup. While reviewing the backup details， he discovers that the most recent available backup is five days old. This backup was taken when the USERS tablespace was read-only. After correcting the hardware problem that caused the failure， what should Adam do to recover the USERS tablespace？（）
    A

     Restore the USERS01.dbf file from the backup， and open the database using the STARTUP command.

    B

     Restore the USERS01.dbf file using the RECOVER TABLESPACE command， and open the database using the ALTER DATABASE OPEN statement.

    C

     Restore the USERS01.dbf file from the backup， recover the USERS tablespace using the RECOVER TABLESPACE command， and open the database using the ALTER DATABASE OPEN statement.

    D

     Restore the USERS01.dbf file from the backup and change the status of the USERS tablespace from read-only to read-write using the ALTER TABLESPACE USERS READ WRITE statement. Then， recover the USERS tablespace using the RECOVER TABLESPACE command， and open the database using the ALTER DATABASE OPEN statement.


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

  • 第10题：

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

  • 第11题：

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

  • 第12题：

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

  • 第13题：

    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

    正确答案:C

  • 第14题：

    The database is currently running in the NOARCHIVELOG mode. What would be the first step to configure Flashback Database？（）

    • A、 Enable flashback logging.
    • B、 Start the database in the ARCHIVELOG mode.
    • C、 Issue the ALTER DATABASE FLASHBACK ON； command.
    • D、 Set the FAST_START_MTTR_TARGET initialization parameter.

    正确答案:A

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

    Adam is working as a Database Administrator （DBA） for TeleSoft Corporation. His database is running in the ARCHIVELOG mode. During database startup， he discovers that one of the disks crashed， resulting in the permanent loss of a read-write USERS tablespace. The USERS01.dbf datafile belongs to the USERS tablespace and is 500 MB in size. He needs to recover the USERS tablespace from the backup. While reviewing the backup details， he discovers that the most recent available backup is five days old. This backup was taken when the USERS tablespace was read-only. After correcting the hardware problem that caused the failure， what should Adam do to recover the USERS tablespace？（）

    • A、 Restore the USERS01.dbf file from the backup， and open the database using the STARTUP command.
    • B、 Restore the USERS01.dbf file using the RECOVER TABLESPACE command， and open the database using the ALTER DATABASE OPEN statement.
    • C、 Restore the USERS01.dbf file from the backup， recover the USERS tablespace using the RECOVER TABLESPACE command， and open the database using the ALTER DATABASE OPEN statement.
    • D、 Restore the USERS01.dbf file from the backup and change the status of the USERS tablespace from read-only to read-write using the ALTER TABLESPACE USERS READ WRITE statement. Then， recover the USERS tablespace using the RECOVER TABLESPACE command， and open the database using the ALTER DATABASE OPEN statement.

    正确答案:C

  • 第17题：

    What are three purposes of the RMAN “FROM” clause?（）

    • A、to support PUSH-based active database duplication
    • B、to support synchronization of a standby database with the primary database in a Data environment
    • C、To support PULL-based active database duplication
    • D、To support file restores over the network in a Data Guard environment
    • E、To support file recovery over the network in a Data Guard environment

    正确答案:B,C,E

  • 第18题：

    单选题
    While an electrician was adding additional circuits for the Data Center， the system running the Database inadvertently powered down. The fallover of the service IP labels and volume groups to the hot standby node completed as expected； however， the database did not start. The database log file indicated that the database was already started.  What is the most likely cause of this problem？（）
    A

     The shared logical volumes and filesystems did not have database permissions.

    B

     There was a test instance running on the standby system that must be shutdown.

    C

     The tablespaces had an indicator indicating that the database had not shutdown properly.

    D

     The startup script for the highly available instance did not first perform cleanup operations.


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

  • 第19题：

    单选题
    The database is currently running in the NOARCHIVELOG mode. What would be the first step to configure Flashback Database？（）
    A

     Enable flashback logging.

    B

     Start the database in the ARCHIVELOG mode.

    C

     Issue the ALTER DATABASE FLASHBACK ON； command.

    D

     Set the FAST_START_MTTR_TARGET initialization parameter.


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

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

    单选题
    Which is the correct command to put the database in ARCHIVELOG mode？（）
    A

     alter database archivelog

    B

     alter system enable archivelog mode

    C

     alter database enable archive

    D

     alter database archivelog enable

    E

     None of the above


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

  • 第22题：

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

  • 第23题：

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

  • 第24题：

    多选题
    Which three attributes of the LOG_ARCHIVE_DEST_n initialization parameter control the data availability mode of a Data Guard standby database？ （）
    A

    SYNC or ASYNC to identify the network transmission mode.

    B

    LGWR or ARCH to identify the primary database process responsible for sending redo information to the standby.

    C

    AFFIRM or NOAFFIRM to control whether log archiving disk write operations are to be performed synchronously or asynchronously.

    D

    PROTECTED or UNPROTECTED to control the degree of divergence and data loss at the standby database.


    正确答案： A,B,C
    解析： 暂无解析

相关内容