nerdexam
Oracle

1Z0-931 · Question #9

Migrating an on-premise database to Autonomous Database (ADB) for large amounts of data involves multiple steps like creating a credential object, creating (access to) a storage object/location…

The correct answer is A. SQL Developer can be used to export/move/import of a database to ADB in 1 set of wizard steps. C. SQL Developer can import .csv files into ADB which are located on the system where SQL D. SQL Developer can only export/move/import files using datapump from databases running on. See the full explanation below for the reasoning.

Question

Migrating an on-premise database to Autonomous Database (ADB) for large amounts of data involves multiple steps like creating a credential object, creating (access to) a storage object/location, running datapump export and running a datapump import. Which three statements are true for SQL Developer (18.3 and up) in combination with ADB Data Loading? (Choose three.)

Options

  • ASQL Developer can be used to export/move/import of a database to ADB in 1 set of wizard steps.
  • BSQL Developer can import files (.dmp and .csv for example) into ADB which are located on
  • CSQL Developer can import .csv files into ADB which are located on the system where SQL
  • DSQL Developer can only export/move/import files using datapump from databases running on

How the community answered

(27 responses)
  • A
    85% (23)
  • B
    15% (4)

Community Discussion

No community discussion yet for this question.

Full 1Z0-931 Practice