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
Q20: A good name for an Access table
Q21: Which function calculates the number of records
Q22: Based on the table description and SQL
Q23: Based on the SQL shown, which query
Q24: What SQL command do you use to
Q26: In Access SQL, which operator could you
Q27: Which query will return the number of
Q28: Based on the SQL shown, which query
Q29: Based on the SQL shown, which query
Q30: Based on the SQL shown, which query
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents