SQL DML Statement Set 3

Data manipulation language (DML) statements access and manipulate data in existing schema objects .

Which of the following is not  a DML statement ?

Which DML statements are supported in PL/SQL only when executed dynamically ?

Which are the correct statement to get monthly salary of employees from Emp table ?

Which of the following are correct statements to select Emp_Name and DeptNo from Emp and Dept table ?

Can we update more than one value using update statement ?

If we'll write like this

UPDATE Customers SET CustmerName='Rocky ; 

What'll happen ?


Which is the correct statement to delete whole records  from table ?

Delete from emp , Dept ; Is it correct?