首页 > 其他 > 详细

OCP 12c最新考试题库及答案(071-2)

时间:2019-02-12 17:14:53      阅读:85      评论:0      收藏:0      [点我收藏+]

标签:bstr   sub   you   HERE   length   output   substr   put   name   

2、(4-7) choose the best answer:
You need to display the first names of all customers from the CUSTOMERS table that contain the
character ‘e‘ and have the character ‘a‘ in the second last position.
Which query would give the required output?
A) SELECT cust_first_name
FROM customers
WHERE INSTR(cust_first_name, ‘e‘)<>‘‘ AND
SUBSTR(cust_first_name, -2, 1)=‘a‘;
B) SELECT cust_first_name
FROM customers
WHERE INSTR(cust_first_name, ‘e‘)<>0 AND
SUBSTR(cust_first_name, -2, 1)=‘a‘;
C) SELECT cust_first_name
FROM customers
WHERE INSTR(cust_first_name, ‘e‘)<>0 AND
SUBSTR(cust_first_name, LENGTH(cust_first_name),-2)=‘a‘;
D) SELECT cust_first_name
FROM customers
WHERE INSTR(cust_first_name, ‘e‘)IS NOT NULL AND
SUBSTR(cust_first_name, 1,-2)=‘a‘;
Answer:B

OCP 12c最新考试题库及答案(071-2)

标签:bstr   sub   you   HERE   length   output   substr   put   name   

原文:http://blog.51cto.com/13854012/2349482

(0)
(0)
   
举报
评论 一句话评论(0
0条  
登录后才能评论!
© 2014 bubuko.com 版权所有 鲁ICP备09046678号-4
打开技术之扣,分享程序人生!
             

鲁公网安备 37021202000002号