多选题Which three statements must be true before transporting a tablespace from a database on one platform to a database on another platform?（）ABoth source and target database must be the same character setBBoth source and target database must have the same

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

相似考题

1.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 setB. Both source and target database must have the same endian formatC. 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.

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

3.You are managing the APPPROD database as a DBA. You plan to duplicate this database in the same system with the name DUPDB.You issued the following RMAN commands to create a duplicate database:Which three are the prerequisites for the successful execution of the above command?（）A. The source database should be openB. The target database should be in ARCHIVELOG mode if it is openC. RMAN should be connected to both the instances as SYSDBAD. The target database backups should be copied to the source database backup directoriesE. The password file must exist for the source database and have the same SYS user password as the target

4.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 filesB. The database must be in the MOUNT state to execute the commandC. The database must be in the NOMOUNT state to execute the commandD. The database must be opened in RESTRICTED mode before this operationE. The database must be opened with the RESETLOGS option after the flashback operation

更多“多选题Which three statements must be true before transporting a tablespace from a database on one platform to a database on another platform?（）ABoth source and target database must be the same character setBBoth source and target database must have the same ”相关问题

  • 第1题：

    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


    参考答案：D, E

  • 第2题：

    Which three statements are true concerning unplugging a pluggable database (PDB)?()

    A. The PDB must be open in read only mode.

    B. The PDB must be dosed.

    C. The unplugged PDB becomes a non-cdb.

    D. The unplugged PDB can be plugged into the same multitenant container database (CDB)

    E. The unplugged PDB can be plugged into another cdb.

    F. The PDB data files are automatically removed from disk.


    参考答案：B, D, E

  • 第3题：

    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.

    正确答案:B,C,D

  • 第4题：

    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

  • 第5题：

    Which three statements are true concerning unplugging a pluggable database (PDB)?（）

    • A、The PDB must be open in read only mode.
    • B、The PDB must be dosed.
    • C、The unplugged PDB becomes a non-cdb.
    • D、The unplugged PDB can be plugged into the same multitenant container database (CDB)
    • E、The unplugged PDB can be plugged into another cdb.
    • F、The PDB data files are automatically removed from disk.

    正确答案:B,D,E

  • 第6题：

    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

  • 第7题：

    The following query will provide what information about transportable tablespaces for the current database？（） select d.platform_name "Source"， t.platform_name  "Compatible Targets"， endian_format  from v$transportable_platform t， v$database d  where t.endian_format = （select endian_format  from v$transportable_platform t， v$database d  where d.platform_name = platform_name）；  

    • A、 The list of target platforms having the same endian format as the source database
    • B、 The list of target platforms requiring endian conversion
    • C、 The list of target platforms that will not require endian conversion
    • D、 The list of all target platforms that can receive transportable tablespaces from the source database
    • E、 None of the above

    正确答案:A,C

  • 第8题：

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

  • 第9题：

    多选题
    Which three statements are true concerning unplugging a pluggable database (PDB)?（）
    A

    The PDB must be open in read only mode.

    B

    The PDB must be dosed.

    C

    The unplugged PDB becomes a non-cdb.

    D

    The unplugged PDB can be plugged into the same multitenant container database (CDB)

    E

    The unplugged PDB can be plugged into another cdb.

    F

    The PDB data files are automatically removed from disk.


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

  • 第10题：

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

  • 第11题：

    单选题
    Examine this statement：  RMAN >BACKUP FORMAT ’/BACKUP/df_%d_%s_%p.bus1 DATABASE filesperset = 2；  What state must the target database be in for you to use this RMAN command？（）
    A

    The target database must be open.

    B

    The target database must be closed.

    C

    The target database must be mounted.

    D

    The target database must be mounted or open.


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

  • 第12题：

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

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

    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,E

  • 第16题：

    Which of the following restrictions are not true with respect to tablespace point-in-time recovery？（）

    • A、 The target database must be in NOARCHIVELOG mode.
    • B、 No backup is required of the database before you perform a TSPITR.
    • C、 You must have all archived redo logs generated since the last backup up to the point to which you want to restore the transport set.
    • D、 If you rename a tablespace， you can not perform a TSPITR to any point in time before that rename operation occurred.
    • E、 If you have tables in tablespace_1 that have associated constraints in tablespace_2，then you must transport both tablespaces.

    正确答案:A,B

  • 第17题：

    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

  • 第18题：

    Examine this statement：  RMAN >BACKUP FORMAT ’/BACKUP/df_%d_%s_%p.bus1 DATABASE filesperset = 2；  What state must the target database be in for you to use this RMAN command？（）

    • A、The target database must be open.
    • B、The target database must be closed.
    • C、The target database must be mounted.
    • D、The target database must be mounted or open.

    正确答案:D

  • 第19题：

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

  • 第20题：

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


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

  • 第21题：

    多选题
    The following query will provide what information about transportable tablespaces for the current database？（） select d.platform_name "Source"， t.platform_name  "Compatible Targets"， endian_format  from v$transportable_platform t， v$database d  where t.endian_format = （select endian_format  from v$transportable_platform t， v$database d  where d.platform_name = platform_name）；
    A

    The list of target platforms having the same endian format as the source database

    B

    The list of target platforms requiring endian conversion

    C

    The list of target platforms that will not require endian conversion

    D

    The list of all target platforms that can receive transportable tablespaces from the source database

    E

    None of the above


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

  • 第22题：

    多选题
    Which of the following restrictions are not true with respect to tablespace point-in-time recovery？（）
    A

    The target database must be in NOARCHIVELOG mode.

    B

    No backup is required of the database before you perform a TSPITR.

    C

    You must have all archived redo logs generated since the last backup up to the point to which you want to restore the transport set.

    D

    If you rename a tablespace， you can not perform a TSPITR to any point in time before that rename operation occurred.

    E

    If you have tables in tablespace_1 that have associated constraints in tablespace_2，then you must transport both tablespaces.


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

  • 第23题：

    多选题
    You are working on an Oracle Database 10g database. Because of data loss， you decided to perform a Flashback Database operation using the following command：  SQL> FLASHBACK DATABASE TO TIMESTAMP（SYSDATE ？5/24）； Which two statements are true？ （）
    A

    SYSDATE should not be used with TIMESTAMP.

    B

    The database must have multiplexed redo log files.

    C

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

    D

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

    E

    The entire database needs to be restored from the most recent backup before the flashback operation.


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

相关内容