单选题When performing a database duplication， which duplicate database parameter would you set to ensure that the online redo logs are created in the correct location？（）Alog_file_name_convertBconvert_log_file_nameCfile_name_convert_logDredo_log_file_name_con

题目
单选题
When performing a database duplication， which duplicate database parameter would you set to ensure that the online redo logs are created in the correct location？（）
A

 log_file_name_convert

B

 convert_log_file_name

C

 file_name_convert_log

D

 redo_log_file_name_convert

E

 logfile_convert_directory

相似考题

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

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

3.Examine the following command that is used to duplicate a database on the same host:RMAN> RUN{ALLOCATE AUXILIARY CHANNEL, aux 1 DEVICE TYPE DISK;DUPLICATE TARGET DATABASE TO auxdb SKIP READONLY; \ }Which two statements describe the effect after the database is duplicated successfully? （）(Choose two)A. The data files of the read-only tablespaces in the target database are not duplicatedB. The read-only tablespaces in the target database are still defined in new the databaseC. The read-only tablespaces in the target database are changed to online after duplicationD. The data files of the read-only tablespaces in the target database get duplicatedE. The read-only tablespaces in the target database are not defined in the new database

4.You are managing an Oracle Database 11g instance.You want to create a duplicate database for testing purpose. What are the prerequisites for performing the active database duplication?()A. The source database backup must be copied over the net for test database.B. The source database must be run in ARCHIVELOG mode if the database is open.C. The source database must be shut down cleanly if the database is in mounted state.D. A net service name should be set up and a listener configured with the target as well as the source database.

