1Z0-1094-22 Online Practice Questions and Answers

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

A. IDB DB2

B. All of the options

C. Spark

D. Hive

E. ADW

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

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

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"

If unplug and plug was decided to be used as the tool for the migration to Oracle Cloud Infrastructure(OCD), which two constraints are part of this migration to process for using unplug and plug? (Choose all correct answers)

A. Target must be an Autonomous database.

B. Target and source have same Endianness.

C. Source must be Little-endian.

D. Source andtarget need to be container database (CDB).

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

Which tools can be used to perform Oracle Zero Downtime logical migration? (Choose two.)

A. Oracle GoldenGate

B. RMAN

C. Data Guard

D. Data Pump

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.

What TWO ways does Data Pump use to move data to the cloud? (Choose all correct answers)

A. RMAN Backup and Restore

B. pdb unplug/plug

C. import over Oracle Database database link

D. import dump file from OCI Object Storage

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.

Planning a database migration to Oracle Cloud Infrastructure (OCI) requires understanding the source?

A. users and groups to be migrated

B. on-premises host operating system

C. character set of databases

D. number of tables

When building out your private subnet, you realize you need a host within your network in order to get access to the rest of your Oracle Cloud Infrastructure instances. Which type of host should you set up to get around this constraint?

A. Encrypted host

B. Private host

C. Baston host

D. Isolation host

You are migrating an on-premises Linux 11.2.0.4 Database to a Database Cloud Service by using the Cross-Platform Transportable Tablespace Backup Set. Which statement is true?

A. The Database Cloud Service target version must be 12.1 or later.

B. The Database Cloud Service target version must be 11.2.0.4.

C. The Database Cloud service target iS a container database (CDB).

D. FOR TRANSPORT and TO PLATFORM clauses are not supported in RMAN on version 11.2.0.4.

Which database version introduced Zero Downtime online logical migration?

A. Oracle Database 18c

B. Oracle Database 21c

C. OracleDatabase 19c

D. Oracle Database 12c

Which TWO statements are true about cross-endian migration using Transportable Tablespaces? (Choose all correct answers)

A. Tablespaces must be converted by either RMAN CONVERT Or DBMS_FILE_TRANSFER.

B. system and sysaux can be migrated cross-endian.

C. Tablespaces may not be encrypted.

D. Tablespaces must be compressed.