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

Oracle 1Z0-1094-22 Online Questions & Answers

• Question 21:

  Which three Oracle technologies are leveraged by Oracle Zero Downtime Migration Physical Online Workflow? (Choose all correct answers)

  A. Oracle DataGuard
  B. Recovery Manager
  C. SQL*Net
  D. Oracle Real Application Testing
  E. Streams
  A. Oracle DataGuard
  B. Recovery Manager
  C. SQL*Net

• Question 22:

  Which THREE methods can be used to migrate an on-premises Oracle Database to Oracle Autonomous Database? (Choose all correct answers)

  A. Data Pump Export/lmport
  B. EnterpriseManager
  C. Oracle Zero Downtime Migration
  D. Data Guard
  E. PDB Unplugging/Plugging
  A. Data Pump Export/lmport
  B. EnterpriseManager
  C. Oracle Zero Downtime Migration

• Question 23:

  Which statements aretrue for OCI GoldenGate Service? (Choose two.)

  A. It requires any source environment to run Oracle GoldenGate Microservices.
  B. It is customer-managed.
  C. It requires an on-premises license for the Oracle GoldenGate software.
  D. It supports the usage of Universal Credits.
  A. It requires any source environment to run Oracle GoldenGate Microservices.
  D. It supports the usage of Universal Credits.

• Question 24:

  When selecting a migration method for movingyour database to the cloud, what would you NOT take into consideration?

  A. Database Version
  B. High Availability
  C. Schema Name
  D. Database Size
  C. Schema Name

• Question 25:

  Your data warehouse load consists of extracting data from order header and order line items table. what kind of journalizing type should you use in Oracle Data Integration ( ODI ) to make sure referential integrity is maintained in the target?

  A. Consistent
  B. Application Base
  C. Complex
  D. Simple
  A. Consistent

• Question 26:

  Which are THREE target database prerequisites for database cloud migration with Oracle Zero Downtime Migration? (Choose all correct answers)

  A. Transparent Data Encryption (TDE) must be enabled.
  B. The database can be created only after migration has begun.
  C. The database db_name should be the same as the source database.
  D. The TDE wallet status must be open.
  E. The TDE wallet status must be closed.
  A. Transparent Data Encryption (TDE) must be enabled.
  C. The database db_name should be the same as the source database.
  D. The TDE wallet status must be open.

• Question 27:

  In order to migrate an active database using RMAN DUPLICATE, what information do you need for the source database? (Choose two.)

  A. Location of audit files
  B. Listener port
  C. Value of the UNDO_RETENTION parameter
  D. Database unique name
  E. Password for HR schema
  B. Listener port
  D. Database unique name

• Question 28:

  When integrating data from multiple sourcesinto a Data Warehouse schema, you want to check a length constraint that you have imposed on one of the target columns before the rows arrive in the target table. All the rows that do not pass this quality check will have to be isolated in error tables. For this, you have chosen an Integration Knowledge Module (IKM) that supports flow control. You have also chosen the value raue for this parameter to enable this check. At compile time, you see that Oracle Data Integrator (ODI) throws an error and the execution cannot start. What is the reason?

  A. Primary key was not defined on the target table.
  B. The Check Knowledge Module was not set in the physical design.
  C. The integration type was not set in the logical design.
  D. There were no rows compliant with imposed constraint.
  B. The Check Knowledge Module was not set in the physical design.

• Question 29:

  Which supported platform can the source Oracle Database be running on when migrating with Oracle Zero Downtime Migration?

  A. aix
  B. windows
  C. Linux x86-64
  D. Solaris
  C. Linux x86-64

• Question 30:

  Which TWO methods support a difference in endian format whenmigrating a database from onpremises to Oracle Cloud? (Choose all correct answers)

  A. PDB Unplugging/Plugging
  B. Data Pump Conventional Export/lmport
  C. RMAN cross-Platform Transportable PDB
  D. PDB Remote Cloning
  B. Data Pump Conventional Export/lmport
  C. RMAN cross-Platform Transportable PDB