Ultimate access to all questions.
Answer-first summary for fast verification
Answer: Text files generate a column with a string value for each line, while binary files have columns for path, modification time, length, and content.
When querying file-based data, text files are processed with each line representing a string value in a single column. Binary files, however, are handled differently, with a schema that includes metadata such as the file path, modification time, file length, and the content itself.
Author: LeetQuiz Editorial Team
No comments yet.
How do SQL queries process text and binary files differently when involving file data?
A
Text files generate a column with a string value for each line, while binary files have columns for path, modification time, length, and content.
B
Binary files generate a column with a string value for each line, whereas text files have columns for path, modification time, length, and content.
C
Text and binary files both generate columns for path, modification time, length, and content.
D
Text files create a single column for each byte of data, whereas binary files create a column for each bit.