Exam 102-500 Topic 8 Question 233 Discussion

Actual exam question for Lpi's 102-500 exam
Question #: 233
Topic #: 8
Which of the following SQL statements will select the fields name and address from the contacts table?

Suggested Answer: C Vote an answer

The correct syntax for selecting specific columns from a table in SQL is to use the SELECT keyword followed by a comma-separated list of column names and then the FROM keyword followed by the table name. Therefore, the only option that follows this syntax is C. SELECT name, address FROM contacts; The other options are incorrect because they either use parentheses around the column names, which are not needed, or they omit the comma between the column names, which causes a syntax error. Reference: https://www.sqltutorial.org/sql-select/
https://www.w3schools.com/mysql/mysql_select.asp

by Herman at Jun 04, 2026, 02:05 AM

Limited Time Offer

15%

Off

Get Premium 102-500 Questions as Interactive Self Test Engine or PDF

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Nick name: Submit Cancel
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
0
0
0
10