Exam 1z0-082 topic 1 question 14 discussion

there is no valid answer here correct would be (followed by at least two characters): SELECT * FROM EMPLOYEES WHERE FIRST_NAME LIKE 'D__%'; but A is the most correct

yes, A is the correct answer

I voted A, but the true correct answer is SELECT * FROM EMPLOYEES WHERE FIRST_NAME LIKE 'D__%';

Many comments here saying that 2 underscores must be there but I think single underscore is enough because 'D_%' means that after underscore % means that there must be a character or more to display the result. Hence, A option is accurate and correct.

A is the most close to be valid answer. LIKE must be used when comparing text strings (B, D are incorrect), metacharacter % must be used to accept strings of variable length (C is incorrect), metacharacter _ stands for any character. Underscore _ should be doubled to fulfill the request of two additional characters that follows initial letter D, so the query should end with LIKE ‘D__%’

No correct answer here, the correct SQL query would be: SELECT * FROM EMPLOYEES WHERE FIRST_NAME LIKE 'D__%'; Notice there 2 underscores;