1Z0-1094-22 Online Practice Questions and Answers

Which file types can be imported using SQL Developer Web?

A. All of the options

B. Excel

C. AVRO

D. CSV Delimited

E. JSPN

Which supported platform can the source Oracle Database be running on when migrating with Oracle Zero Downtime Migration?

A. aix

B. windows

C. Linux x86-64

D. Solaris

You are looking at migrating a large data centre to the Oracle Cloud while trying to consolidate many Oracle Databases at the same time. Which Oracle Data Management Service helps you achieve this?

A. oracle ExadataCloud Service

B. oracle Data Safe

C. oracle MySQL Cloud Service

D. oracle Autonomous Database

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)

A. Enterprise Scheduler Service (ESS) SOAP API

B. Universal Content Management

C. BI Application Configuration Manager

D. REST API

E. Cloud Connector

Which type of autonomous database will you create for decision support systems that run fast queries over large volumes of data?

A. Autonomous Transaction Processing

B. Autonomous JSON Database

C. Autonomous Data Warehouse

D. Autonomous APEX Service

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"

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

A. Database version downgrade can be achieved with PDB relocation.

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

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

D. Online PDB relocation can achieve a zero downtime upgrade.

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

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

You are migrating a non TDE encrypted on-premisesDatabase to an OCT Database Service Instance ising RMAN. You set up the DB Cloud Backup Module, but when executing the RMAN command to create your Cloud Backup you see the

following error:

AANA RMAN-03009: failure of backup command on ORA_SBT_TAPE 1 channel at:

08/18/2014 11: ORA-19914: unable to encrypt backup ORA~29361 mastor key not yet set

What are the TWO causes of this error? (Choose all correct answers)

A. The Set ENCRYPTION IDENTIFIED BY command was executed.

B. SET ENCRYPTION ON

C. The Set ENCRYPTION IDENTIFIED BY only command was executed

D. He OCT Object Storage eye on at rest key is missing

E. The set DECRYPTION IDENTIFIED BY RMAN command was not executed.