What will be the output of the following MySQL statement?
SELECT emp_id, fname, lname
FROM employee
WHERE LEFT (lname, 1) =’F’;
SELECT emp_id, fname, lname
FROM employee
WHERE LEFT (lname, 1) =’F’;
A. Only those employees are selected whose last name started with 'F'
B. Only those employees are selected whose last name started with other than 'F'
C. All of the mentioned
D. None of the mentioned
Answer: Option A
Related Questions on MySQL Miscellaneous
How is communication established with MySQL?
A. SQL
B. Network calls
C. A programming language like C++
D. APIs
Which type of database management system is MySQL?
A. Object-oriented
B. Hierarchical
C. Relational
D. Network
Join The Discussion