DATABASE MIGRATION 1

Which migration method gives you the least down time

• Data Guard
• RMAN point-in-time recovery
• Transportable Tablespaces
• Data pump

You have a requirement to join data from an Oracle database table and a flat file and load into target DB2 table, using Oracle Data Integrator (ODI). Which statement is correct about this?

• Heterogeneous sources and targets are possible in a single mapping only if there is no incremental data load
• Flat file data has to have a header row in order to join with Oracle database table in a single mapping
• It is not possible to join data from different source connection types in a Single mapping
• It is possible to mix heterogeneous source connection type and load into any supported target connection type in a single mapping.
• It is possible to join data from different source connection types in mapping, but the result must be loaded to Oracle

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

• PARALLEL
• LOGTIME
• METRIC
• FLASHBACK_TIME

Which two migration methodologies can you use for migrating on-premises databases to Autonomous Database with Oracle Zero Downtime Migration (ZDM)? (Choose all correct answers)

• Physical Online
• Logical online
• Physical Offline
• Logical offline

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

• Source Oracle Single Instance Databases can be migrated to Oracle RAC Databases with Oracle ZDM-
• Oracle ZDM supports cross-edition migration, allowing Standard Edition Databases to be migrated to Enterprise Edition Databases
• 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.
• Source Oracle Real Application Clusters (RAC) Databases can be migrated to Single Instance Databases with Oracle ZDM

Planning a database migration to Oracle Cloud Infrastructure (OCI) requires understanding the source?

• users and groups to be migrated
• on-premises host operating system
• character set of databases
• number of tables

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

• Autonomous Database
• Database Cloud service Bare Metal
• Infrastructure as a service
• Exadata Cloud Service

You are planning the migration of a 19c Oracle Database from Amazon Web Services Relational Database Service (AWS RDS) using RMAN backups. What is the correct sequence of operations?

• Install the 0B Cloud Backup Module on the AWS ROS instance and perform a backup directly to an Oracle Cloud Intrastructure (OCI) Object storage bucket. Restore the backup from the OCI bucktt to an OCT DB Service instance
• Using the AWS tooling, take an RMAN backup of the RDS DB local file system and move it to an AWS S3 bucket. Copy the content of the S3 bucket to an Oracle Cloud Infrastructure (OCT) C. Object Storage bucket, Restore the backup from the OCI bucket to an OCI DB Service Instance.
• Install the Oracle Secure Backup Cloud Module on the AWS RDS Instance and take an RMAN backup directly to an AWS 53 bucket. Copy the content of the S3 bucket to an Oracle Cloud E. Infrastructure (OCI) Object Storage bucket. Restore the backup from the OCI bucket to an OCT DB Service Instance
• Using the AWS tooling, take an RMAN backup of the RDS DB local file system and copy sctly to. an Oracle Cloud Infrastructure (OCI) Object Storage bucket. Restore the backup from the OCI bucket to an OCI DB Service Instance.

Which supported platform can the source Oracle Database be running on when migrating with Oracle Zero Downtime Migration?

• aix
• windows
• Linux x86-64
• Solaris

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?

• The Database Cloud Service target version must be 12.1 or later.
• The Database Cloud Service target version must be 11.2.0.4.
• The Database Cloud service target iS a container database (CDB).
• FOR TRANSPORT and TO PLATFORM clauses are not supported in RMAN on version 11.2.0.4