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 也是可以达到要求,但是不是最好的答案)
【OCP-12c】CUUG 071题库考试原题及答案解析(15)
原文:http://blog.51cto.com/13854012/2351352