Oracle Database Administration II — Question 40

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

Answer options

• A. using Database Replay
• B. using SQL Developer
• C. using Oracle Data Pump
• D. using operating system file copy utilities
• E. using Database Upgrade Assistant
• F. using the CREATE TABLE AS SELECT SQL statement

Correct answer: B, C, F

Explanation

The correct answers B, C, and F are all valid methods for migrating heap table data after a database upgrade, as they are designed for data manipulation and transfer. Options A, D, and E do not specifically address heap table data migration after an upgrade, making them incorrect in this context.