1Z0-931-25 practice question 11 of 25

Which two objects are imported when using Data Pump to migrate your Oracle database to Autonomous Database? (Choose two.)

Full set: 149 questions
Answer options
A: Tablespaces
B: Data Correct answer
C: Schemas Correct answer
D: Report
Correct Answer:
B. Data; C. Schemas
Explanation

Oracle Data Pump is a utility for high-speed movement of data and metadata between Oracle databases. When migrating to an Autonomous Database (ADB), Data Pump is used to import logical database structures. This includes schemas, which are collections of database objects like tables, views, and procedures, and the data contained within those objects. Autonomous Database manages the physical storage layer, so while the objects are created, the source tablespaces themselves are not imported; instead, the objects are remapped to the default DATA tablespace within ADB.

Why Incorrect

A. Tablespaces: Autonomous Database abstracts physical storage management. Source tablespaces are not imported; objects are automatically remapped to the pre-existing DATA tablespace in the target ADB.
D. Report: A report is an output file generated by the Data Pump utility to log the process and results of the import job. It is not a database object that is imported into the database itself.

References

1. Oracle Cloud Infrastructure Documentation

Loading Data with Oracle Data Pump on Autonomous Database: "Oracle Data Pump provides a fast and convenient way to move data and metadata from an existing Oracle Database to Autonomous Database... When you import into Autonomous Database

Data Pump automatically remaps tablespaces to the DATA tablespace in your Autonomous Database." This confirms data and metadata (schemas) are moved

while tablespaces are remapped

not imported.

Source: Oracle Cloud Infrastructure Documentation

"Use Oracle Data Pump to Import Data into Autonomous Database"

Section: "Import your data into Autonomous Database".

2. Oracle Database Utilities

21c

Chapter 13: Data Pump Import: The impdp command documentation specifies the modes of operation

including SCHEMAS

TABLES

and FULL

all of which involve importing schema objects and their associated data.

Source: Oracle Database Utilities

21c

"Data Pump Import"

Section: "Parameters for Data Pump Import"

Description of the SCHEMAS parameter.

Scroll to Top