多选题What are three purposes of the RMAN “FROM” clause?（）Ato support PUSH-based active database duplicationBto support synchronization of a standby database with the primary database in a Data environmentCTo support PULL-based active database duplicationDTo

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

相似考题

1.Which three tasks can be performed using a duplicate database?()A. Testing the backup and recovery proceduresB. Testing the upgrade of an Oracle database to a new releaseC. Testing the effect of an application changes on database performanceD. Continuously updating archive log files from the target database to support failover

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

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

4.Which three tasks can be performed using a duplicate database? ()(Choose three.)A. Testing the backup and recovery proceduresB. Testing the upgrade of an Oracle database to a new releaseC. Testing the effect of an application changes on database performanceD. Continuously updating archive log files from the target database to support failover

更多“多选题What are three purposes of the RMAN “FROM” clause?（）Ato support PUSH-based active database duplicationBto support synchronization of a standby database with the primary database in a Data environmentCTo support PULL-based active database duplicationDTo”相关问题

  • 第1题：

    To view the results of the most recent Automatic SQL Tuning Advisor task, which sequence should you follow?（）

    • A、EM Database home page, Software and Support, SQL Advisors, Automatic SQL Tuning Advisor.
    • B、EM Database home page, Software and Support, Advisor Central, SQL Advisors, Automatic SQL Tuning Advisor.
    • C、EM Database home page, Software and Support, Support Workbench, Advisor Central, SQL Advisors, Automatic SQL Tuning Advisor.
    • D、Either B or C
    • E、All of the above

    正确答案:D

  • 第2题：

    In RMAN， when the RESYNC CATALOG command is issued， in which two situations does the command file actually perform synchronization？（）

    • A、After the COPY command.
    • B、After adding a data file in the target database.
    • C、After adding a tablespace in the target database.
    • D、After adding a tablespace in the catalog database.
    • E、After dropping a data file in the catalog database.
    • F、After running SQL Loader to load a large amount of data.

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

    To view the results of the most recent Automatic SQL Tuning Advisor task，which sequence should you follow？（）  

    • A、 EM Database home page，Software and Support，SQL Advisors，Automatic SQL Tuning Advisor
    • B、 EM Database home page，Software and Support，Advisor Central，SQL Advisors，Automatic SQL Tuning Advisor
    • C、 EM Database home page，Software and Support，Support Workbench，Advisor Central，SQL Advisors，Automatic SQL Tuning Advisor
    • D、 Either B or C
    • E、 All of the above

    正确答案:D

  • 第5题：

    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

  • 第6题：

    Your company has a main office and a branch office. You plan to deploy a Read-only Domain  Controller （RODC） in the branch office.   You need to plan a strategy to manage the RODC. Your plan must meet the following requirements：   èAllow branch office support technicians to maintain drivers and disks on the RODC èPrevent branch office support technicians from managing domain user accounts  What should you include in your plan？（）

    • A、Configure the RODC for Administrator Role Separation.
    • B、Configure the RODC to replicate the password for the branch office support technicians.
    • C、Set NTFS permissions on the Active Directory database to Read & Execute for the branch officesupport technicians.
    • D、Set NTFS permissions on the Active Directory database to Deny Full Control for the branch office support technicians.

    正确答案:A

  • 第7题：

    多选题
    In an environment that includes both a Master Domain Manager （MDM）  and Backup Master Domain Manger （BMDM），  which two options are  appropriate for the location of the database？ （）
    A

    local database installed on the MDM only

    B

    live local database installed on the BMDM only

    C

    single database on a clustered machine remote from the MDM and BMDM

    D

    live database installed on a single Fault Tolerant Agent within IBM  Tivoli Workload Scheduler network

    E

    live database on MDM and High Availability Disaster Recovery/Data  Guard standby database on BMDM


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

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

    单选题
    A support engineer reports that inserting new sales transactions in a SQL Server 2005 database results in an error. You investigate the error. You discover that in one of the databases, a developer has accidentally deleted some data in a table that is critical for transaction processing. The database uses the full recovery model. You need to restore the table. You need to achieve this goal without affecting the availability of other data in the database.  What should you do?（）
    A

     Back up the current transaction log. Restore the database with a different name and stop at the point just before the data loss. Copy the table back into the original database.

    B

     Back up the current transaction log. Restore the database to the point just before the data loss.

    C

     Restore the database from the existing backup files to a time just before the data loss.

    D

     Restore the database to the point of the last full backup.


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

  • 第10题：

    多选题
    Which three tasks can be performed using a duplicate database? （）(Choose three.)
    A

    Testing the backup and recovery procedures

    B

    Testing the upgrade of an Oracle database to a new release

    C

    Testing the effect of an application changes on database performance

    D

    Continuously updating archive log files from the target database to support failover


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

  • 第11题：

    单选题
    You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. A vendor company’s application is utilized， and the application is based on a proprietary database. Data is queried from the application database and the data is imported into a SQL Server 2005 database. A new OLE DB driver is offered by the application vendor， and the new OLE DB driver will be utilized when the application database is queried. According the company requirements， the connections between the SQL Server database and the application database is prohibited， except when this data is queried. You should think out a method to have data queried from the application database.  Which action should be performed to achieve the goal？（）
    A

    To achieve the goal， a Linked Server connection should be configured to the application database.

    B

    To achieve the goal， a query should be written， and an OPENQUERY command is utilized by the query.

    C

    To achieve the goal， a Remote Server connection to the application database should be configured.

    D

    To achieve the goal， a query should be written， and an OPENDATASOURCE command is utilized by the query.


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

  • 第12题：

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

  • 第13题：

    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

  • 第14题：

    Which three tasks can be performed using a duplicate database? （）(Choose three.)

    • A、Testing the backup and recovery procedures
    • B、Testing the upgrade of an Oracle database to a new release
    • C、Testing the effect of an application changes on database performance
    • D、Continuously updating archive log files from the target database to support failover

    正确答案:A,B,C

  • 第15题：

    You are working as a DBA on the decision support system. There is a business requirement to track and store all transactions for at least three years for a few tables in the database. Automatic undo management is enabled in the database.  Which configuration should you use to accomplish this task？（）

    • A、 Enable Flashback Data Archive for the tables.
    • B、 Specify undo retention guarantee for the database.
    • C、 Enable supplemental logging for the database.
    • D、 Query V$UNDOSTAT to determine the amount of undo that will be generated and create an undo  tablespace for that size.
    • E、 Create Flashback Data Archive on the tablespace on which the tables are stored.

    正确答案:A

  • 第16题：

    Which three tasks can be performed using a duplicate database？（）

    • A、 Testing the backup and recovery procedures
    • B、 Testing the upgrade of an Oracle database to a new release
    • C、 Testing the effect of an application changes on database performance
    • D、 Continuously updating archive log files from the target database to support failover

    正确答案:A,B,C

  • 第17题：

    A support engineer reports that inserting new sales transactions in a SQL Server 2005 database results in an error. You investigate the error. You discover that in one of the databases， a developer has accidentally deleted some data in a table that is critical for transaction processing. The database uses the full recovery model. You need to restore the table. You need to achieve this goal without affecting the availability of other data in the database. What should you do？（）

    • A、Back up the current transaction log. Restore the database with a different name and stop at the point just before the data loss. Copy the table back into the original database.
    • B、Back up the current transaction log. Restore the database to the point just before the data loss.
    • C、Restore the database from the existing backup files to a time just before the data loss.
    • D、Restore the database to the point of the last full backup.

    正确答案:A

  • 第18题：

    You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. A vendor company’s application is utilized， and the application is based on a proprietary database. Data is queried from the application database and the data is imported into a SQL Server 2005 database. A new OLE DB driver is offered by the application vendor， and the new OLE DB driver will be utilized when the application database is queried. According the company requirements， the connections between the SQL Server database and the application database is prohibited， except when this data is queried. You should think out a method to have data queried from the application database.  Which action should be performed to achieve the goal？（）

    • A、To achieve the goal， a Linked Server connection should be configured to the application database.
    • B、To achieve the goal， a query should be written， and an OPENQUERY command is utilized by the query.
    • C、To achieve the goal， a Remote Server connection to the application database should be configured.
    • D、To achieve the goal， a query should be written， and an OPENDATASOURCE command is utilized by the query.

    正确答案:D

  • 第19题：

    单选题
    You are working as a DBA on the decision support system. There is a business requirement to track and store all transactions for at least three years for a few tables in the database. Automatic undo management is enabled in the database.  Which configuration should you use to accomplish this task？（）
    A

     Enable Flashback Data Archive for the tables.

    B

     Specify undo retention guarantee for the database.

    C

     Enable supplemental logging for the database.

    D

     Query V$UNDOSTAT to determine the amount of undo that will be generated and create an undo  tablespace for that size.

    E

     Create Flashback Data Archive on the tablespace on which the tables are stored.


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

  • 第20题：

    多选题
    In RMAN， when the RESYNC CATALOG command is issued， in which two situations does the command file actually perform synchronization？（）
    A

    After the COPY command.

    B

    After adding a data file in the target database.

    C

    After adding a tablespace in the target database.

    D

    After adding a tablespace in the catalog database.

    E

    After dropping a data file in the catalog database.

    F

    After running SQL Loader to load a large amount of data.


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

  • 第21题：

    单选题
    You are managing the APPPROD database as a DBA which is not using the Oracle-managed files. You plan to duplicate this database in the same system with the name DUPDB.You want to create the same directory structure for duplicate database files as of the target database. You executed the following RMAN commands：   RMAN> CONNECT TARGET sys/sys@APPPROD RMAN> CONNECT AUXILIARY sys/sys@DUPDB RMAN> DUPLICATE TARGET DATABASE TO dupdb  FROM ACTIVE DATABASE PASSWORD FILE SPILE  NOFILENAMECHECK；   What are the implications of this command？（）
    A

     It creates database files for the duplicate database under the Oracle base with a different directory for the duplicate database.

    B

     It overwrites data files of the target database because a different location for data files is not mentioned for the duplicate database.

    C

     It creates database files for the duplicate database under the same Oracle home as that of the target database with the same directory structure.

    D

     It creates database files for the duplicate database under the same Oracle home as that of the target but with a different directory for the duplicate database.


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

  • 第22题：

    多选题
    Which three statements are true about database recovery operations？（）
    A

    Damaged or lost data files are restored from backups.

    B

    Redo log file entries are used to roll forward the database.

    C

    Undo segments are used to roll back any uncommitted transactions.

    D

    Transactions that were active when the failure occurred are restarted.

    E

    Transactions that were active when the failure occurred are automatically committed during the recover procedure.


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

  • 第23题：

    多选题
    Which three tasks can be performed using a duplicate database？（）
    A

    Testing the backup and recovery procedures

    B

    Testing the upgrade of an Oracle database to a new release

    C

    Testing the effect of an application changes on database performance

    D

    Continuously updating archive log files from the target database to support failover


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

相关内容