Which of the following statements will load the data from the file into the table while storing first and last name into the Name column and the Country into the Country column?

Consider the content of the file /tmp/People.txt.

Which of the following statements will load the data from the file into the table while storing first and last name into the Name column and the Country into the Country column?

A.
LOAD DATA INFILE ‘ /tmp/People. txt’ INTO TABLE People @First=$2, @Last=$3, @Country=$4, (CONCAT(@First,’ ‘,@LastJ, @Country)

B.
LOAD DATA INFILE ‘/tmp/People.txt’ INTO TABLE People @Skip=$l, @First=$2, @Last=$3, @Country=$4, (CONCAT(@First,’ ‘,@LastJ, @Country)

C.
LOAD DATA INFILE ‘/tmp/People.txt’ INTO TABLE People (@Skip, @First, @Last, @Country) SET Name=CONCAT(@First,’ ‘,@Last)

D.
LOAD DATA INFILE ‘/tmp/People.txt’ INTO TABLE People (@Skip, @First, @Last, @Country) SET Name=CONCAT(@First, ‘ ‘,@LastJ, Country=@Country)

E.
you cannot, oecause tne numoer or columns in tne Tile need to matcn the numoer or columns in the table.

Explanation:
A and B are setting variables to specific values, not using text file??
C doesn’t assign value for Country as variable not used.