Is this exam completely free?

ExamCademy offers a free preview for every exam, covering around 20% of the total questions. Full access to all questions is available for free by signing up for an account. Optional supporters unlock AstroTutor (AI tutor) and advanced study modes.

Can I practice IT certification exams from Microsoft, AWS, or CompTIA?

Yes! ExamCademy supports a wide range of IT certification exams including Microsoft Azure, AWS Cloud Practitioner, and CompTIA A+ and Security+.

How accurate are the mock exams?

Our practice questions are community-created and moderator-reviewed to align with realistic exam objectives, style, and difficulty.

1Z0-1094-23 by Oracle - Page 1 | ExamCademy

Mode Selection

Sort:

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Question 7

That's the end of the Preview

Create a free account to unlock all questions for this exam.

Log In / Sign Up

Page 1 of 2 • Questions 1-25 of 35

1 2

→

Know a question that should be here? Contribute to this exam

Which two products/utilities does Oracle Zero Downtime Migration (ZDM) use as part of its migration workflows to Autonomous Database? (Choose two.)

A GoldenGate
B Data Guard
C Data Pump
D Recovery Manager

When preparing for a migration using RMAN DUPLICATE from an active database, which two actions do you need to take if the on-premises database (DB) is Transparent Data Encryption (TDE) encrypted?

A Perform an RMAN backup of the on-premises DB to OCI Cloud Storage.
B Make sure that the SYS user password is identical on both systems.
C Copy the encryption wallet from the on-premises DB to the Cloud DB System.
D Use the dbcli dbstorage command to identify the DATA, RECO, and REDO locations.

You are using Oracle Data Integrator (ODI).
Which three topology elements are required to extract data out of Fusion SaaS applications and load it into Autonomous Data Warehouse (ADW)? (Choose three.)

A Object Storage
B In-Memory Engine
C BI Cloud Connector
D Oracle (ADW)
E File

You are asked to isolate all the erroneous rows into error tables before they get into the target tables, in order to have a list of corrections that need to be addressed before the next run.
At the next run, the demand is to check whether there are some rows that have been fixed and automatically include them in the integration flow.
Which two conditions need to be met to accomplish this demand in Oracle Data Integrator (ODI)? (Choose two.)

A You must have an update key on the target table.
B The Check Knowledge Module must have the RECYCLE_ERRORS option set to TRUE.
C The static control has to be enabled and the RECYCLE_ERRORS option set to TRUE.
D The flow control has to be enabled and the RECYCLE_ERRORS option set to TRUE.
E You must have a primary key on the target table.

Which two prerequisites are required to install Oracle Zero Downtime Migration (ZDM) software? (Choose two.)

A Oracle Grid Infrastructure installed on the ZDM service host
B 100 GB of free storage space
C 8 GB of RAM
D Installation of the "glibc-devel" and "expect" packages
E 50 GB of free storage space

Which source database configuration does NOT influence your database migration options to Oracle Cloud Infrastructure (OCI)?

A Character set
B Database version
C Tablespaces
D Database size
E Endian format

When integrating data from multiple sources into 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 TRUE 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 The Check Knowledge Module was not set in the physical design.
B There were no rows compliant with the imposed constraint.
C The integration type was not set in the logical design.
D A primary key was not defined on the target table.