Based on the following table, the query that gets the names and complete mailing addresses of all customers is ____________________.
Customer table

A)SELECT * FROM Customer
B)SELECT Name, Address, City, State, Zip INTO Customer
C)SELECT FROM Customer FIELDS Name, Address, City, State, Zip
D)SELECT Name, Address, City, State, Zip FROM Customer

Question

Based on the following table, the query that gets the names and complete mailing addresses of all customers is ____________________.
Customer table
  
A)SELECT * FROM Customer 
B)SELECT Name, Address, City, State, Zip INTO Customer 
C)SELECT FROM Customer FIELDS Name, Address, City, State, Zip 
D)SELECT Name, Address, City, State, Zip FROM Customer

Quizplus · Accepted Answer

The query should select the specific fields (Name, Address, City, State, Zip) from the Customer table, which is done in option D. Option A selects all fields, which may include unnecessary or sensitive information. Option B uses the INTO keyword, which is used to create a new table, not to query an existing one. Option C uses the FIELDS keyword, which is not a valid SQL keyword.

Based on the Following Table, the Query That Gets the Names