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.