Question Practice

If you want to obtain a list of employees not in departments D01 or D02, which SQL statement would you use?

Attempt the question, check the explanation, and continue with similar questions to build confidence before exams.

MCQ_SA

Single Answer MCQ

Q-00067015

SELECT * FROM EMPLOYEE WHERE DeptId = 'D01' OR DeptId = 'D02';

SELECT * FROM EMPLOYEE WHERE DeptId NOT IN ('D01', 'D02');

SELECT * FROM EMPLOYEE WHERE DeptId != 'D01' AND DeptId != 'D02';

SELECT * FROM EMPLOYEE WHERE DeptId IN ('D01', 'D02');

Video Explanation

Watch Video Solution

Keep Practising

Students who asked this also explored

Continue with nearby questions to strengthen the same chapter concept while you still have the context fresh in mind.

Q1.

What does SQL stand for?

Q2.

Which of the following is a relational database management system?

Q3.

In SQL, which command is used to extract data from a database?

Q4.

What is the purpose of the WHERE clause in SQL?