DML Quiz

SELECT LastName, FirstName, Salary AS Sal FROM Employees;

• True

• False

SELECT * FROM Persons;

• True

• False

SELECT E_ID, Last Name sal x 12 annual salary FROM Employees;

• True

• False

SELECT Last Name, FirstName, Address FROM Persons;

• True

• False

SELECT E_id, Last Name sal x 12 annual salary x 100 FROM Employees

• True

• False

INSERT INTO LastName values (‘Hernandez’, ‘Bonzon’);

• True

• False

INSERT INTO Employees(E_ID, FirstName) Values(7, ‘Enrico’ , ‘Chavez’);

• True

• False

UPDATE Employees SET Address= ‘Manila’, Salary = 4700 Where LastName, FirstName= ‘Teddy’;

• True

• False

DELETE FROM Employees;

• True

• False

DELETE FROM Employees WHERE ID=6;

• True

• False