Sql DML Statement Set 1

Which of the following are DML statements ?

DROP

LOCK TABLE

MERGE

UPDATE

What is the correct form of select all record from Emp table ?

SELECT * FROM Table Emp;

SELECT * FROM Emp;

SELECT * FROM Emp Table;

All of above

If we want to select ' Salary ' from emp table , which should be display as Sal, what is the correct statement ?

SELECT Rename Salary to Sal FROM emp;

SELECT Salary to Sal FROM emp;

SELECT Salary AS Sal FROM emp;

All the above

Which one is correct statement to get the number of record in emp ?

SELECT count(*) FROM emp;

SELECT * FROM Emp;

SELECT count(All) FROM emp;

All of above

Select * from Emp, Dept ;

Is it possible to select records of both table like this?

yes

Emp table is having three column Ename,Eno and Age.

Which are the correct insert statements to insert value ?

INSERT INTO Emp (Ename,Eno,Age)VALUES('Alex',12,23);

INSERT INTO Emp (Ename,Eno,Age)VALUES("Alex",12,23);

INSERT INTO Emp VALUES('Alex',12,23);

INSERT INTO Emp VALUES("Alex",12,23);

Inserted value of a table can be roll back .

yes

Can we insert multiple values to a table at a time ?

yes

Which of the following is correct update statement ?

UPDATE Customers SET CustmerName='Aled' Where empNo=10;

UPDATE table Customers SET CustmerName='Aled' Where empNo=10;

UPDATE Customers table SET CustmerName='Aled' Where empNo=10;

UPDATE Customers SET CustmerName='Aled' as empNo=10;

Can we update more than one table value at a single time ?

yes