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 questionsOracle 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.
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.
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.
Keep practicing
Take the free 1Z0-931-25 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other 1Z0-931-25 practice questions
- Question 1Which three are Oracle-recommended best practices for Autonomous Database alarms? (Choose…
- Question 2Oracle Data Safe is a unified control center for your Oracle databases that helps you und…
- Question 3You are the admin of an Autonomous Database (ADB) instance, and a new developer has reque…
- Question 4Which three tools can be used to monitor the usage and activities of Autonomous Database …
- Question 5What is the difference between Autonomous Data Warehouse (ADW) and Autonomous Transaction…
- Question 6Which two statements are true about using an Oracle Autonomous Database with private endp…
