Adobe
9A0-127 · Question #19
Your application accesses a table named users to retrieve data. The users table has three columns: id of type int, name of type string, and email of type string. Which SQL statement retrieves the…
The correct answer is C. SELECT * FROM users WHERE id = 3. See the full explanation below for the reasoning.
Question
Your application accesses a table named users to retrieve data. The users table has three columns: id of type int, name of type string, and email of type string. Which SQL statement retrieves the user with an ID value of 3?
Options
- ASELECT * FROM users WHERE id = '3'
- BSELECT * FROM users WHERE ids = 3
- CSELECT * FROM users WHERE id = 3
- DSELECT * FROM users WHICH id = 3
How the community answered
(43 responses)- A9% (4)
- B2% (1)
- C74% (32)
- D14% (6)
Community Discussion
No community discussion yet for this question.