Which of the following statements is correct?
A) The columns will be listed in the results in the same order they are stored in the database table.
B) Character columns are listed first in the output, followed by numeric columns.
C) The columns will be listed in the results in the same order they are listed in the SELECT clause of the SELECT statement.
D) Numeric columns are listed first in the output, followed by character columns.

Question

Quizplus · Accepted Answer

The columns will be listed in the order they are listed in the SELECT clause of the SELECT statement. The order in which columns are stored in the database table or the data type of the columns does not affect the order of the output.

Which of the Following Statements Is Correct