Oracle Exam 1Z0-320 Topic 1 Question 1 Discussion

Actual exam question for Oracle's 1Z0-320 exam

Question #: 1
Topic #: 1

You have a text file named ''xyz.csv'' exported from another system.

You are asked to import data to a MySQL Database table named ''country''.

The table definition is as follows:

Identify the action that imports the data from Workbench or MySQL Client to the database correctly.

AUse theLOAD DATA INFILEsyntax to load data into the database table.

BUsemysqlimportto load themycountry.csvdata file with the--csvoption specified.

CCreate aDIRECTORY LINKobject on the database and useINSERT into mycountry SELECT *from mycountry.csv.

DConvert the data into MDI and restore the MySQL data from it.

Show Suggested Answer

Suggested Answer: A

by Kimbery at Dec 29, 2022, 09:28 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!