SQL Questions and Answers – SQL In Operator

This set of SQL Multiple Choice Questions & Answers (MCQs) focuses on “SQL In Operator”.

1. Which of the following operators allows us to specify multiple values in a WHERE clause?
a) Like
b) Between
c) In
d) Range
View Answer

2. IN operator can be used as shorthand for which of the following operators?
a) Multiple OR
b) Multiple Like
c) Multiple NOT
d) Multiple Between
View Answer

3. IN operator is used with which of the following clause(s)?
a) Select
b) Where
c) Update
d) Insert
View Answer

4. Which type of arguments can be used with IN operator?
a) Character values only
b) Numeric values only
c) Date type only
d) Any data type
View Answer

5. NOT IN is not a valid operator in SQL.
a) True
b) False
View Answer

6. Which of the following is a correct syntax for IN operator?
a)

SELECT column_list
FROM TABLE_NAME
WHERE column_name IN (VALUES);

b)

SELECT column_list
FROM TABLE_NAME
WHERE column_name IN VALUES;

c)

SELECT column_list IN (VALUES)
FROM TABLE_NAME
WHERE column_name;

d)

SELECT column_list IN VALUES
FROM TABLE_NAME
WHERE column_name;

SELECT column_list FROM TABLE_NAME 
WHERE column_name IN (VALUES);

7. Any number of values can be listed in an IN operator.
a) True
b) False
View Answer

8. Which of the following statement(s) can be used in place of list of values in an IN operator?
a) Insert
b) Update
c) Select
d) Modify
View Answer

Sanfoundry Global Education & Learning Series – SQL.

To practice all areas of SQL, here is complete set of 1000+ Multiple Choice Questions and Answers.