You have an Oracle Database 11g on-premises database with encrypted tablespaces.
You want to migrate this database to the pre-created database of the Database as a
Service (DBaaS) instance on Oracle Cloud.
Which two statements are true about this migration?
A.
The on-premises database platform must be of the same endianness as the DBaaS
platform.
B.
You can use Full Transportable (TDB).
C.
You can use Data Pump TTS with theENCRYPTION_PASSWORDparameter.
D.
You can use Data Pump TTS with theENCRYPTED_PASSWORDparameter.
E.
Data issent in clear when theNETWORK_LINKoption is used.
Explanation:
TheData Pump Transportable Tablespacemethod can be used only if the on-premises
platform is little endian, and the database character sets of your on-premises database and
Oracle Database Cloud Service database are compatible.
Note: If the job you are attaching to was initially started using an encryption password, then
when you attach to the job you must again enter the ENCRYPTION_PASSWORD
parameter on the command line to re-specify that password. The only exception to this is if
the job was initially started with the ENCRYPTION=ENCRYPTED_COLUMNS_ONLY
parameter. In that case, the encryption password is not needed when attaching to the job.
https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/mig-11g-
11g.html
A,C
A,C
A, C
https://docs.oracle.com/cd/E11882_01/network.112/e40393/asotrans.htm#ASOAG600
From student guide
To transport an encrypted tablespace to a platform with the same endianness, set the ENCRYPTION_PWD_PROMPT export utility
parameter to YES or use the ENCRYPTION_PASSWORD export utility parameter. During import, use the equivalent import utility
parameter and set the value to the same password that was used for the export. Transport the wallet along with the data pump
file.
A,C