Multiple Choice
Based on the table description and SQL shown, which query lists the first name and last name of all students, separated by a space?
Students (StudentID, FirstName, LastName, Street, City, State, PostalCode)
A) SELECT FirstName & LastName AS FullName FROM Students;
B) SELECT FirstName & ' ' & LastName AS FullName FROM Students;;
C) SELECT FirstName ' ' LastName AS FullName FROM Students;
D) SELECT FirstName, LastName AS FullName FROM Students;
Correct Answer:

Verified
Correct Answer:
Verified
Q10: When you use a name containing a
Q11: Based on the table description and SQL
Q12: Which of the following is currently considered
Q13: In a query that uses an aggregate
Q14: In Access SQL, which operator could you
Q16: Based on the table description and SQL
Q17: What SQL keyword do you use in
Q18: Which SQL commands do you use to
Q19: What SQL command do you use to
Q20: List five Access data types and their