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

Oracle 1Z0-1094-22 Online Questions & Answers

• Question 51:

  Which autonomous database types are available on Oracle Cloud? (Choose three.)

  A. Autonomous Relation Database System
  B. Autonomous Data Warehouse
  C. Autonomous Streams
  D. Autonomous Transaction Processing
  E. Autonomous JSON Database
  B. Autonomous Data Warehouse
  D. Autonomous Transaction Processing
  E. Autonomous JSON Database

• Question 52:

  Which entry in a Data Pump parameter file ensures consistent export using Data Pump migration to Autonomous Database?

  A. PARALLEL
  B. LOGTIME
  C. METRIC
  D. FLASHBACK_TIME
  D. FLASHBACK_TIME

• Question 53:

  Which TWO methods are supported by Oracle Zero Downtime Migration (ZDM) for migrating onpremises databases to Autonomous Database? (Choose all correct answers)

  A. Logical online or offline migration using a database link
  B. Logical online or offline migration using OCI Object Storage
  C. Physical online or offline migration using OCI Object Storage
  D. Physical online or offline migration using a database link
  A. Logical online or offline migration using a database link
  B. Logical online or offline migration using OCI Object Storage

• Question 54:

  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
  A. Dumpfile
  C. Network mode (with database links)

• Question 55:

  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?

  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.
  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 56:

  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
  B. BI Cloud Connector
  D. File
  E. Object Storage

• Question 57:

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

  A. APEX
  B. RMAN
  C. IMPEXPDP
  D. DATAPUMP
  A. APEX

• Question 58:

  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 59:

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

  A. 1521
  B. 22
  C. 1680
  D. 443
  D. 443

• Question 60:

  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. Target and source have same Endianness.
  C. Source must be Little-endian.
  D. Source andtarget need to be container database (CDB).
  B. Target and source have same Endianness.
  D. Source andtarget need to be container database (CDB).