Oracle 1Z0-1094-22 Online Practice Questions and Exam Preparation

Oracle 1Z0-1094-22 Online Questions & Answers

• Question 41:

  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)

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

• Question 42:

  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
  A. NOMOUNT

• Question 43:

  Oracle Zero Downtime Migration (ZDM) uses MySQL internally, configuring on a default port number. What will ZDM proceed to, if a port number is not specified and the default is not available?

  A. Assign a random port number.
  B. Increase the default port number by one and retry five times.
  C. Request a valid port number
  D. Exit the installation with an error message.
  B. Increase the default port number by one and retry five times.

• Question 44:

  Which TWO provisions are required for Oracle Zero Downtime Migration (ZDM) to perform a database migration successfully with the physical workflow? (Choose all correct answers)

  A. Jmx connections to be accepted frommultiple hosts
  B. Root user or SSH key-based access to target database server
  C. Root user or SSH key-based access to source database server
  D. ZDM_BASE group access enabled
  B. Root user or SSH key-based access to target database server
  D. ZDM_BASE group access enabled

• Question 45:

  You are trying to load a denormalized target table C and the source attributes come from table A and Table B inOracle Data Integrator (ODI). Which statement is true?

  A. A mapping can have only one source and one target. You need to create 2 mappings to load target C.
  B. You can join table A and table B, as required by the data model and load target C in a Single mapping
  C. You are required to do inner join between table A and table B in order to load target C.
  D. You are required to do outer join between table A and table B in order to load target C.
  B. You can join table A and table B, as required by the data model and load target C in a Single mapping

• Question 46:

  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)

  A. JV$D view
  B. J$ table
  C. JV$ view
  D. JW$ view
  A. JV$D view
  C. JV$ view

• Question 47:

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

  A. conditions
  B. keys
  C. references
  D. mandatory attributes
  E. business rule
  E. business rule

• Question 48:

  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.
  C. PDB relocation with no version change can be performed with near-zero downtime.
  D. Online PDB relocation can achieve a zero downtime upgrade.

• Question 49:

  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"
  A. "-tgtroot"
  B. "-tdemasterkey"
  C. "-sourceid"
  F. "-sourcedb"

• Question 50:

  Which of these provide Active Replication? (Choose two.)

  A. Flashback
  B. Active Data Guard
  C. Sharding
  D. GoldenGate
  B. Active Data Guard
  D. GoldenGate