Question

One can display all columns of data in a table by following the SELECT keyword with _______________.

• A. $+$
• B. $\ast$
• C. $-$
• D. $?$

Answer 1

The correct option is B $\ast$

One can display all columns of data in a table by following the SELECT keyword with *.

A select query is a database object that shows information in datasheet view. A query does not store data; it displays data that is stored in tables. A query can show data from one or more tables, from other queries, or from a combination of the two.

A select statement retrieves zero or more rows from one or more database tables or database views. The asterisk (*) is used to denote that all columns in a table should be displayed as part of the output.