Examine the structure of the MEMBERS table:
Name Null? Type
—————- —————– —————————
MEMBER_ID NOT NULL VARCHAR2 (6)
FIRST_NAME VARCHAR2 (50)
LAST_NAME NOT NULL VARCHAR2 (50)
ADDRESS VARCHAR2 (50)
CITY VARCHAR2 (25)
STATE VARCHAR2 (3)
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?
A.
SELECT * FROM MEMBERS WHERE state LIKE ‘%A_’;
B.
SELECT * FROM MEMBERS WHERE state LIKE ‘A_’;
C.
SELECT * FROM MEMBERS WHERE state LIKE ‘A_%’;
D.
SELECT * FROM MEMBERS WHERE state LIKE ‘A%’;