Oracle Discussions

Exam 1z0-071 All Questions

View all questions & answers for the 1z0-071 exam

Go to Exam

Exam 1z0-071 topic 1 question 112 discussion

Actual exam question from Oracle's 1z0-071

Question #: 112
Topic #: 1

[All 1z0-071 Questions]

Examine the description of the CUSTOMERS table:

Which two SELECT statements will return these results: (Choose two.)

A. SELECT customer_name FROM customers WHERE UPPER(customer_name) LIKE ‘MA*’;
B. SELECT customer_name FROM customers WHERE customer_name = ‘*Ma*’;
C. SELECT customer_name FROM customers WHERE customer_name LIKE ‘Ma*’;
D. SELECT customer_name FROM customers WHERE UPPER(customer_name) LIKE ‘MA%’;
E. SELECT customer_name FROM customers WHERE customer_name LIKE ‘%a%’;
F. SELECT customer_name FROM customers WHERE customer_name LIKE ‘Ma%’;
G. SELECT customer_name FROM customers WHERE customer_name LIKE ‘*Ma*’;

Show Suggested Answer

Suggested Answer: EF 🗳️

by cadcadley at Jan. 12, 2023, 12:11 a.m.

Comments

Submit Cancel

826cb95

1 month, 2 weeks ago

Selected Answer: F

F -for sure C - is second closest if it was customer_name LIKE 'Ma%' but not when it is 'Ma*' as shown

upvoted 1 times

...

yaya32

11 months ago

Selected Answer: EF

EF is correct

upvoted 1 times

...

lucemqy

1 year, 1 month ago

Selected Answer: EF

EF since like is case sensitive

upvoted 1 times

...

Sangiii

1 year, 3 months ago

EF is correct

upvoted 2 times

...

Orxan_H

1 year, 6 months ago

EF are correct

upvoted 1 times

...

CMjer

1 year, 7 months ago

Selected Answer: EF

D is false - it will return all names (checked with SQL Developer)

upvoted 2 times

...

Cecilia_Soso

1 year, 7 months ago

D and F, %a% will return all names with letter a

upvoted 1 times

...

cadcadley

1 year, 11 months ago

EF is correct

upvoted 4 times

...