niusouti.com

多选题Which two statements are correct about database transportation？（）AThe source and target platforms must be the sameBRedo logs，control files and temp files are also transportedCThe transported database must have the same database identifier （DBID） as the

题目
多选题
Which two statements are correct about database transportation？（）
A

The source and target platforms must be the same

B

Redo logs，control files and temp files are also transported

C

The transported database must have the same database identifier （DBID） as the source database and cannot be changed

D

The COMPATIBLE parameter must be set to 10.0.0.0 or higher and the database must be opened in readonly mode before being transported

E

Recovery Manager （RMAN） is used to convert the necessary data files of the database if the target platform is different and has different endian format

相似考题

1.Examine the following command that is used to duplicate a database on the same host: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 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

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.Which two statements are correct about database transportation?() (Choose two.)A. The source and target platforms must be the sameB. Redo logs, control files and temp files are also transportedC. The transported database must have the same database identifier (DBID) as the source database and cannot be changedD. The COMPATIBLE parameter must be set to 10.0.0.0 or higher and the database must be opened in readonly mode before being transportedE. Recovery Manager (RMAN) is used to convert the necessary data files of the database if the target platform is different and has different endian format

4.Which two statements are correct about database transportation? ()A. The source and target platforms must be the sameB. Redo logs, control files and temp files are also transportedC. The transported database must have the same database identifier (DBID) as the source database and cannot be changedD. The COMPATIBLE parameter must be set to 10.0.0.0 or higher and the database must be opened in readonly mode before being transportedE. Recovery Manager (RMAN) is used to convert the necessary data files of the database if the target platform is different and has different endian format

