Sql DML Statement Set 2

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

true

false

Which of the following is not a DML statement ?

EXPLAIN PLAN

CALL

LOCK TABLE

MERGE

Non of above

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

DELETE

CALL

EXPLAIN PLAN

NON OF ABOVE

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

SELECT sal / 12 FROM Emp

SELECT sal / 12 AS monthly_salary FROM Emp

SELECT (sal / 12) AS monthly_salary FROM emp

All the Above

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

select Empno ,Eeptno from Emp, Dept ;

select Empno ,Eeptno from Emp e, Dept d ;

select emp.Empno ,dept.Eeptno from Emp, Dept ;

select e.Empno ,d.Eeptno from Emp e, Dept d ;

Can we update more than one value using update statement ?

yes

If we'll write like this

UPDATE Customers SET CustmerName='Rocky ;

What'll happen ?

This is wrong statement

All the customer name will convert to Rocky

Only first record will change

Nothing will happen

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

Delete from Emp;

Delete all from Emp;

Delete * from Emp;

Non of these

Delete from emp , Dept ; Is it correct?

yes