1Z0-083 practice question 15 of 35

Which three methods can be used for heap table data migration after upgrading a database? (Choose three.)

Full set: 286 questions
Answer options
A: using Database Replay
B: using SQL Developer Correct answer
C: using Oracle Data Pump Correct answer
D: using operating system file copy utilities
E: using Database Upgrade Assistant
F: using the CREATE TABLE AS SELECT SQL statement Correct answer
Correct Answer:
B. using SQL Developer; C. using Oracle Data Pump; F. using the CREATE TABLE AS SELECT SQL statement
Explanation

After a database upgrade, data may need to be moved or reorganized. Oracle Data Pump (expdp/impdp) is a primary utility for high-speed logical data and metadata migration. The CREATE TABLE AS SELECT (CTAS) statement is a standard SQL method to create a copy of a table, which can be used to move it to a new tablespace or change storage characteristics. SQL Developer provides user-friendly wizards for exporting and importing data between databases or schemas, making it a viable method for data migration.

Why Incorrect

A. Database Replay is a tool for capturing and replaying database workloads, primarily for performance testing and impact analysis, not for migrating data.
D. Operating system utilities copy physical data files at the block level. This is not a method for migrating specific logical objects like heap tables.
E. The Database Upgrade Assistant (DBUA) is a tool specifically for performing in-place database upgrades of the data dictionary and components, not for post-upgrade user data migration.

References

1. Oracle Database Utilities, 19c, Chapter 1, "Introduction to Oracle Data Pump". It states, "Oracle Data Pump enables high-speed movement of data and metadata from one database to another."

2. Oracle Database SQL Language Reference, 19c, "CREATE TABLE". The documentation for the AS subquery clause describes its use for creating and populating a table from the rows of another table.

3. Oracle SQL Developer User's Guide, 19c, Chapter 5, "Using the Cart to Move Database Objects". This chapter describes how to use SQL Developer to move objects and data between databases.

Scroll to Top