Oracle
1Z0-882 · Question #38
1Z0-882 Question #38: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-882 to reveal the answer and full explanation for question #38. The question stem and answer options stay visible for context.
Question
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?
Options
- ALOAD DATA INFILE `/tmp/people.txt'INTO TABLE PEOPLE@First=$2. @Last=$3 @Country=$4
- BLOAD DATA INFILE
/tmp/people.txtINTO TABLE People @Skip=$1 , @ First=$2, @Last=$3, - CLOAD DATA INFILE
/tmp/people.txtINTO TABLE People (@ Skip, @First , @Last, @Country - 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.
Unlock 1Z0-882 to see the answer
You've previewed enough free 1Z0-882 questions. Unlock 1Z0-882 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.