Oracle
1Z0-882 · Question #38
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…
The correct answer is C. LOAD DATA INFILE `/tmp/people.txt `INTO TABLE People (@ Skip, @First , @Last, @Country. See the full explanation below for the reasoning.
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.
How the community answered
(30 responses)- A7% (2)
- B10% (3)
- C80% (24)
- E3% (1)
Community Discussion
No community discussion yet for this question.