Oracle Database SQL 12c 1z0-071 Exam Practice Test 3

Question : 28 of 50

Marks: +1, -0

SELECT cust_first_name FROM customers WHERE INSTR(cust_first_name, ‘e’)<>0 AND SUBSTR(cust_first_name, -2, 1)=’a’;
SELECT cust_first_name FROM customers WHERE INSTR(cust_first_name, ‘e’)<>'' AND SUBSTR(cust_first_name, -2, 1)=’a’;
SELECT cust_first_name FROM customers WHERE INSTR(cust_first_name, ‘e’)IS NOT NULL AND SUBSTR(cust_first_name, 1, -2)=’a’;
SELECT cust_first_name FROM customers WHERE INSTR(cust_first_name, ‘e’)<>0 AND SUBSTR(cust_first_name, LENGTH(cust_first_name), -2)=’a’;

Go to Question: