大數據就業實戰培訓 Oracle就業實戰培訓
071考試題庫之前是比較穩定的,但隨著Oracle的調整,071考試不斷的增加新的考題,增加了考試的難度,所以我們專門收集整理了這些考試,并對這些考題進行解析,希望可以對考生有幫助。
每周五晚8點,我們有免費的OCP解析公開課,地址:https://ke.qq.com/course/326223 OCP題庫交流群:1015267481,驗證ocp
-------------------------------------------------------
071考試-第36題、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 也是可以達到要求,但是不是最好的答案)