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

© examsnet.com

Question : 35 of 50

Marks: +1, -0

Examine the data in the CUST_NAME column of the CUSTOMERS table:

You want to display the CUST_NAME values where the last name starts with Mc or MC.

Which two WHERE clauses give the required result? (Choose two.)

Which two WHERE clauses give the required result? (Choose two.)

WHERE SUBSTR(cust_name, INSTR(cust_name, ‘’) + 1) LIKE ‘Mc%’
WHERE INITCAP(SUBSTR(cust_name, INSTR(cust_name, ‘’) + 1)) IN (‘MC%’, ‘Mc%)
WHERE UPPER(SUBSTR(cust_name, INSTR(cust_name, ‘’) + 1)) LIKE UPPER(‘MC%’)
WHERE SUBSTR(cust_name, INSTR(cust_name, ‘’) + 1) LIKE ‘Mc%’ OR ‘MC%’
WHERE INITCAP(SUBSTR(cust_name, INSTR(cust_name, ‘’) + 1)) LIKE ‘Mc%’

Go to Question:

Advertisements