Oracle Exam 1Z0-882 Topic 2 Question 1 Discussion

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

Question #: 1
Topic #: 2

The tab-delimited file''/tmp/people,txt contains:

1636 Carsten Pederson Denmark

4672 Kai Voigt Germany

4628 Max Mether France

This is the structure of the people table:

Mysq1> DESCRIBE people;

Which statement will load the first and last names into the Names column and the country into the country column?

ALOAD DATA INFILE '/tmp/people.txt'INTO TABLE PEOPLE@First=$2. @Last=$3 @Country=$4

BLOAD DATA INFILE '/tmp/people.txt ' INTO TABLE People

CLOAD DATA INFILE '/tmp/people.txt 'INTO TABLE People

DLOAD DATA INFILE '/tmp/people,txt, INTO TABLE People.

EIt is not possible to load the data from the file/tmp/people.txt into the people table,as shown.

Show Suggested Answer

Suggested Answer: C

by Fletcher at May 06, 2022, 07:22 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

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