网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
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.
参考答案
更多 “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.” 相关考题
考题
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.
考题
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 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
考题
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
考题
You need to replicate a table from a master to a slave. The master and slave copies of the table will have different number of columns.Which two conditions must be true?()
A.Each extra column in the copy with more columns must not have a default valueB.Columns that are common to both versions of the table must be defined in the same order on the master and the slaveC.The slave database cannot have more columns than the master. Only the master database can have more columnsD.Columns that are common to both versions of the table must come first in the table definition, before any additional columns are additional columns are defined on either serverE.The master database cannot have more columns than the slave. Only the slave deatbase can have more columns
考题
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
考题
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 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.
考题
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.
考题
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.
考题
You need to replicate a table from a master to a slave. The master and slave copies of the table will have different number of columns. Which two conditions must be true?（）A、Each extra column in the copy with more columns must not have a default valueB、Columns that are common to both versions of the table must be defined in the same order on the master and the slaveC、The slave database cannot have more columns than the master. Only the master database can have more columnsD、Columns that are common to both versions of the table must come first in the table definition, before any additional columns are additional columns are defined on either serverE、The master database cannot have more columns than the slave. Only the slave deatbase can have more columns
考题
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.
考题
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
考题
You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process，you execute the following script： SQL@utlu111i.sql Which statement about the execution of this script is true？（）A、 It must be executed from the Oracle Database 11g environment.B、 It must be executed only after the SYSAUX tablespace has been created.C、 It must be executed from the environment of the database that is being upgraded.D、 It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.E、 It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.
考题
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.
考题
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.
考题
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
考题
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 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.
考题
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.
考题
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 databaseB、 The list of target platforms requiring endian conversionC、 The list of target platforms that will not require endian conversionD、 The list of all target platforms that can receive transportable tablespaces from the source databaseE、 None of the above
考题
多选题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?（）AThe source database backup must be copied over the net for test database.BThe source database must be run in ARCHIVELOG mode if the database is open.CThe source database must be shut down cleanly if the database is in mounted state.DA net service name should be set up and a listener configured with the target as well as the source database.
考题
多选题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 endian formatCThe COMPATIBLE parameter must be the same in the source and target databases.DThe minimum compatibility level for both the source and target database must be 10.0.0.EAll read-only and offline data files that belong to the tablespace to be transported must be platform aware.
考题
多选题Which three statements are true concerning unplugging a pluggable database (PDB)?（）AThe PDB must be open in read only mode.BThe PDB must be dosed.CThe unplugged PDB becomes a non-cdb.DThe unplugged PDB can be plugged into the same multitenant container database (CDB)EThe unplugged PDB can be plugged into another cdb.FThe PDB data files are automatically removed from disk.
考题
多选题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）；AThe list of target platforms having the same endian format as the source databaseBThe list of target platforms requiring endian conversionCThe list of target platforms that will not require endian conversionDThe list of all target platforms that can receive transportable tablespaces from the source databaseENone of the above
考题
多选题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?（）AThe 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.BAll the user-defined tablespaces must be in read-only mode on the source database.CThe export dump file must be created before starting the import on the target database.DThe source and target database must be running on the same platform with the same endianness.EThe path of data files on the target database must be the same as that on the source database.FThe impdp operation must be performed by the same user that performed the expdp operation.
考题
多选题Which of the following restrictions are not true with respect to tablespace point-in-time recovery？（）AThe target database must be in NOARCHIVELOG mode.BNo backup is required of the database before you perform a TSPITR.CYou must have all archived redo logs generated since the last backup up to the point to which you want to restore the transport set.DIf you rename a tablespace， you can not perform a TSPITR to any point in time before that rename operation occurred.EIf you have tables in tablespace_1 that have associated constraints in tablespace_2，then you must transport both tablespaces.
考题
单选题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.
考题
多选题Which three statements must be true before transporting a tablespace from a database on one platform to a database on another platform?（） (Choose three.)ABoth source and target database must be the same character setBBoth source and target database must have the same endian formatCThe COMPATIBLE parameter must be the same in the source and target databases.DThe minimum compatibility level for both the source and target database must be 10.0.0.EAll read-only and offline data files that belong to the tablespace to be transported must be platform aware.
热门标签
最新试卷
