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 needs to select specific columns (Name, Address, City, State, and Zip) from the Customer table and display the information for all customers. Option A selects all columns, which may include unnecessary information. Option B uses the INTO keyword indicating the creation of a new table instead of displaying the information. Option C is not a valid SQL syntax. Therefore, option D is the best choice as it selects the necessary columns and displays the information for all customers.

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