exam questions

Exam 1z0-083 All Questions

View all questions & answers for the 1z0-083 exam

Exam 1z0-083 topic 1 question 67 discussion

Actual exam question from Oracle's 1z0-083
Question #: 67
Topic #: 1
[All 1z0-083 Questions]

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

  • 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
Show Suggested Answer Hide Answer
Suggested Answer: BCF 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
dacoben415lywenw
Highly Voted 4 years, 6 months ago
looks like table migration methods are asked here, not upgrade methods, should be BCF
upvoted 16 times
CyborgQ
4 years, 4 months ago
why B ? The same role is for sqlplus For me correct is CEF as tell us veginha
upvoted 2 times
frst1804
2 years, 1 month ago
That sqlplus isn't among the answers doesn't mean that b is incorrect ....
upvoted 1 times
...
...
...
veginha
Highly Voted 4 years, 6 months ago
C,E and F are correct Oracle provides features and products to automate the upgrade process and ensure the most efficient use of time. Oracle Database supports the following methods for upgrading a database to the new release: Database Upgrade Assistant (DBUA) Manual upgrade using SQL scripts and utilities Oracle Data Pump CREATE TABLE AS SQL statement https://docs.oracle.com/database/121/UPGRD/intro.htm#UPGRD60026
upvoted 9 times
Oracleist
2 years, 1 month ago
Upgrade is not Migrate!!!
upvoted 3 times
...
...
gonza150
Most Recent 2 months ago
Selected Answer: BCF
Oracle Database provides several methods for migrating data from one database to another, catering to different needs for data volume, complexity, and downtime requirements. Here are some of the primary migration methods supported by Oracle: 1. Data Pump (expdp and impdp) 2. Oracle GoldenGate 3. Transportable Tablespaces 4. Cross-Platform Transportable Tablespaces (XTTS) 5. Oracle SQL Developer 6. Oracle Migration Workbench 7. RMAN (Recovery Manager) 8. Oracle Zero Downtime Migration (ZDM) 9. Database Links 10. Oracle Cloud Infrastructure (OCI) Database Migration Service
upvoted 1 times
...
auwia
6 months, 1 week ago
Selected Answer: CEF
C, E and F.
upvoted 1 times
...
acesonly
7 months, 2 weeks ago
Selected Answer: CEF
Oracle Database supports the following methods for upgrading or migrating a database to the new release: * Database Upgrade Assistant (DBUA) * Migrating data using Oracle Data Pump * CREATE TABLE AS SQL statement
upvoted 2 times
...
mamadu
10 months ago
Selected Answer: CEF
reference: https://docs.oracle.com/en/database/oracle/oracle-database/18/upgrd/upgrade-and-data-migration-methods-and-processes.html#GUID-93250F01-DB85-4CA2-9A10-5B5FA5E4B924
upvoted 2 times
acesonly
7 months, 2 weeks ago
Oracle Database supports the following methods for upgrading or migrating a database to the new release: * Database Upgrade Assistant (DBUA) * Migrating data using Oracle Data Pump * CREATE TABLE AS SQL statement
upvoted 2 times
...
...
_gio_
1 year, 6 months ago
Selected Answer: BCF
I think BCF it's not an upgrade, it is a migration
upvoted 1 times
...
ScottL
1 year, 8 months ago
Selected Answer: BCF
BCF correct
upvoted 1 times
...
jareach
1 year, 10 months ago
Selected Answer: BCF
I believe so.
upvoted 2 times
...
casfdsaf
2 years, 8 months ago
Selected Answer: BCF
bcf ithink
upvoted 3 times
...
Neil107
3 years, 4 months ago
it's BCF.
upvoted 4 times
...
Shalom
3 years, 7 months ago
https://www.oracle.com/us/products/database/migrating-to-oracle-database-wp-3610526.pdf
upvoted 1 times
...
ObserverPL
3 years, 7 months ago
C and F are correct no doubt. E would be fine but question is about AFTER UPGRADING database, hence once DBUA finishes his work. So E is not correct. The only remaining sensible third answer is B.
upvoted 6 times
...
asefa
4 years, 3 months ago
CEF https://docs.oracle.com/en/database/oracle/oracle-database/18/upgrd/upgrade-and-data-migration-methods-and-processes.html#GUID-93250F01-DB85-4CA2-9A10-5B5FA5E4B924
upvoted 3 times
...
janw
4 years, 4 months ago
argument of veginha handles the upgrade itself, this question handles about a heap move. for me BCF
upvoted 4 times
...
cerebro2000x
4 years, 4 months ago
BCF for me i have not yet tried dbua to upgrade tables
upvoted 3 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago