Question

You query the database with this command: SELECT name FROM employee WHERE name LIKE ‘_a%’; Which names are displayed? A. names starting with "a" B. names starting with "a" or "A" C. names containing "a" as the second letter D. names containing "a" as any letter except the first

Answer 1

Answer:

C. names containing "a" as the second letter

Explanation:

When querying a database and LIKE is used then it should be noted that the query will only return results that contain certain conditions;

Also, when querying a database and _ and % are used, it means the query will only return results base on the position of the element next to _.

Take for instance, in the question above, the query ends with LIKE ‘_a%’

This means that the query will only return results that contain a at the second position.

Analyzing the full query

SELECT name ; Only information from the name column is retrieved

FROM employee ;  This specifies the name of the table

WHERE name LIKE ‘_a%’; Base on the above explanation, only fields where letter a is at the second position will be displayed

Answer 2

The correct option is C.  names containing "a" as the second letter.

The following information should be considered:

• The LIKE operator should be used for searching the specified character in the table.
• If _a% each underscore put the one character in the specific position.
• For display the matches name with the 'a' second character % matches with any no of character.

Learn more: brainly.com/question/16911495