Examice

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

Go to Exam

Question 97

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.)

WHERE INITCAP(SUBSTR(cust_name, INSTR(cust_name, ' ') + 1)) LIKE 'Mc%'

WHERE SUBSTR(cust_name, INSTR(cust_name, ' ') + 1) LIKE 'Mc%'

WHERE SUBSTR(cust_name, INSTR(cust_name, ' ') + 1 ) LIKE 'Mc%' OR 'MC%'

WHERE UPPER(SUBSTR(cust_name, INSTR(cust_name, ' ') + 1)) LIKE UPPER('MC%')

WHERE INITCAP(SUBSTR(cust_name, INSTR(cust_name, ' ’) + 1)) IN ('MC%', 'Mc%)

Correct Answer: A, D

To display the CUST_NAME values where the last name starts with 'Mc' or 'MC', the correct WHERE clauses need to account for case sensitivity. Option A ensures both variations by using the INITCAP function to normalize the case before comparing with 'Mc%'. Option D uses the UPPER function to convert the last name to uppercase, which will match any case variation of 'MC%'. These methods effectively capture the required last names. Therefore, the correct options are A and D.

Discussion

Rik92Options: AD

Tried all, AD are correct. B is incorrect as it only returns McCain and not MCEwan due to Mc and MC mismatch.

Babi265Options: AD

AD is the correct answer

dexdinh91Options: AD

AD are correct

lucemqyOptions: AD

AD is correct LIKE is case sensitive

zouveOptions: AD

AD tested 100% guarantee

NelitaOptions: AD

AD ARE CORRECT

kuffOptions: AD

AD is the answer

pmeyerOptions: AD

A and D are correct, B is wrong.

Poke90Options: AD

B is wrong

greenneemOptions: BD

B is correct. D is incorrect as it will also generate the last name starts with small letter m.

Viviana3184Options: AD

AD are correct