Exam 1z0-160 topic 1 question 64 discussion

Actual exam question from Oracle's 1z0-160

Question #: 64
Topic #: 1

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 the ENCRYPTION_PASSWORD parameter.
D. You can use Data Pump TTS with the ENCRYPTED_PASSWORD parameter.
E. Data is sent in clear when the NETWORK_LINK option is used.

Show Suggested Answer

Suggested Answer: AC 🗳️
The Data Pump Transportable Tablespace method 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.
References:
https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/mig-11g-11g.html

by thuthuysphn58 at April 4, 2025, 12:35 p.m.

Comments

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!