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

• A.REST Data Services
• B.SQL Developer Web
• C.SQL Developer
• D.Modeler

Comment: *

Name: *

Email: *

Verification: *

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

• A.FORCE
• B.MOUNT
• C.OPEN
• D.NOMOUNT

Comment: *

Name: *

Email: *

Verification: *

You run a database instance on Oracle Database 11.2 and you want to migrate to Oracle Cloud. In which case is it required to upgrade your source database before migrating to the cloud?

• A.if you are using virtual machines
• B.if you are using Recovery Manager (RMAN)
• C.if you are using unplug/plug
• D.if your target is Exadata Cloud Service

Comment: *

Name: *

Email: *

Verification: *

When integrating data from multiple sources into 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.The Check Knowledge Module was not set in the physical design.
• B.There were no rows compliant with imposed constraint.
• C.Primary key was not defined on the target table.
• D.The integration type was not set in the logical design.

Comment: *

Name: *

Email: *

Verification: *

Which TWO methods support a difference in endian format when migrating a database from onpremises to Oracle Cloud? (Choose all correct answers)

• A.PDB Remote Cloning
• B.RMAN cross-Platform Transportable PDB
• C.PDB Unplugging/Plugging
• D.Data Pump Conventional Export/lmport

Comment: *

Name: *

Email: *

Verification: *