In an SQL SELECT statement querying a single table, according to the SQL-92 standard the asterisk (*) means that:

A. all columns of the table are to be returned.

B. all records meeting the full criteria are to be returned.

C. all records with even partial criteria met are to be returned.

D. None of the above is correct.

Answer: Option A

Solution(By Examveda Team)

In SQL, when you use an asterisk (*) in a SELECT statement while querying a single table, it means that you want to retrieve all columns of the table. It's a shorthand way to select all available columns without listing them explicitly. Options B and C do not accurately represent the usage of the asterisk in this context.