Explanation:
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.
Ultimate access to all questions.
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.
No comments yet.