Oracle Database MySQL 5.6 Developer — Question 38

You want to load data directly from a file into MYSQL by using the SOURCE command.
Which types of data can the file contains to perform this?

Answer options

• A. SQL commands
• B. Comma-delimited data
• C. Tab-delimited data
• D. MyISAM or InnoDB data files

Correct answer: B

Explanation

The correct answer is B, as the SOURCE command is specifically designed to execute SQL commands stored in a file, and comma-delimited data can be easily imported into MySQL tables. Options A, C, and D do not represent the types of data that can be directly loaded using the SOURCE command.