SELECT Address FROM member
WHERE FirstName = 'Bill' AND LastName = 'King';
Given the above SQL statement, which of the following statements is true?
A) Member is a record.
B) All rows in the table would be retrieved.
C) All columns in the table would be retrieved.
D) Address is a field.

Question

​SELECT Address FROM member
WHERE FirstName = 'Bill' AND LastName = 'King';
Given the above SQL statement, which of the following statements is true? ​
A) ​Member is a record.
B) ​All rows in the table would be retrieved.
C) ​All columns in the table would be retrieved.
D) ​Address is a field.

Quizplus · Accepted Answer

This SQL statement is selecting the Address field from the member table where the FirstName is 'Bill' and LastName is 'King'. This means that only the Address field will be retrieved for the specific row(s) that satisfy the FirstName and LastName conditions. The table being queried is likely a list of members or customers and each row represents a single member/customer record. Therefore, A and B are incorrect because Member is likely the name of the table, not a single record, and not all rows in the table will be retrieved. C is also incorrect because only the Address column is being retrieved, not all columns.

​SELECT Address FROM Member

SELECT Address FROM Member