1Z0-1094-22 Online Practice Questions and Answers

Which technologies can you use for Zero Downtime physical migration? (Choose two.) (Choose all correct answers)

A. Data Guard

B. OracleGoldenGate

C. Data Pump

D. RMAN

When migrating an Oracle database, you must be aware of source and target requirements. Which TWO statements are true about using Oracle Zero DowntimeMigration (ZDM)? (Choose all correct answers)

A. Source Oracle Single Instance Databases can be migrated to Oracle RAC Databases with Oracle ZDM-.

B. Oracle ZDM supports cross-edition migration, allowing Standard Edition Databases to be migrated toEnterprise Edition Databases.

C. When migrating with Oracle ZDM and the target database is at a higher patch level than the source database, the data patch utility runs on the target database as a post-migration task.

D. Source Oracle Real Application Clusters (RAC) Databases can be migrated to Single Instance Databases with Oracle ZDM.

Which process does Oracle Data Integrator Enterprise Edition use to process and transform data for disparate relational database management systems or Big Data Engines?

A. DML

B. ELT

C. SOA

D. ETL

What does ETL stand for?

A. Export Transform and Load

B. Extract Translate and Load

C. Extract Transform and Load

D. Export Translate and Load

In case of migration using the RMAN DUPLICATE command, which file do you use to specify the location of the Database Wallet?

A. TNSNAMES.ORA

B. SQLNET.ORA

C. WALLET.ORA

D. LISTENER.ORA

You encounter error ORA-00245 while performing ZeroDowntime Migration of an Oracle RAC database. What might be the reason for this?

A. The RAC instances are running in Archivelog mode.

B. Port 1521 is open.

C. TDE Wallet is configured.

D. SNAPSHOT CONTROL is not pointing to a shared location on all OracleRAC instances.

In which mode must the auxiliary instance be started while using the RMAN DUPLICATE command for database migration?

A. NOMOUNT

B. OPEN

C. FORCE

D. MOUNT

Which tools can be used to perform Oracle Zero Downtime logical migration? (Choose two.)

A. Oracle GoldenGate

B. RMAN

C. Data Guard

D. Data Pump

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