Vidyalelo
Database · Q62

Introduction to SQL

Programming · Database · question 62

Q62

The SQL statement: SELECT Name, COUNT(*) FROM NAME_TABLE; counts the number of name rows and displays this total in a table with a single row and a single column.

A.
True
Answer
B.
False

Answer: Option A

Solution

Answer: Option A
Solution:
The SQL statement SELECT Name, COUNT(*) FROM NAME_TABLE; counts the number of rows in the NAME_TABLE and displays this total alongside each unique Name in separate rows. The COUNT(*) function counts all rows returned by the query.

Conclusion:
The statement "The SQL statement: SELECT Name, COUNT(*) FROM NAME_TABLE; counts the number of name rows and displays this total in a table with a single row and a single column" is Option A: True. Hence, the correct answer is True.