Examice

Exam 1z0-071 All QuestionsBrowse all questions from this exam

Go to Exam

Question 112

Examine the description of the CUSTOMERS table:

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

SELECT customer_name FROM customers WHERE UPPER(customer_name) LIKE ‘MA*’;

SELECT customer_name FROM customers WHERE customer_name = ‘*Ma*’;

SELECT customer_name FROM customers WHERE customer_name LIKE ‘Ma*’;

SELECT customer_name FROM customers WHERE UPPER(customer_name) LIKE ‘MA%’;

SELECT customer_name FROM customers WHERE customer_name LIKE ‘%a%’;

SELECT customer_name FROM customers WHERE customer_name LIKE ‘Ma%’;

SELECT customer_name FROM customers WHERE customer_name LIKE ‘*Ma*’;

Correct Answer: E, F

To obtain the results showing customer names 'Mandy' and 'Mary', the SELECT statements need to correctly filter the names based on the provided criteria. The SQL LIKE operator is used to search for a specified pattern in a column. The pattern 'Ma%' will target names starting with 'Ma'. This is case-sensitive in most database implementations. Specifically, the options that will match 'Ma%' correctly and are case-sensitive are E and F. Option E uses '%a%', which will return names that contain the letter 'a' anywhere in them. Option F uses 'Ma%', which will return names that start with 'Ma'. Therefore, both options E and F will give the desired result of 'Mandy' and 'Mary'. Other options either use incorrect wildcards or do not match the specified patterns.

Discussion

cadcadleyOptions: EF

EF is correct

SangiiiOptions: EF

EF is correct

CMjerOptions: EF

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

yaya32Options: EF

EF is correct

lucemqyOptions: EF

EF since like is case sensitive

Orxan_HOptions: EF

EF are correct

Cecilia_SosoOptions: DF

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