Oracle 1Z0-1094-22 Online Practice Questions and Exam Preparation

Oracle 1Z0-1094-22 Online Questions & Answers

• Question 1:

  Which TWO target database environments provide both high availability (HA) and disaster recovery (DR) options in the cloud? (Choose all correct answers)

  A. Autonomous Database
  B. Database Cloud service Bare Metal
  C. Infrastructure as a service
  D. Exadata Cloud Service
  A. Autonomous Database
  D. Exadata Cloud Service

• Question 2:

  Your source tables are in an on-premises Oracle Database. You are creating a data server in Oracle Data Integrator (ODI) topology. Which THREE configuration items are needed to successfully test an on-premises Oracle Database connection ? (Choose 3 all correct answers)

  A. name of the Oracle Instance (SID) or service
  B. network name or IP address of the machine hosting the Oracle Database
  C. database link
  D. list of all schemas
  E. listing port of the oracle listener
  A. name of the Oracle Instance (SID) or service
  B. network name or IP address of the machine hosting the Oracle Database
  E. listing port of the oracle listener

• Question 3:

  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.
  A. The Set ENCRYPTION IDENTIFIED BY command was executed.
  B. SET ENCRYPTION ON

• Question 4:

  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. system and sysaux can be migrated cross-endian.
  C. Tablespaces may not be encrypted.
  D. Tablespaces must be compressed.
  A. Tablespaces must be converted by either RMAN CONVERT Or DBMS_FILE_TRANSFER.
  C. Tablespaces may not be encrypted.

• Question 5:

  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
  B. Data Pump Conventional Export/lmport
  C. RMAN cross-Platform Transportable PDB

• Question 6:

  You are trying to load a denormalized target table C and the source attributes come from table A and Table B inOracle Data Integrator (ODI). Which statement is true?

  A. A mapping can have only one source and one target. You need to create 2 mappings to load target C.
  B. You can join table A and table B, as required by the data model and load target C in a Single mapping
  C. You are required to do inner join between table A and table B in order to load target C.
  D. You are required to do outer join between table A and table B in order to load target C.
  B. You can join table A and table B, as required by the data model and load target C in a Single mapping

• Question 7:

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

  A. It supports cross-endian formats
  B. Both the source and target database mustbe of the same version
  C. It supports cross-platform migration
  D. A best practice is to invoke Data Pump using SYS as SYSDBA
  A. It supports cross-endian formats
  C. It supports cross-platform migration

• Question 8:

  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?

  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.
  B. Increase the default port number by one and retry five times.

• Question 9:

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

  A. TABLES_AS_VIEWS
  B. SUBSET_AS_TABLES
  C. VIEWS_AS_TABLES
  D. MATERIALIZED_VIEWS
  C. VIEWS_AS_TABLES

• Question 10:

  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
  C. Oracle Database 19c
  D. Oracle Database 11g