1Z0-1094-22 Online Practice Questions and Answers

When integrating data from multiple sourcesinto a Data Warehouse schema, you want to check a length constraint that you have imposed on one of the target columns before the rows arrive in the target table. All the rows that do not pass this quality check will have to be isolated in error tables. For this, you have chosen an Integration Knowledge Module (IKM) that supports flow control. You have also chosen the value raue for this parameter to enable this check. At compile time, you see that Oracle Data Integrator (ODI) throws an error and the execution cannot start. What is the reason?

A. Primary key was not defined on the target table.

B. The Check Knowledge Module was not set in the physical design.

C. The integration type was not set in the logical design.

D. There were no rows compliant with imposed constraint.

You are using Data Pump to migrate your database to Autonomous Database (ADB). To which tablespace must you remap your source database tablespaces?

A. USERS

B. UNDO

C. SYSTEM

D. DATA

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.

In which database edition does Data Pump supportparallelism?

A. Both Standard Edition and Enterprise Edition

B. Enterprise Edition only

C. Standard Edition only

D. Data Pump does not support parallelism.

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

You are migrating an on-premises Linux 11.2.0.4 Database to a Database Cloud Service by using the Cross-Platform Transportable Tablespace Backup Set. Which statement is true?

A. The Database Cloud Service target version must be 12.1 or later.

B. The Database Cloud Service target version must be 11.2.0.4.

C. The Database Cloud service target iS a container database (CDB).

D. FOR TRANSPORT and TO PLATFORM clauses are not supported in RMAN on version 11.2.0.4.

Which of these provide Active Replication? (Choose two.)

A. Flashback

B. Active Data Guard

C. Sharding

D. GoldenGate

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.