itgle.com

多选题Which three tasks can be performed using a duplicate database?（）ATesting the backup and recovery proceduresBTesting the upgrade of an Oracle database to a new releaseCTesting the effect of an application changes on database performanceDContinuously upd

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

相似考题

1.After you have restored and recovered a database to a new host by using a previously performed Recovery Manager (RMAN) backup, which is the best option you would consider for the new database?()A. Opening the database in RESTRICTED modeB. Opening the database with the RESETLOGS optionC. Setting a new DBID for the newly restored databaseD. Restoring the server parameter file (SPFILE) to the new host

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

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

4.Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN)while duplicating a running database?()A. Creating the control file for the duplicate databaseB. Restoring the target data files to the duplicate databaseC. Performing complete recovery using all available backupsD. Generating a new, unique DBID for the duplicate databaseE. Copying the online redo log files from the target database to the duplicate database

参考答案和解析
正确答案： D,B
解析： 暂无解析
更多“多选题Which three tasks can be performed using a duplicate database?（）ATesting the backup and recovery proceduresBTesting the upgrade of an Oracle database to a new releaseCTesting the effect of an application changes on database performanceDContinuously upd”相关问题

  • 第1题：

    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

  • 第2题：

    You work as a database administrator for Supportcenter.cn. You are using Recovery Manager （RMAN） to perform backups in your databases. Which four backup operations can be performed using RMAN？（）

    • A、A backup of the target database when it is mounted
    • B、A backup of online redo log files when the database is open
    • C、A backup of only used data blocks in the file beingbeingbackup up
    • D、A backup of online， read/write data files when the database is open
    • E、A backup of only those data blocks that have changed since a previous backup
    • F、A backup of online， read/write data files when the database is in the NOMOUNT state.

    正确答案:A,C,D,E

  • 第3题：

    You performed an incomplete recovery on your Oracle Database 10g database using the following command：   SQL> RECOVER DATABASE  2 UNTIL TIME ’2004-08-05：12：10：03’ 3 USING BACKUP CONTROLFILE；  In which situation would the above recovery be required？（）

    • A、 A user table was lost at the specified time.
    • B、 A redo log file was lost at the specified time.
    • C、 The backup control file is on a faster disk than the current one.
    • D、 The current control file has a different path compared with the intended time of recovery.
    • E、 The current control file does not match the physical structure of the database at the intended time of recovery.

    正确答案:E

  • 第4题：

    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

  • 第5题：

    After you have restored and recovered a database to a new host by using a previously performed Recovery Manager （RMAN） backup， which is the best option you would consider for the new database？（）  

    • A、 Opening the database in RESTRICTED mode
    • B、 Opening the database with the RESETLOGS option
    • C、 Setting a new DBID for the newly restored database
    • D、 Restoring the server parameter file （SPFILE） to the new host

    正确答案:B

  • 第6题：

    You are maintaining your database in Oracle10g. On Tuesday at 8：00 A.M.， while starting the database， you discover that all the control files are missing. The backup of the full database was performed on Sunday at 6：00 P.M. Which type of recovery will you perform？（）

    • A、 incomplete recovery
    • B、 complete recovery
    • C、 recovery using the Flashback Database feature
    • D、 recovery using the export/import utility

    正确答案:A

  • 第7题：

    Which two operations are NOT performed by the DUPLICATE command in Recovery Manager （RMAN） while duplicating a running database？（）

    • A、 Creating the control file for the duplicate database
    • B、 Restoring the target data files to the duplicate database
    • C、 Performing complete recovery using all available backups
    • D、 Generating a new， unique DBID for the duplicate database
    • E、 Copying the online redo log files from the target database to the duplicate database

    正确答案:C,E

  • 第8题：

    多选题
    You work as a database administrator for Supportcenter.cn. You are using Recovery Manager （RMAN） to perform backups in your databases. Which four backup operations can be performed using RMAN？（）
    A

    A backup of the target database when it is mounted

    B

    A backup of online redo log files when the database is open

    C

    A backup of only used data blocks in the file beingbeingbackup up

    D

    A backup of online， read/write data files when the database is open

    E

    A backup of only those data blocks that have changed since a previous backup

    F

    A backup of online， read/write data files when the database is in the NOMOUNT state.


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

  • 第9题：

    多选题
    You are using Oracle Database 10g. You performed an incomplete recovery of your database and opened the database with the RESETLOGS option.  What is the effect of opening the database with the RESETLOGS option？ （）
    A

    This operation resets the SCN for the database.

    B

    This operation creates a new incarnation of the database.

    C

    This operation moves all the redo log files to a different location.

    D

    This operation deletes the old redo log files and creates new redo log files.

    E

    This operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.


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

  • 第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 using a recovery catalog to maintain Recovery Manager (RMAN) backup information for yourproduction database. You have registered your production database and are performing regular backups. Because of a new requirement you have added a few new tablespaces to your production database and youwant them to be included in backups.Identify two options for completing this task. （）(Choose two.)
    A

    Reregistering the target database in recovery catalog

    B

    Transporting the new tablespaces to the recovery catalog database

    C

    Syncronizing the recovery catalog with the target database control file

    D

    Performing a fresh backup of the target database to include the new data files in the catalog database


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

  • 第12题：

    单选题
    You administer an Oracle Database 10g and a third-party database. You use Recovery Manager （RMAN） to perform backup and recovery operations. You have configured a recovery catalog to act as an RMAN repository. To which of the following databases can you NOT connect using the RMAN CONNECT command？（）
    A

     target database

    B

     auxiliary database

    C

     third-party database

    D

     recovery catalog database


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

  • 第13题：

    SQ L*Loader is a utility that can perform which two tasks？（）

    • A、Load data from a disk， tape， or named pipes.
    • B、Load data into an Oracle database using DML statements.
    • C、Extract， reorganize， and insert data within an Oracle database.
    • D、Load data from external files into tables in an Oracle database.
    • E、Load data into an Oracle database using operating system commands.
    • F、Load data directly from a non-Oracle database to an Oracle database.

    正确答案:A,D

  • 第14题：

    Which two changes and their effect on the system can be tested by using the Database Replay feature？（）

    • A、 multiplexing of the control file
    • B、 adding the redo log member to the database
    • C、 database and operating system upgrades
    • D、 changing the database storage to ASM-managed storage

    正确答案:C,D

  • 第15题：

    You are using Oracle Database 10g. You performed an  incomplete recovery of your database and opened the database with the RESETLOGS option.  What is the effect of opening the database with the RESETLOGS option？（）

    • A、This operation resets the SCN for the database.
    • B、This operation creates a new incarnation of the database.
    • C、This operation moves all the redo log files to a different location.
    • D、This operation deletes the old redo log files and creates new redo log files.
    • E、This operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.

    正确答案:B,E

  • 第16题：

    You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup？（）

    • A、 online redo log files
    • B、 alert log files
    • C、 control file
    • D、 datafiles associated with the SYSTEM tablespace

    正确答案:C

  • 第17题：

    You administer an Oracle Database 10g and a third-party database. You use Recovery Manager （RMAN） to perform backup and recovery operations. You have configured a recovery catalog to act as an RMAN repository. To which of the following databases can you NOT connect using the RMAN CONNECT command？（）

    • A、 target database
    • B、 auxiliary database
    • C、 third-party database
    • D、 recovery catalog database

    正确答案:C

  • 第18题：

    Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN) whileduplicating a running database? （）(Choose Two)

    • A、Creating the control file for the duplicate database
    • B、Restoring the target data files to the duplicate database
    • C、Performing complete recovery using all available backups
    • D、Generating a new, unique DBID for the duplicate database
    • E、Copying the online redo log files from the target database to the duplicate database

    正确答案:C,E

  • 第19题：

    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

  • 第20题：

    单选题
    You are maintaining your database in Oracle10g. On Tuesday at 8：00 A.M.， while starting the database， you discover that all the control files are missing. The backup of the full database was performed on Sunday at 6：00 P.M. Which type of recovery will you perform？（）
    A

     incomplete recovery

    B

     complete recovery

    C

     recovery using the Flashback Database feature

    D

     recovery using the export/import utility


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

  • 第21题：

    单选题
    After you have restored and recovered a database to a new host by using a previously performed Recovery Manager （RMAN） backup， which is the best option you would consider for the new database？（）
    A

     Opening the database in RESTRICTED mode

    B

     Opening the database with the RESETLOGS option

    C

     Setting a new DBID for the newly restored database

    D

     Restoring the server parameter file （SPFILE） to the new host


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

  • 第22题：

    多选题
    Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN) whileduplicating a running database? （）(Choose Two)
    A

    Creating the control file for the duplicate database

    B

    Restoring the target data files to the duplicate database

    C

    Performing complete recovery using all available backups

    D

    Generating a new, unique DBID for the duplicate database

    E

    Copying the online redo log files from the target database to the duplicate database


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

  • 第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
    解析： 暂无解析

  • 第24题：

    多选题
    SQ L*Loader is a utility that can perform which two tasks？（）
    A

    Load data from a disk， tape， or named pipes.

    B

    Load data into an Oracle database using DML statements.

    C

    Extract， reorganize， and insert data within an Oracle database.

    D

    Load data from external files into tables in an Oracle database.

    E

    Load data into an Oracle database using operating system commands.

    F

    Load data directly from a non-Oracle database to an Oracle database.


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

相关内容