Consider the relations shown in the exhibit. Due to restructuring, the sales department has been eliminated and the employees working in that department have been dismissed. All ID information is…

Viktor S.Jun 7, 2026

The answer is C, and the reason it beats A and D despite all three using SELECT * comes down to how you handle integer IDs in the WHERE clause or subquery. The question tells you IDs are stored as integers, so any option wrapping that value in single quotes is immediately wrong because comparing an integer column to a string literal is either an implicit type coercion mess or a flat-out mismatch depending on the DBMS. Option B eliminates itself by only returning two columns when the question explicitly asks for all information about those employees, so that one should take you about two seconds to rule out. C gets the data type right and selects every column, which is exactly what "all information" means. Stop memorizing which letter is correct and start reading what the question actually requires, because the job will ask the same questions without a multiple choice lifeline.

Mei-Ling H.Jun 26, 2026

I picked A first, but C has the correct subquery for matching integer IDs.

Ola B.Jun 16, 2026

Option A looks right until you realize you need the subquery filtering on department, so C it is.