本文主要向大家介绍了Oracle数据库之【OCP-12c】CUUG 071题库考试原题及答案解析（15），通过具体的内容向大家展现，希望对大家学习Oracle数据库有所帮助。

15、（6-24）choose the best answer
Examine the structure of 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?

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_';

Answer：A
（解析：答案 B 也是可以达到要求，但是不是最好的答案）

本文由职坐标整理并发布，希望对同学们学习Oracle有所帮助，更多内容请关注职坐标数据库Oracle数据库频道！