Given the table
CUSTOMER(CustID,Name,PhoneNum,AcctBalance)
What is the standard SQL query phrase to retrieve the Name and Phone Number of customers?
A) SELECT CUSTOMER-Name AND CUSTOMER-PhoneNum
B) SELECT (CUSTOMER-Name AND CUSTOMER-PhoneNum)
C) SELECT Name, PhoneNum
D) SELECT (Name, PhoneNum)
E) SELECT *

Question

Quizplus · Accepted Answer

The SELECT statement is used to retrieve specific columns from a table. In this case, the question specifically asks for the Name and PhoneNum columns, so the SELECT statement should include those column names separated by a comma. Choice C is the only one that meets this requirement. The other choices either have syntax errors or attempt to combine columns in a way that is not valid.

Given the Table CUSTOMER(CustID,Name,PhoneNum,AcctBalance)