1z0-071 Exam - Question 112

Question

Examine the description of the CUSTOMERS table:Which two SELECT statements will return these results: (Choose two. ).

Examice · Accepted Answer

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.

cadcadley · Answer

EF is correct

CMjer · Answer

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

Sangiii · Answer

EF is correct

Cecilia_Soso · Answer

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

Orxan_H · Answer

EF are correct

lucemqy · Answer

EF since like is case sensitive

yaya32 · Answer

EF is correct

826cb95 · Answer

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

1z0-071 Exam - Question 112

Discussion