Free LPI 102-500 Actual Exam Questions - Question 3 Discussion

Probably C. The commas are necessary to separate columns, and no parentheses are used in standard SELECT syntax. D is missing the comma, so it can’t be correct.

A/B are wrong because of parentheses usage, which isn’t valid here. Between C and D, D is missing the comma, so C’s the cleanest and most standard choice.

D misses commas, so it can’t be right; C is the only one with proper syntax.

No parentheses needed, so it’s definitely C.

C, parentheses aren’t used around column names in SELECT.

Probably C. The columns need to be separated by commas without parentheses, so C fits standard SQL syntax without any extra symbols.

Yeah, parentheses are definitely off here. The right syntax separates columns with commas without parentheses, so C fits perfectly.

C makes the most sense—no parentheses, correct commas between columns.

C, the only one without parentheses or missing commas.

Probably D is wrong because it’s missing the comma, which definitely separates the columns. A and B are off with the parentheses—they’re not supposed to be there around column names in a simple SELECT statement. C just lists the columns separated by a comma without extra symbols, which is standard SQL syntax. So C makes the most sense for selecting those fields from the table.

Option C, because it uses proper comma separation without extra symbols.

The main issue here is the syntax for listing columns. Options A and B use parentheses incorrectly, and D misses the comma, which is needed to separate column names. So, C is the only one that correctly lists the columns with a comma and no parentheses, which matches standard SQL syntax.

C imo. The main thing here is that columns must be separated by commas without parentheses. A and B have weird parentheses that don’t work, and D just runs the names together without any separator, which isn’t valid SQL syntax. So C fits the standard format perfectly.

C. The comma between the column names is key here. Without it, like in D, SQL will throw an error since it won’t recognize two separate fields. The parentheses in A and B are also incorrect; SQL doesn’t wrap the column list in parentheses for SELECT statements. As for quotes, typically you only need those if the column names have spaces or reserved words, which doesn’t seem to be the case here. So C is the cleanest and most standard option.

It’s C for sure. In SQL, when selecting multiple columns, you list them separated by commas without parentheses. Options A and B use parentheses incorrectly, and D misses the comma altogether, which would cause a syntax error. I don’t think the question’s trying to trick us with aliases or case sensitivity here—just the basic SELECT syntax.

It’s C since commas separate columns, and parentheses aren’t used there.

Yeah, C is the only one with correct syntax for listing multiple columns. Parentheses in A and B are definitely not right here, so those can be ruled out easily.

Guessing C here too, since parentheses are for functions or subqueries, not for listing columns. The comma is needed to separate the fields, so D is out.

C, because commas separate fields and no parentheses are used in SELECT syntax.

Option C looks right since fields are separated by a comma, no parentheses needed.