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
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
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
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.
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
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.
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
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.
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.
Which database version introduced Zero Downtime online logical migration?
A. Oracle Database 18c
B. Oracle Database 21c
C. OracleDatabase 19c
D. Oracle Database 12c
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only Oracle exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your 1Z0-1094-22 exam preparations and Oracle certification application, do not hesitate to visit our Vcedump.com to find your solutions here.