违法和不良信息举报 联系客服
免费注册 登录

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

第2题：

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

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

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

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

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 open

B. The target database should be in ARCHIVELOG mode if it is open

C. RMAN should be connected to both the instances as SYSDBA

D. The target database backups should be copied to the source database backup directories

E. The password file must exist for the source database and have the same SYS user password as the target


参考答案：B, C, E

第7题：

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

第8题：

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

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

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

更多相关问题
相关内容