Test Index

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

Question : 28

Total: 50

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:

Prev Question

Next Question