Q8. 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%’;
Correct Answer: C
题意:您想要显示所有居住在以字母A开头的州内的成员的详细信息,后面紧跟着一个字符。