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
AnswerB.
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.