Oracle Database Cloud Service 1Z0-1094-22 Questions & Answers

• Question 31:

  You have a requirement to join data from an Oracle database table and a flat file and load into target DB2 table, using Oracle Data Integrator (ODI). Which statement is correct about this?

  A. Heterogeneous sources and targets are possible in a single mapping only if there is no incremental data load.

  B. Flat file data has to have a header row in order to join with Oracle database table ina single mapping

  C. It is not possible to join data from different source connection types in a Single mapping

  D. It is possible to mix heterogeneous source connection type and load into any supported target connection type in a single mapping.

  E. It is possible to join data from different source connection types in mapping, but the result must be loaded to Oracle.

  Correct Answer: D

• Question 32:

  Which TWO methods should you use when migrating a target database with different endianness than the source database? (Choose all correct answers)

  A. RMAN DUPLICATE

  B. RMAN Transportable Tablespaces with Data Pump

  C. RMAN CONVERT D. RMAN RESTORE from target

  Correct Answer: BD

• Question 33:

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

  A. Database version downgrade can be achieved with PDB relocation.

  B. A PDB with the ASCII character set can be relocated to a container database (CDB) with the AL32UTF8 character set.

  C. PDB relocation with no version change can be performed with near-zero downtime.

  D. Online PDB relocation can achieve a zero downtime upgrade.

  Correct Answer: CD

• Question 34:

  You run a database instance on Oracle Database 11.2 and you want tomigrate to Oracle Cloud. In which case is it required to upgrade your source database before migrating to the cloud?

  A. if you are using virtual machines

  B. if you are using Recovery Manager (RMAN)

  C. if your target is Exadata Cloud Service

  D. if you are using unplug/plug

  Correct Answer: C

• Question 35:

  Which view is used to measure the replication latency between source and target when using the automatic heartbeat table feature, in GoldenGate?

  A. gg_lag

  B. goldengate_lag

  C. ogg_latency

  D. Lag_view

  Correct Answer: A

• Question 36:

  In which mode must the auxiliary instance be started while using the RMAN DUPLICATE command for database migration?

  A. NOMOUNT

  B. OPEN

  C. FORCE

  D. MOUNT

  Correct Answer: A

• Question 37:

  Which TWO products/utilities does Oracle Zero Downtime Migration use as part of its migration workflows to Autonomous Database? (Choose all correct answers)

  A. Data Pump

  B. Data Guard

  C. GoldenGate

  D. Recovery Manager

  Correct Answer: AC

• Question 38:

  In Oracle Zero Downtime Migration, the migrate database command provides several options to ensure a successful Oracle source and target data migration. Which FOUR are valid parameters to use with migrate database? (Choose all correct answers)

  A. "-tgtroot"

  B. "-tdemasterkey"

  C. "-sourceid"

  D. "-dbversion"

  E. "-dbpatchievel"

  F. "-sourcedb"

  Correct Answer: ABCF

• Question 39:

  Which statements are true for Zero Downtime Migration? (Choose two.)

  A. It is a complex process that requires you to raise an SR with Oracle Support.

  B. It ensures zero data loss.

  C. It is free.

  D. It does not leverage Oracle MAA best practices.

  Correct Answer: BC

• Question 40:

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

  A. Oracle Cloud Infrastructure Object Storage

  B. Third-Party Cloud Storage

  C. Oracle Zero data loss recovery appliance

  D. NFS Storage

  E. Tape Storage

  Correct Answer: ACD