【OCP 071】最新OCP 12c題庫考試原題(36題)
最新學訊:近期OCP認證正在報名中,因考試人員較多請盡快報名獲取最近考試時間,報名費用請聯系在線老師,甲骨文官方認證,報名從速!
我要咨詢2018年OCP 11g考試原題解析已經講解30多次課,500多道考試原題,最終達到98%以上的考題覆蓋度及95%以上的考試通過率。
2019年OCP 11g將升級到12c,OCP 12c考試解析免費公開課也已經開始了,歡迎大家收看!
OCP解析公開課時間:【每周五晚8點】
OCP解析公開課地址:http://ke.qq.com/course/326223
OCP解析群資料分享:1015267481 驗證:ocp
另外,除了OCP公開課,OCM題庫直播也同步進行中,OCM最新題庫大爆料-【每周四晚8點】,【微信群直播】,可以聯系咨詢老師進群參與
-------------------------------------------------------
36、(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 也是可以達到要求,但是不是最好的答案)