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 questionsAfter 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.
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.
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.
Keep practicing
Take the free 1Z0-083 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other 1Z0-083 practice questions
- Question 1Which two are true about flashback features in Oracle Database 19c and later releases? (C…
- Question 2Which two statements are true about Resource Manager plans for individual pluggable datab…
- Question 3Choose three. Which are the three steps in the SQL tuning process for Oracle Database env…
- Question 4Choose three. Which three are true about using Database Upgrade Assistant (DBUA) to upgra…
- Question 5Choose three. Which three capabilities require the use of the RMAN recovery catalog?
- Question 6Choose two. In which two situations can you use Database Upgrade Assistant?
