You work as a Database Administrator for Domain.com. The company uses MySQL as its
database. You have created a table named Employees in the database. The table has the
following datA.
Now, you want to remove the records of those persons whose last Name is ‘Smith’ and first name
is ‘Jack’ from the Employees table. Which of the following statements will you use to accomplish
the task?
A.
DELETE Last_Name= ‘Smith’ AND First_Name=’Jack’
FROM Employees
B.
REMOVE FROM Employees
WHERE Last_Name= ‘Smith’ AND First_Name=’Jack’
C.
REMOVE Last_Name= ‘Smith’ AND First_Name=’Jack’
FROM Employees
D.
DELETE FROM Employees
WHERE Last_Name= ‘Smith’ AND First_Name=’Jack’