ExamVeda
Login
Home
This question belongs to MySQL MySQL Miscellaneous
MySQL Miscellaneous
?

What will be the output of the following MySQL command?
SELECT *
FROM employee
WHERE title=’HEAD TELLER’;

Answer & Solution
Correct Answer: Option B
This question is asking about how to find specific data in a table called "employee" using a MySQL command.

Let's break down the command:

* SELECT *: This part tells MySQL to retrieve all the columns (information) from the table.
* FROM employee: This specifies the table name, "employee", where the data is stored.
* WHERE title = 'HEAD TELLER': This is a filter. It instructs MySQL to only show rows (individual records) where the column named "title" contains the specific value "HEAD TELLER".

Therefore, the correct answer is Option B: All columns but only those rows which contain 'HEAD TELLER' as a "title".

The command effectively searches the "employee" table for employees who have the job title "HEAD TELLER" and displays all the information about them.
Examveda
Question posted by Examveda
Community

Join the Discussion

No comments yet Be the first to discuss this question.