The asterisk (*) in a SQL SELECT statement querying a single table, according to the SQL-92 standard, signifies that:
A. All columns of the table must be returned.
B. All records that match the full set of requirements must be returned.
C. All records that meet even a partial set of criteria must be returned.
D. None of the above are correct.
Answer:A
The asterisk (*) in a SQL SELECT statement querying a single table, according to the SQL-92 standard, signifies that:
A. All columns of the table must be returned. B. All records that match the full set of requirements must be returned. C. All records that meet even a partial set of criteria must be returned. D. None of the above are correct.
Explanation: All of the table's columns must be returned.