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

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

这篇关于1z0-071 Oracle Database 12c SQL 第8题 正则表达式的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！

---