Real Oracle 1z0-1094-22 Exam Questions Study Guide [Q23-Q42]

admin 1z0-1094-22 Oracle July 29, 2023

Rate this post

Real Oracle 1z0-1094-22 Exam Questions Study Guide

Updated and Accurate 1z0-1094-22 Questions for passing the exam Quickly

NEW QUESTION 23
When migrating an Oracle database, you must be aware of source and target requirements. Which TWO statements are true about using Oracle Zero Downtime Migration (ZDM)? (Choose all correct answers)

Source Oracle Single Instance Databases can be migrated to Oracle RAC Databases with Oracle ZDM-.

When migrating with Oracle ZDM and the target database is at a higher patch level than the source database, the data patch utility runs on the target database as a post-migration task.

Oracle ZDM supports cross-edition migration, allowing Standard Edition Databases to be migrated to Enterprise Edition Databases.

Source Oracle Real Application Clusters (RAC) Databases can be migrated to Single Instance Databases with Oracle ZDM.

NEW QUESTION 24
Which THREE Fusion SaaS components from the Oracle Data Integrator (ODI) Loading Knowledge Modules can be used to extract data out of Fusion SaaS applications and load it into Autonomous Data Warehouse (ADW)? (Choose all correct answers)

Universal Content Management

BI Application Configuration Manager

REST API

Cloud Connector

Enterprise Scheduler Service (ESS) SOAP API

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

RMAN

Oracle GoldenGate

Data Guard

Data Pump

NEW QUESTION 26
Which developer tool is web-based, function-rich, and resides in a low code development environment?

IMPEXPDP

RMAN

APEX

DATAPUMP

NEW QUESTION 27
In which database edition does Data Pump support parallelism?

Enterprise Edition only

Standard Edition only

Both Standard Edition and Enterprise Edition

Data Pump does not support parallelism.

NEW QUESTION 28
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)

“-tgtroot”

“-sourceid”

“-dbversion”

“-dbpatchievel”

“-sourcedb”

“-tdemasterkey”

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

Oracle Zero data loss recovery appliance

NFS Storage

Oracle Cloud Infrastructure Object Storage

Third-Party Cloud Storage

Tape Storage

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

Database version downgrade can be achieved with PDB relocation.

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

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

Online PDB relocation can achieve a zero downtime upgrade.

NEW 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?

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

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

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

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

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

NEW QUESTION 32
Which statements are true about Data Pump? (Choose two.)

Both the source and target database must be of the same version

It supports cross-platform migration

A best practice is to invoke Data Pump using SYS as SYSDBA

It supports cross-endian formats

NEW QUESTION 33
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)

Target must be an Autonomous database.

Source and target need to be container database (CDB).

Target and source have same Endianness.

Source must be Little-endian.

NEW QUESTION 34
Which file types can be imported using SQL Developer Web?

AVRO

CSV Delimited

Excel

All of the options

JSPN

NEW QUESTION 35
You have a security requirement within your organization to separate your resources. There is a team that supports each resource and they are not allowed access to the other resources.
Which security control with Oracle Cloud Infrastructure meets this requirement?

Compartments and Policies

Key Management

Tagging

Federation

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

RMAN Backup and Restore

import over Oracle Database database link

import dump file from OCI Object Storage

pdb unplug/plug

NEW QUESTION 37
You need to migrate your on-premises 12c Non CDB to Cloud 12c. Which migration methods can you use? (Choose two.)

Conventional RMAN Backup and Recovery

Transportable Tablespaces

Conventional Data Pump Export and Import

Transportable Databases

NEW QUESTION 38
You have an on-premises non-TDE-encrypted Linux 19c container database (CDB) that is already being regularly backed up to Oracle Cloud Infrastructure (OCI) Object Storage via the Database Backup Cloud Service. You plan on using Recovery Manager (RMAN) to migrate it to Database Cloud Service. What is the valid strategy to migrate?

Create a new OCI DB Service instance, delete the existing database, and use the DBaa$ tooling to configure the DB Cloud Backup Module to point to the existing bucket, and then restore the backup by using the console.

Create a new OCI DB Service Instance, copy the backup data from the bucket to the FRA, and then use the console to perform a DB restore.

Create a new DB Service instance, delete the existing database, manually install the DB Cloud Backup Module pointing it to the backed where the on-premises backups are located, and perform a complted RMAN RESTORE AS encryption operation.

Create a new OCI DB Service instance and use the “instantiate from backup” option in the console. This will automatically take care of the encryption.

NEW QUESTION 39
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 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?

The Check Knowledge Module was not set in the physical design.

There were no rows compliant with imposed constraint.

Primary key was not defined on the target table.

The integration type was not set in the logical design.

NEW QUESTION 40
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)

JW$ view

JV$ view

J$ table

JV$D view

NEW QUESTION 41
Which statements are true for OCI GoldenGate Service? (Choose two.)

It supports the usage of Universal Credits.

It requires an on-premises license for the Oracle GoldenGate software.

It is customer-managed.

It requires any source environment to run Oracle GoldenGate Microservices.

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

Tablespaces must be compressed.

Tablespaces must be converted by either RMAN CONVERT Or DBMS_FILE_TRANSFER.