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.
REMOVE Last_Name= ‘Smith’ AND First_Name=’Jack’
FROM Employees
B.
DELETE Last_Name= ‘Smith’ AND First_Name=’Jack’
FROM Employees
C.
REMOVE FROM Employees
WHERE Last_Name= ‘Smith’ AND First_Name=’Jack’
D.
DELETE FROM Employees
WHERE Last_Name= ‘Smith’ AND First_Name=’Jack’