Oracle
1Z0-071 · Question #52
Examine thestructureof the members table: You want to display details of all members who reside in states starting with the letter A followed by exactly one character. Which SQL statement must you…
The correct answer is B. SELECT * FROM MEMBERS WHERE state LIKE 'A_*. See the full explanation below for the reasoning.
Question
Examine thestructureof the members table:
You want to display details of all members who reside in states starting with the letter A followed by exactly one character. Which SQL statement must you execute?
Exhibit
Options
- ASELECT * FROM MEMBERS WHERE state LIKE '%A_* ;
- BSELECT * FROM MEMBERS WHERE state LIKE 'A_*;
- CSELECT * FROM MEMBERS WHERE state LIKE 'A_%';
- DSELECT * FROM MEMBERS WHERE state LIKE 'A%';
How the community answered
(64 responses)- A8% (5)
- B84% (54)
- C6% (4)
- D2% (1)
Community Discussion
No community discussion yet for this question.