Summer Goodies - 55% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: av5rz84q

Exact2Pass Menu

Question # 4

Which of these can be used to unload and load data via DataPump? (Choose two.)

A.

Dumpfile

B.

Streamfile

C.

Network mode (with database links)

D.

Backupset

Full Access
Question # 5

Which source database versions are supported for OCI Database Migration? (Choose two.) (Choose all correct answers)

A.

Oracle Database 10g R1

B.

Oracle Database 10g R2

C.

Oracle Database 19c

D.

Oracle Database 11g

Full Access
Question # 6

Which TWO methods should you use when migrating a target database with different endianness than the source database? (Choose all correct answers)

A.

RMAN DUPLICATE

B.

RMAN Transportable Tablespaces with Data Pump

C.

RMAN CONVERT

D.

RMAN RESTORE from target

Full Access
Question # 7

Which TWO object types should be excluded from an Autonomous Transaction Processing database? (Choose all correct answers)

A.

SCHEMA

B.

DB -LINK

C.

constraint

D.

cluster

Full Access
Question # 8

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 all correct answers)

A.

In-Memory Engine

B.

BI Cloud Connector

C.

Oracle (ADW)

D.

File

E.

Object Storage

Full Access
Question # 9

Which statement is true?

A.

One PDB consists of only one CDB.

B.

One CDB canhave only one PDB.

C.

One PDB consists of multiple CDBs.

D.

One CDB can have one or more PDBs.

Full Access
Question # 10

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

Full Access
Question # 11

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?

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.

Full Access
Question # 12

How much network latency is tolerated by the Remote Apply process of Oracle GoldenGate?

A.

8 ms

B.

16 ms

C.

4 ms

D.

6 ms

Full Access
Question # 13

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

Full Access