1Z0-1094-21 by Oracle Actual Free Exam Questions And Answers

Question 1

Which file types can be imported using SQL Developer Web?

A. JSPN

B. CSV Delimited

C. AVRO

D. Excel

E. All of the options

Discussion 0

Correct Answer: E Vote an answer

Question 2

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. File

D. Oracle (ADW)

E. Object Storage

Discussion 0

Correct Answer: B,C,E Vote an answer

Question 3

What can you use to quickly load data into a cloud database by dragging and dropping a file in a web browser?

A. RMAN Transportable Tablespace

B. Data Load tab of the SQL worksheet in Database Actions

C. Remote cloning a pluggable database (PDB)

D. Data Pump Transportable Tablespaces

Discussion 0

Correct Answer: B Vote an answer

Question 4

Which TWO products/utilities does Oracle Zero Downtime Migration use as part of its migration workflows to Autonomous Database? (Choose all correct answers)

A. Data Guard

B. Data Pump

C. GoldenGate

D. Recovery Manager

Discussion 0

Correct Answer: B,C Vote an answer

Question 5

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

A. Network mode (with database links)

B. Backupset

C. Streamfile

D. Dumpfile

Discussion 0

Correct Answer: A,D Vote an answer

Question 6

For a source database to be successfully migrated, you must view and apply the prerequisites. Which TWO prerequisites must pass before the source database can be migrated using Oracle Zero Downtime Migration (ZDM)? (Choose all correct answers)

A. The database must have Transparent Data Encryption (TDE) enabled.

B. Port 22 on the source database server must allow incoming connections from the ZDM service host.

C. Archivelog must be enabled

D. The database must have a configured TDE wallet if the version is Oracle Database 11g Release 2 or 12c Release 1.

E. The database must be stored in an Automatic Storage Management Cluster File System (ACFS).

Discussion 0

Correct Answer: B,C Vote an answer

Question 7

Which port number do all the OCI GoldenGate Microservices environments use for port forwarding through NGINX?

A. 1680

B. 443

C. 22

D. 1521

Discussion 0

Correct Answer: B Vote an answer

Question 8

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. Tablespaces must be compressed.

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

D. Tablespaces may not be encrypted.

Discussion 0

Correct Answer: A,D Vote an answer

Question 9

Which FOUR key parameters should you include in your export command when migrating an Oracle Database to the Oracle Cloud? (Choose all correct answers)

A. metrics=yes (for Diagnostics)

B. versron=10 (for compatibility)
exclude=statistics (for performance

C. FLASHBACK_TIME=SYSTIMESTAMP (for consistent Export)

D. parameter=1 (for performance)
logtime=all (for Diagnostics)

Discussion 0

Correct Answer: A,B,C,D Vote an answer

Question 10

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. Source must be Little-endian.

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

D. Target and source have same Endianness.

Discussion 0

Correct Answer: C,D Vote an answer

Oracle Cloud Database Migration and Integration 2021 Specialist - 1Z0-1094-21 Exam Practice Test

Contact Us

Useful Links

Latest Updated