To display all the rows and columns in a table,type the word SELECT,followed by a(n)____,followed by the word FROM and then the name of the table containing the data you want to view.
A)single quote
B)asterisk
C)double quote
D)slash

Question

To display all the rows and columns in a table,type the word SELECT,followed by a(n)____,followed by the word FROM and then the name of the table containing the data you want to view.​
A)single quote
B)​asterisk
C)double quote
D)​slash

Quizplus · Accepted Answer

The asterisk (*) is used in SQL to denote "all" or "every column". Therefore, using SELECT * FROM tableName will display all the rows and columns in the table named tableName.

To Display All the Rows and Columns in a Table,type