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

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

如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

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

第2题:

How would you grant the RVPC user access to specific RMAN database records in the RMAN virtual private catalog?()  

  • A、 Issue the grant command from the SYS user (or equivalent) of the target database.
  • B、 Issue the grant command from the SYS user (or equivalent) of the recovery-catalog database.
  • C、 Issue the grant command from the recovery catalog-owning schema user account in the recovery catalog.
  • D、 Issue the grant command from RMAN when connected to the recovery catalog-owning schema.
  • E、 Issue the grant command from RMAN when connected to the target database.

正确答案:D

第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 of the following roles must be granted to a user to perform a full database import?()

  • A、CONNECT
  • B、IMP_FULL_DATABASE
  • C、FULL_EXPORT_PRIVS
  • D、RESOURCE
  • E、FULL_IMPORT_PRIVS

正确答案:B

第5题:

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.

正确答案:C,D

第6题:

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

第7题:

You have created a database link, devdb.us.oracle.com, between the databases PRODDB and DEVDB. You want to import schema objects of the HR user using Oracle Data Pump from thedevelopment database, DEVDB, to the production database, PRODDB. You execute the following command on the target database server:  $impdp system/manager directory = DB_DATA dumpfile = schemas.dat schemas = hr  flashback_time = 2004-02-03 09:00  The command fails, displaying the following error: ORA-39001: invalid argument value  ORA-39000: bad dump file specification  ORA-31640: unable to open dump file “/home/oracle/schema/schemas.dat” for read ORA-27037: unable to obtain file status What would you do to overcome the error()

  • A、remove the dumpfile option in the command
  • B、remove the flashback_time option in the command
  • C、remove the dumpfile option and add the network_link = devdb.us.oracle.com option in the command(Replace thedumpfile option with the network_link = devdb.us.oracle.com)
  • D、add the user, SYSTEM, to the schemas option in the command
  • E、remove the schemas option and add the network_link = devdb.us.oracle.com option in the command 
  • F、add network_link = devdb.us.oracle.com option in the command

正确答案:C

第8题:

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

第9题:

You executed the following command in Recovery Manager (RMAN):  RMAN> RESTORE CONTROLFILE;  Which operation must you perform before this command is executed?() 

  • A、back up the control file to trace
  • B、bring database to the MOUNT state
  • C、open a connection to the RMAN recovery catalog, which contains the RMAN metadata for the target database
  • D、set the database ID (DBID), but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog

正确答案:C

第10题:

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

更多相关问题