New Year Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

Free and Premium Oracle 1z0-1094-22 Dumps Questions Answers

Page: 1 / 3
Total 90 questions

Oracle Cloud Database Migration and Integration 2022 Professional Questions and Answers

Question 1

Which TWO statements are true about the Oracle Zero Downtime command line? (Choose all correct answers)

Options:

A.

The zdmeli migrate database command can be run with no options as long as all the information is correctly specified in Zero Downtime Migration’s (ZDM) response file.

B.

When the source database is a single instance database deployed on a non-Grid Infrastructure environment, the sourcesid option should be used to specify the database name.

C.

Upon executing the zdmcli, migrate database command, the only way to track the status of the migration is by querying the ZDM service using the provided job ID.

D.

The -sourcedb option is the only valid option to indicate the source database name.

Buy Now
Question 2

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

Options:

A.

Data Pump Export/lmport

B.

EnterpriseManager

C.

Oracle Zero Downtime Migration

D.

Data Guard

E.

PDB Unplugging/Plugging

Question 3

Which Oracle Database Cloud Service takes care of all routine database tasks ensuring higher performance, reliability, security, and operational efficiency?

Options:

A.

Oracle Exadata

B.

Oracle 19c

C.

Oracle MySQL Cloud Service

D.

Oracle Autonomous Database

Question 4

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?

Options:

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.

Question 5

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

Options:

A.

APEX

B.

RMAN

C.

IMPEXPDP

D.

DATAPUMP

Question 6

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?

Options:

A.

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

B.

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

C.

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

D.

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

E.

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

Question 7

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

Options:

A.

Flashback

B.

Active Data Guard

C.

Sharding

D.

GoldenGate

Question 8

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)

Options:

A.

JV$D view

B.

J$ table

C.

JV$ view

D.

JW$ view

Question 9

In which mode must the auxiliary instance be started while using the RMAN DUPLICATE command for database migration?

Options:

A.

NOMOUNT

B.

OPEN

C.

FORCE

D.

MOUNT

Question 10

Which parameter can be used to export a subset of data using Data Pump?

Options:

A.

TABLES_AS_VIEWS

B.

SUBSET_AS_TABLES

C.

VIEWS_AS_TABLES

D.

MATERIALIZED_VIEWS

Question 11

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?

Options:

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.

Question 12

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?

Options:

A.

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

B.

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.

C.

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.

D.

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.

Question 13

What are the constraints of using transportable tablespaces? (Choose two.)

Options:

A.

The source and target database versions must match.

B.

Thesource and target time zone versions must match.

C.

The source and target platforms must match.

D.

The source and target character sets must match.

Page: 1 / 3
Total 90 questions