Search Header Logo

DATABASE MIGRATION 3

Authored by Jaime Romero

Mathematics

1st - 5th Grade

Used 5+ times

DATABASE MIGRATION 3
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

29 questions

Show all answers

1.

MULTIPLE SELECT QUESTION

2 mins • 1 pt

Which statements are true for OCI GoldenGate Service? (Choose two.

It requires any source environment to run Oracle GoldenGate Microservices.
. It is customer-managed.
It requires an on-premises license for the Oracle GoldenGate software
It supports the usage of Universal Credits.

2.

MULTIPLE SELECT QUESTION

2 mins • 1 pt

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_x0002_premises Oracle Database connection ? (Choose 3 all correct answers)

name of the Oracle Instance (SID) or service
network name or IP address of the machine hosting the Oracle Database
database link
list of all schemas
listing port of the oracle listener

3.

MULTIPLE SELECT QUESTION

2 mins • 1 pt

Which THREE Fusion SaaS components from the Oracle Data Integrator (ODI) Loading Knowledge Modules can be used to extract data out of Fusion SaaS applications and load it into Autonomous Data Warehouse (ADW)? (Choose all correct answers)

Enterprise Scheduler Service (ESS) SOAP API
Universal Content Management
BI Application Configuration Manager
REST API
Cloud Connector

4.

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

Which Oracle product provides high performance bulk data movement, massively parallel data transformation using database or BI data technologies, and block-level data loading that leverages native data utilities?

Oracle Data Guard
Oracle Data Integrator
Oracle Analytics Server
Oracle Big Data

5.

MULTIPLE SELECT QUESTION

2 mins • 1 pt

Which TWO statements are true about cross-endian migration using Transportable Tablespaces? (Choose all correct answers

Tablespaces must be converted by either RMAN CONVERT Or DBMS_FILE_TRANSFER
system and sysaux can be migrated cross-endian.
Tablespaces may not be encrypted.
Tablespaces must be compressed

6.

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

Which developer tool can be used to load JSON documents to an Oracle database on the cloud?

SQL Developer Web
Modeler
REST Data Services
SQL Developer

7.

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

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?

Assign a random port number.
Increase the default port number by one and retry five times.
Request a valid port number
Exit the installation with an error message

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?