参考答案和解析
正确答案： B,A
解析： 暂无解析
更多“多选题Which two statements are correct about database transportation？（）AThe source and target platforms must be the sameBRedo logs，control files and temp files are also transportedCThe transported database must have the same database identifier （DBID） as the”相关问题

  • 第1题：

    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

  • 第2题：

    You want to flash back a test database by five hours.You issue this command:SQL > FLASHBACK DATABASE TO TIMESTAMP (SYSDATE － 5／24);Which two statements are true about this flashback scenario?()

    A. The database must have multiplexed redo logs for the flashback to succeed.

    B. The database must be MOUNTED for the flashback to succeed.

    C. The database must use block change tracking for the flashback to succeed.

    D. The database must be opened in restricted mode for the flashback to succeed.

    E. The database must be opened with the RESETLOGS option after the flashback is complete.

    F. The database must be opened in read-only mode to check if the database has been flashed back to the correct SCN.


    参考答案：E, F

  • 第3题：

    Which three statements must be true before transporting a tablespace from a database on one platform to a database on another platform?（）

    • A、Both source and target database must be the same character set
    • B、Both source and target database must have the same endian format
    • C、The COMPATIBLE parameter must be the same in the source and target databases.
    • D、The minimum compatibility level for both the source and target database must be 10.0.0.
    • E、All read-only and offline data files that belong to the tablespace to be transported must be platform aware.

    正确答案:A,B,D

  • 第4题：

    Which two statements are correct about database transportation? （）

    • A、The source and target platforms must be the same
    • B、Redo logs, control files and temp files are also transported
    • C、The transported database must have the same database identifier (DBID) as the source database and cannot be changed
    • D、The COMPATIBLE parameter must be set to 10.0.0.0 or higher and the database must be opened in readonly mode before being transported
    • E、Recovery Manager (RMAN) is used to convert the necessary data files of the database if the target platform is different and has different endian format

    正确答案:D,E

  • 第5题：

    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

  • 第6题：

    多选题
    You plan to execute the following command to perform a Flashback Database operation in your database：   SQL> FLASHBACK DATABASE TO TIMESTAMP （SYSDATE -5/24）；   Which two statements are true about this？（）
    A

    The database must have multiplexed redo log files

    B

    The database must be in the MOUNT state to execute the command

    C

    The database must be in the NOMOUNT state to execute the command

    D

    The database must be opened in RESTRICTED mode before this operation

    E

    The database must be opened with the RESETLOGS option after the flashback operation


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

  • 第7题：

    多选题
    Which two statements are correct about database transportation?（） (Choose two.)
    A

    The source and target platforms must be the same

    B

    Redo logs, control files and temp files are also transported

    C

    The transported database must have the same database identifier (DBID) as the source database and cannot be changed

    D

    The COMPATIBLE parameter must be set to 10.0.0.0 or higher and the database must be opened in readonly mode before being transported

    E

    Recovery Manager (RMAN) is used to convert the necessary data files of the database if the target platform is different and has different endian format


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

  • 第8题：

    多选题
    What are the prerequisites for enabling Flashback Database？ （）
    A

    The database must be started in the MOUNT EXCLUSIVE state.

    B

    The database must have multiplexed control files.

    C

    The database must be opened by using a text-based parameter file instead of a server parameter file （SPFILE）.

    D

    The database must be in ARCHIVELOG mode.

    E

    The database must be in the NOMOUNT state.

    F

    The database must be opened in RESTRICTED mode.


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

  • 第9题：

    多选题
    Examine the following impdp command to import a database over the network from a pre-12c Oracledatabase (source): Which three are prerequisites for successful execution of the command?（）
    A

    The import operation must be performed by a user on the target database with the DATAPUMP_IMP_FULL_DATABASE role, and the database link must connect to a user on the source database with the DATAPUMP_EXD_FULL_DATABASE role.

    B

    All the user-defined tablespaces must be in read-only mode on the source database.

    C

    The export dump file must be created before starting the import on the target database.

    D

    The source and target database must be running on the same platform with the same endianness.

    E

    The path of data files on the target database must be the same as that on the source database.

    F

    The impdp operation must be performed by the same user that performed the expdp operation.


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

  • 第10题：

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


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

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


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

  • 第13题：

    Which three statements must be true before transporting a tablespace from a database on one platform to a database on another platform?() (Choose three.)

    A. Both source and target database must be the same character set

    B. Both source and target database must have the same endian format

    C. The COMPATIBLE parameter must be the same in the source and target databases.

    D. The minimum compatibility level for both the source and target database must be 10.0.0.

    E. All read-only and offline data files that belong to the tablespace to be transported must be platform aware.


    参考答案：A, B, D

  • 第14题：

    Examine the following impdp command to import a database over the network from a pre－12c Oracledatabase (source): Which three are prerequisites for successful execution of the command?()

    A. The import operation must be performed by a user on the target database with the DATAPUMP_IMP_FULL_DATABASE role, and the database link must connect to a user on the source database with the DATAPUMP_EXD_FULL_DATABASE role.

    B. All the user-defined tablespaces must be in read-only mode on the source database.

    C. The export dump file must be created before starting the import on the target database.

    D. The source and target database must be running on the same platform with the same endianness.

    E. The path of data files on the target database must be the same as that on the source database.

    F. The impdp operation must be performed by the same user that performed the expdp operation.


    参考答案：B, C, 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题：

    Which three statements must be true before transporting a tablespace from a database on one platform to a database on another platform?（） (Choose three.)

    • A、Both source and target database must be the same character set
    • B、Both source and target database must have the same endian format
    • C、The COMPATIBLE parameter must be the same in the source and target databases.
    • D、The minimum compatibility level for both the source and target database must be 10.0.0.
    • E、All read-only and offline data files that belong to the tablespace to be transported must be platform aware.

    正确答案:A,B,D

  • 第17题：

    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

  • 第18题：

    多选题
    Which two statements are correct about database transportation? （）
    A

    The source and target platforms must be the same

    B

    Redo logs, control files and temp files are also transported

    C

    The transported database must have the same database identifier (DBID) as the source database and cannot be changed

    D

    The COMPATIBLE parameter must be set to 10.0.0.0 or higher and the database must be opened in readonly mode before being transported

    E

    Recovery Manager (RMAN) is used to convert the necessary data files of the database if the target platform is different and has different endian format


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

  • 第19题：

    多选题
    Which three statements must be true before transporting a tablespace from a database on one platform to a database on another platform?（）
    A

    Both source and target database must be the same character set

    B

    Both source and target database must have the same endian format

    C

    The COMPATIBLE parameter must be the same in the source and target databases.

    D

    The minimum compatibility level for both the source and target database must be 10.0.0.

    E

    All read-only and offline data files that belong to the tablespace to be transported must be platform aware.


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

  • 第20题：

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


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

  • 第21题：

    多选题
    Examine the following command that is used to duplicate a database on the same host: 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


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

  • 第22题：

    多选题
    Your database is configured in NOARCHIVELOG mode. All the control files have been lost due to a hard disk failure but the data files are not lost. You have the closed whole database backup available to you. Which two statements are true in this scenario？（）
    A

    The instance aborts.

    B

    The database cannot be recovered.

    C

    The database can be recovered by restoring the control files from the backup.

    D

    The database remains opened and you have to shut it down with the ABORT option.

    E

    The database can be restored till the point of the last closed whole database backup.


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

  • 第23题：

    多选题
    Which three statements must be true before transporting a tablespace from a database on one platform to a database on another platform?（） (Choose three.)
    A

    Both source and target database must be the same character set

    B

    Both source and target database must have the same endian format

    C

    The COMPATIBLE parameter must be the same in the source and target databases.

    D

    The minimum compatibility level for both the source and target database must be 10.0.0.

    E

    All read-only and offline data files that belong to the tablespace to be transported must be platform aware.


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

  • 第24题：

    多选题
    You want to flash back a test database by five hours.You issue this command:SQL > FLASHBACK DATABASE TO TIMESTAMP (SYSDATE - 5/24);Which two statements are true about this flashback scenario?（）
    A

    The database must have multiplexed redo logs for the flashback to succeed.

    B

    The database must be MOUNTED for the flashback to succeed.

    C

    The database must use block change tracking for the flashback to succeed.

    D

    The database must be opened in restricted mode for the flashback to succeed.

    E

    The database must be opened with the RESETLOGS option after the flashback is complete.

    F

    The database must be opened in read-only mode to check if the database has been flashed back to the correct SCN.


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

相关内容