更多“When performing a database duplication， which duplicate data”相关问题

  • 第1题：

    Examine the following scenario:The target database instance is running. The most recent backup available for the target database was taken two days ago. Log files switches have occurred in last two days. The target database is duplicated on the same host, using the Recovery Manager (RMAN) duplicate command as follows:Which statement is true about the duplicate database in this scenario?（）

    A. It contains data till the last backup

    B. It contains all data from target database until the current time

    C. It contains all data from only the committed transactions in the target database

    D. It contains all data except that which is used by the transactions in the current online redo file of target database


    参考答案：D

  • 第2题：

    Moving data is one of the most common causes of planned downtime. For which of the followingpurposes might the data migration function of the SAN Volume Controller be used？（）

    • A、when replacing an SVC node due to a failure
    • B、when migrating from a Windows OS to a Linux OS
    • C、when replacing older storage with newer storage
    • D、when performing a firmware upgrade on the SVC console

    正确答案:C

  • 第3题：

    When youre performing active database duplication，a backup of what kind is required？（）  

    • A、 A current RMAN backup-set backup is required.
    • B、 No backup is required.
    • C、 An RMAN image backup is required.
    • D、 A manual backup is required.
    • E、 A "duplicate" preparatory backup is required.

    正确答案:B

  • 第4题：

    When performing an incomplete recover of the whole database， which data files must you restore？ （）

    • A、Only the damaged or lost data files.
    • B、All of the data files of the database.
    • C、Only the data files belonging to the SYSTEM tablespace.
    • D、The data files belonging to the SYSTEM tablespace and the damaged or lost data files.

    正确答案:B

  • 第5题：

    In which situation would you use the Oracle Shared Server configuration？（）

    • A、when performing export and import using Oracle Data Pump
    • B、when performing backup and recovery operations using Oracle Recovery Manager
    • C、when performing batch processing and bulk loading operation in a data warehouse environment 
    • D、in an online transaction processing （OLTP） system where large number of client sessions are idle most of the time

    正确答案:D

  • 第6题：

    When performing a database duplication， which duplicate database parameter would you set to ensure that the online redo logs are created in the correct location？（）  

    • A、 log_file_name_convert
    • B、 convert_log_file_name
    • C、 file_name_convert_log
    • D、 redo_log_file_name_convert
    • E、 logfile_convert_directory

    正确答案:A

  • 第7题：

    单选题
    Your database is running in ARCHIVELOG mode. You are performing a user-managed backup of the DATA1 tablespace. You place the DATA1 tablespace in backup mode by issuing the following statement: ALTER TABLESPACE data1 BEGIN BACKUP; While you are performing the backup, an error occurs that causes the instance to terminate abnormally. Which statement about the DATA1 tablespace is true?（）
    A

    The DATA1 tablespace is automatically taken out of backup mode when the instance aborts.

    B

    If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is opened.

    C

    If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is mounted.

    D

    If you restart the database, the database will not be opened.


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

  • 第8题：

    单选题
    When performing an incomplete recover of the whole database， which data files must you restore？ （）
    A

    Only the damaged or lost data files.

    B

    All of the data files of the database.

    C

    Only the data files belonging to the SYSTEM tablespace.

    D

    The data files belonging to the SYSTEM tablespace and the damaged or lost data files.


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

  • 第9题：

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

  • 第10题：

    多选题
    You work as a database administrator for Certkiller .com. 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
    解析： 暂无解析

  • 第11题：

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


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

  • 第12题：

    单选题
    When performing a database duplication， which duplicate database parameter would you set to ensure that the online redo logs are created in the correct location？（）
    A

     log_file_name_convert

    B

     convert_log_file_name

    C

     file_name_convert_log

    D

     redo_log_file_name_convert

    E

     logfile_convert_directory


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

  • 第13题：

    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

  • 第14题：

    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

  • 第15题：

    Examine the following command that is used to duplicate a database on the same host: RMAN> RUN { ALLOCATE AUXILIARY CHANNEL, aux 1 DEVICE TYPE DISK; DUPLICATE TARGET DATABASE TO auxdb SKIP READONLY; / } Which two statements describe the effect after the database is duplicated successfully? （）(Choose two)

    • A、The data files of the read-only tablespaces in the target database are not duplicated
    • B、The read-only tablespaces in the target database are still defined in new the database
    • C、The read-only tablespaces in the target database are changed to online after duplication
    • D、The data files of the read-only tablespaces in the target database get duplicated
    • E、The read-only tablespaces in the target database are not defined in the new database

    正确答案:A,B

  • 第16题：

    you can perform an active database duplication when the database is in NOARCHIVELOG mode.（）

    • A、 True
    • B、 False

    正确答案:B

  • 第17题：

    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

  • 第18题：

    单选题
    Your database is running in ARCHIVELOG mode. You are performing a user-managed backup of the DATA1 tablespace.  You place the DATA1 tablespace in backup mode by issuing the following statement：   ALTER TABLESPACE data1 BEGIN BACKUP；   While you are performing the backup， an error occurs that causes the instance to terminate abnormally. Which statement about the DATA1 tablespace is true？（）
    A

     The DATA1 tablespace is automatically taken out of backup mode when the instance aborts.

    B

     If you restart the database，the DATA1 tablespace will be automatically taken out of backup mode  when the database is opened.

    C

     If you restart the database，the DATA1 tablespace will be automatically taken out of backup mode  when the database is mounted.

    D

     If you restart the database，the database will not be opened.


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

  • 第19题：

    单选题
    Examine the following scenario： The target database instance is running. The most recent backup available for the target database was taken two days ago. Log files switches have occurred in last two days. The target database is duplicated on the same host， using the Recovery Manager （RMAN） duplicate command as follows：   RMAN> RUN { ALLOCATE AUXILIARY CHANNEL aux 1 DEVICE TYPE DISK；  DUPLICATE TARGET DATABASE TO auxdb； }   Which statement is true about the duplicate database in this scenario？（）
    A

     It contains data till the last backup

    B

     It contains all data from target database until the current time

    C

     It contains all data from only the committed transactions in the target database

    D

     It contains all data except that which is used by the transactions in the current online redo file of target database


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

  • 第20题：

    多选题
    You are working on a database that must be functioning 24 hours a day， 7 days a week. The database isconfigured in ARCHIVELOG mode. Which two options do you have for performing user-managed backups（）
    A

    You can perform consistent backups only.

    B

    You can perform a complete database backup without shutting down the database instance.

    C

    You can back up data files only when all data files have the same SCN recorded in the control file.

    D

    You can back up only those data files whose headers are frozen by using ALTER TABLESPACE BEGINBACKUP or ALTER DATABASE BEGIN BACKUP commands


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

  • 第21题：

    单选题
    you can perform an active database duplication when the database is in NOARCHIVELOG mode.（）
    A

     True

    B

     False


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

  • 第22题：

    多选题
    You are managing an Oracle Database 11g instance.You want to create a duplicate database for testing purpose. What are the prerequisites for performing the active database duplication?（）
    A

    The source database backup must be copied over the net for test database.

    B

    The source database must be run in ARCHIVELOG mode if the database is open.

    C

    The source database must be shut down cleanly if the database is in mounted state.

    D

    A net service name should be set up and a listener configured with the target as well as the source database.


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

  • 第23题：

    多选题
    Examine the following command that is used to duplicate a database on the same host：   RMAN> RUN {  ALLOCATE AUXILIARY CHANNEL， aux 1 DEVICE TYPE DISK； DUPLICATE TARGET DATABASE TO auxdb SKIP READONLY； / } Which two statements describe the effect after the database is duplicated successfully？（）
    A

    The data files of the read-only tablespaces in the target database are not duplicated

    B

    The read-only tablespaces in the target database are still defined in new the database

    C

    The read-only tablespaces in the target database are changed to online after duplication

    D

    The data files of the read-only tablespaces in the target database get duplicated

    E

    The read-only tablespaces in the target database are not defined in the new database


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

  • 第24题：

    单选题
    When youre performing active database duplication，a backup of what kind is required？（）
    A

     A current RMAN backup-set backup is required.

    B

     No backup is required.

    C

     An RMAN image backup is required.

    D

     A manual backup is required.

    E

     A duplicate preparatory backup is required.


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

相关内容