The correct answer is C. When you add the asterisk (*) from any field list to a query, the query will include every field from the table.
Option A is incorrect because the table will still include all of its fields, even if you add the asterisk (*) to the field list.
Option B is incorrect because the query will not sort the table's records in any particular order.
Option D is incorrect because the query will display all of the records from the table, not just some of them.
Here is an example of how the asterisk (*) can be used in a query:
sql
SELECT * FROM table_name;
This query will return all of the records from the table named table_name, including all of the fields in the table.