1z0-071 Oracle Database 12c SQL 第8题 正则表达式

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开头的州内的成员的详细信息，后面紧跟着一个字符。