You need to display the last names of those employees who have the letter "A" as the second character in their names. Which SQL statement displays the required results?

The correct answer is A. SELECT last_name. Statement in this answer will show correct results because usage of operator LIKE and format mask _A%' extract the last names of those employees who have the letter "A" as the second character in their names. Symbol _' in format mask substitute exactly one symbol and cannot be…

Restricting and Sorting Data

Question

Options

ASELECT last_name
BSELECT last_name
CSELECT last_name
DSELECT last_name

How the community answered

(20 responses)

A
80% (16)
B
5% (1)
C
5% (1)
D
10% (2)

Explanation

Statement in this answer will show correct results because usage of operator LIKE and format mask _A%' extract the last names of those employees who have the letter "A" as the second character in their names. Symbol ' in format mask substitute exactly one symbol and cannot be Incorrect Answers B: This statement will return only names starting from symbol *'. It cannot be used as substitution symbol. C: Usage of equity operator here is not appropriate in this case: query will look exact for first symbol ', it will not be considered as substitution symbol. D: This statement will return only names starting from symbol `*'. It cannot be used as substitution symbol.

Topics

#LIKE operator#wildcard#pattern matching#underscore wildcard

Community Discussion

No community discussion yet for this question.

Full 1Z0-007 Practice