DATABASE MIGRATION 2

What are the constraints of using transportable tablespaces? (Choose two.)

• The source and target database versions must match.
• The source and target time zone versions must match.
• The source and target platforms must match.
• The source and target character sets must match.

Which TWO methods are supported by Oracle Zero Downtime Migration (ZDM) for migrating onpremises databases to Autonomous Database? (Choose all correct answers)

• Logical online or offline migration using a database link
• Logical online or offline migration using OCI Object Storage
• Physical online or offline migration using OCI Object Storage
• Physical online or offline migration using a database link

For a source database to be successfully migrated, you must view and apply the prerequisites. Which TWO prerequisites must pass before the source database can be migrated using Oracle Zero Downtime Migration (ZDM)? (Choose all correct answers)

• The database must be stored in an Automatic Storage Management Cluster File System (ACFS).
• Archivelog must be enabled
• The database must have a configured TDE wallet if the version is Oracle Database 11g Release 2 or 12c Release 1
• The database must have Transparent Data Encryption (TDE) enabled.
• . Port 22 on the source database server must allow incoming connections from the ZDM service host

Which knowledge modules are supported by Oracle Data Integrator (ODI)?

• IDB DB2
• All of the options
• Spark
• Hive
• ADW

Which statement is true?

• One PDB consists of only one CDB
• One CDB can have only one PDB
• One PDB consists of multiple CDBs
• One CDB can have one or more PDBs

Which type of checks is NOT supported by Oracle Data Integrator (ODI)?

• conditions
• keys
• references
• mandatory attributes
• business rule

You are using Data Pump to migrate your database to Autonomous Database (ADB). To which tablespace must you remap your source database tablespaces?

• USERS
• UNDO
• SYSTEM
• DATA

Which three backup mediums are supported when migrating a database with oracle zero downtime migration?. (Choose all correct answers)

• Oracle Cloud Infrastructure Object Storage
• Third-Party Cloud Storage
• Oracle Zero data loss recovery appliance
• NFS Storage
• Tape Storage

Which TWO statements are true about online pluggable database (PDB) relocation? (Choose all correct answers)

• Database version downgrade can be achieved with PDB relocation.
• A PDB with the ASCII character set can be relocated to a container database (CDB) with the AL32UTF8 character set
• PDB relocation with no version change can be performed with near-zero downtime
• Online PDB relocation can achieve a zero downtime upgrade

You have executed the mappings with Change Data Capture ( CDC ) on the source data store and you are now going through the code in the operator log for debugging. Which two tables or view do you need to inspect in the database to see whether the CDC process is writing changed data or not in Oracle Data Integration ( ODI )? (Choose all correct answers)

• JV$D view
• J$ table
• JV$ view
• JW$ view