What will be the output of the following query?

SELECT emp_id, fname, lname
FROM employee
WHERE LEFT (fname, 1) =’F’ OR LEFT (lname, 1) =’F’;

Question

What will be the output of the following query?

SELECT emp_id, fname, lname
FROM employee
WHERE LEFT (fname, 1) =’F’ OR LEFT (lname, 1) =’F’;

TuteeHUB · Accepted Answer

Only those employees are selected whose first name started with ‘F’ but last name can be starts with any other letter

TuteeHUB · Answer

Only those employees are selected whose first name and last name started with ‘F’

TuteeHUB · Answer

Only those employees are selected whose first name and last name started with any other letter except ‘F’

TuteeHUB · Answer

None of the mentioned

1.	What will be the output of the following query? 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» B. Only those employees are selected whose first name started with ‘F’ but last name can be starts with any other letter

Discussion