What will be the output of the following MySQL statement?
SELECT emp_id, fname, lname
FROM employee
WHERE LEFT (fname, 1) =’F’ OR LEFT (lname, 1) =’F’;
SELECT emp_id, fname, lname
FROM employee
WHERE LEFT (fname, 1) =’F’ OR LEFT (lname, 1) =’F’;
A. Only those employees are selected whose first name and last name started with 'F'
B. Only those employees are selected whose first name started with 'F' but last name can be starts with any other letter
C. Only those employees are selected whose first name and last name started with any other letter except 'F'
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