Consider the below EMP table data:

EMPNO ENAME JOB SAL COMM
------ ------------------------------ --------------- ---------- ----------
7369 Smith Clerk 800 NULL
7499 Allen Salesman 1600 300
7521 Ward Salesman 1250 500
7654 Martin Salesman 1250 1400
7844 Turner Salesman 1500 0
7876 Adams Clerk 1100 NULL
7934 Miller Clerk 1300 NULL

What will be the OUTPUT of the below query?

SQL> DELETE FROM EMP WHERE SAL>1500 OR COMM IS NULL;

4 rows will be deleted
Delete all the rows
3 rows will be deleted
Error in the query
Verified Answer
Correct Option - a

To get all Infosys Certified L1 Junior Mainframe Programmer Exam questions Join Group https://bit.ly/infy_premium_group

We're passionate about offering best placement materials and courses!! A one stop place for Placement Materials. We daily post Offcampus updates and Placement Materials.

Qtr No. 213, New Town Yehlanka Indore 454775

admin@prepflix.in