itgle.com

多选题Which two changes and their effect on the system can be tested by using the Database Replay feature？（）Amultiplexing of the control fileBadding the redo log member to the databaseCdatabase and operating system upgradesDchanging the database storage to A

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

相似考题

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. Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt：     RMAN> CONFIGURE CONTROLFILE AUTOBACKUP OFF；   RMAN> BACKUP DATABASE；   Which files from the database will be backed up as a result of this BACKUP command？（）A、 control fileB、 all datafilesC、 password fileD、 online redo log fileE、 archive redo log fileF、 server parameter fileG、 only the SYSTEM datafile

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

4.Which two changes and their effect on the system can be tested by using the Database Replay feature？（）A、 multiplexing of the control fileB、 adding the redo log member to the databaseC、 database and operating system upgradesD、 changing the database storage to ASM-managed storage

更多“多选题Which two changes and their effect on the system can be tested by using the Database Replay feature？（）Amultiplexing of the control fileBadding the redo log member to the databaseCdatabase and operating system upgradesDchanging the database storage to A”相关问题

  • 第1题：

    You work as a database administrator for Certkiller .com. Users in the Certkiller PROD database complain about the slow response when accessing the database. In the Active Session Waiting： Configuration page you find that the majority of the wait time is for the redo log buffer.Further investigation using the Run Queue graph and operating system tools reveals that the redo log files are on the same disks， and that the disk I/O for the redo log files is the reason for the performance degradation.  Which two actions would you take to gain performance？（）

    • A、Increase the size of redo log files
    • B、Increase the size of redo log buffer
    • C、Increase the number of redo log files
    • D、Place the redo log files on a separate disk
    • E、Decrease the number of redo log groups to two
    • F、Increate the number Log Writer （LGWR） process

    正确答案:B,D

  • 第2题：

    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

  • 第3题：

    You have configured OMF in your database. You enabled the ALTER DATABASE ENABLE BLOCK CHANGE TRACKING； statement to enable the block change tracking feature.  What information will be written in the change tracking file？（）

    • A、 the system change number
    • B、 the locations of the redo log files
    • C、 the locations of the datafiles
    • D、 the physical location of all the database changes

    正确答案:D

  • 第4题：

    You are working on a database， where you have three redo log groups. When the database is down for a backup， an operating system （OS） user deletes all the redo log files in a group. What will happen when you open your database？（）

    • A、 The instance starts， the database is mounted， but efforts to open the database fail， and an error about the missing redo log group is displayed.
    • B、 Before the instance starts， you receive an error about the missing redo log files of a group.
    • C、 The instance starts and the database opens with an error message written to the alert log file.
    • D、 The instance starts and the database opens because two redo log groups still exist.
    • E、 The instance starts and the database opens， but every attempt to write to redo log files fails with an error.

    正确答案:A

  • 第5题：

    You are working on Oracle Database 10g， which is in ARCHIVELOG mode. All the archived log files are intact. In which scenario would performing a recovery require the opening of the database with the RESETLOGS option？（）

    • A、 loss of one of the tablespaces
    • B、 loss of a system data file
    • C、 loss of one of the control files
    • D、 loss of a tempfile
    • E、 loss of the only member of an unarchived redo log group
    • F、 loss of a member from each redo log group

    正确答案:E

  • 第6题：

    多选题
    You work as a database administrator for Certkiller .com. Users in the Certkiller PROD database complain about the slow response when accessing the database. In the Active Session Waiting： Configuration page you find that the majority of the wait time is for the redo log buffer.Further investigation using the Run Queue graph and operating system tools reveals that the redo log files are on the same disks， and that the disk I/O for the redo log files is the reason for the performance degradation.  Which two actions would you take to gain performance？（）
    A

    Increase the size of redo log files

    B

    Increase the size of redo log buffer

    C

    Increase the number of redo log files

    D

    Place the redo log files on a separate disk

    E

    Decrease the number of redo log groups to two

    F

    Increate the number Log Writer （LGWR） process


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

  • 第7题：

    单选题
    Because of hardware failure， you decided to drop a redo log member from the database. Which condition should be met to drop a redo log file？（）
    A

     The redo log file should belong to an active group.

    B

     The redo log file should belong to an inactive group.

    C

     The redo log file should belong to the current group.

    D

     The redo log file can be dropped only if all the transactions are stopped.

    E

     Before a redo log file is dropped， it should be deleted from the operating system （OS）.


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

  • 第8题：

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

  • 第9题：

    单选题
    You are working on Oracle Database 10g， which is in ARCHIVELOG mode. All the archived log files are intact. In which scenario would performing a recovery require the opening of the database with the RESETLOGS option？（）
    A

     loss of one of the tablespaces

    B

     loss of a system data file

    C

     loss of one of the control files

    D

     loss of a tempfile

    E

     loss of the only member of an unarchived redo log group

    F

     loss of a member from each redo log group


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

  • 第10题：

    多选题
    Which two files in the database can be configured for automatic backups by using the autobackupfeature in Recovery Manager （RMAN）（）
    A

    data files

    B

    control files

    C

    parameter file

    D

    online redo log files

    E

    server parameter file


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

  • 第11题：

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

  • 第12题：

    多选题
    In which two cases would you perform only consistent backup？（）
    A

    You are working on a database where downtime is not tolerated.

    B

    You are working on a database where downtime can be tolerated.

    C

    You are working on a database that operates in ARCHIVELOG mode.

    D

    You are working on a database that operates in NOARCHIVELOG mode.

    E

    You are working on a database where all the tablespaces are locally managed.

    F

    You are working on a database where control files and redo log files are multiplexed.

    G

    You are working on a database where control files and redo log files are not multiplexed.


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

  • 第13题：

    Which two file types must be included in a closed database backup taken with operating system commands？（）

    • A、data files
    • B、control file
    • C、password file
    • D、online redo log files
    • E、initialization parameter file

    正确答案:A,B

  • 第14题：

    Because of hardware failure， you decided to drop a redo log member from the database. Which condition should be met to drop a redo log file？（）

    • A、 The redo log file should belong to an active group.
    • B、 The redo log file should belong to an inactive group.
    • C、 The redo log file should belong to the current group.
    • D、 The redo log file can be dropped only if all the transactions are stopped.
    • E、 Before a redo log file is dropped， it should be deleted from the operating system （OS）.

    正确答案:B

  • 第15题：

    Which two files in the database can be configured for automatic backups by using the autobackupfeature in Recovery Manager （RMAN）（）

    • A、data files
    • B、control files
    • C、parameter file
    • D、online redo log files
    • E、server parameter file

    正确答案:B,E

  • 第16题：

    Which two files in the database can be configured for automatic backups by using the autobackup feature inRecovery Manager （RMAN）（）

    • A、Data files
    • B、Control files
    • C、Parameter file
    • D、Online redo log files
    • E、Server parameter file

    正确答案:B,E

  • 第17题：

    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

  • 第18题：

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


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

  • 第19题：

    单选题
    You are working on Oracle Database 10g， which is in ARCHIVELOG mode. All the archived log files are intact.  In which scenario would performing a recovery require the opening of the database with the RESETLOGS option？（）
    A

    loss of a tempfile

    B

    loss of a system data file

    C

    loss of one of the control files

    D

    loss of one of the tablespaces

    E

    loss of a member from each redo log group

    F

    loss of the only member of an unarchived redo log group


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

  • 第20题：

    多选题
    Which two file types must be included in a closed database backup taken with operating system commands？（）
    A

    data files

    B

    control file

    C

    password file

    D

    online redo log files

    E

    initialization parameter file


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

  • 第21题：

    多选题
    Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt：     RMAN> CONFIGURE CONTROLFILE AUTOBACKUP OFF；   RMAN> BACKUP DATABASE；   Which files from the database will be backed up as a result of this BACKUP command？（）
    A

    control file

    B

    all datafiles

    C

    password file

    D

    online redo log file

    E

    archive redo log file

    F

    server parameter file

    G

    only the SYSTEM datafile


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

  • 第22题：

    多选题
    Which two files in the database can be configured for automatic backups by using the autobackup feature inRecovery Manager （RMAN）（）
    A

    Data files

    B

    Control files

    C

    Parameter file

    D

    Online redo log files

    E

    Server parameter file


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

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

相关内容