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
相关文章
- 12-19【OCP-12c】CUUG最新考试原题整理及答案(071-11)
- 12-19【OCP-12c】CUUG 071题库考试原题及答案解析(13)
- 12-19【OCP-12c】CUUG 071题库考试原题及答案解析(14)
- 12-19【OCP-12c】CUUG 071题库考试原题及答案解析(14)
- 12-19【OCP-12c】CUUG 071题库考试原题及答案解析(21)
- 12-19【12c OCP】最新CUUG OCP-071考试题库(50题)
- 12-19【OCP-12c】CUUG 071题库考试原题及答案解析(22)
- 12-19【OCP认证12c题库】CUUG 071题库考试原题及答案(28)
- 12-19【OCP-12c】CUUG 071题库考试原题及答案解析(22)
- 12-19【OCP-12c】CUUG 071题库考试原题及答案解析(18)