How many types of basic logical operators are used in SQL?
a) one
b) two
c) three
d) four
Explanation: AND, OR NOT
Which of the following operator is used for search in a column?
a) IN operator
b) LIKE operator
c) IS NULL operator
d) none of these
Which of the following operator is used to test null value?
a) IN operator
b) LIKE operator
c) IS NULL operator
d) none of these
How many types of joins?
a) one
b) two
c) three
d) four
Explanation: simple join, self-join, outer join
Which join tables are joined with itself?
a) simple join
b) self-join
c) outer join
d) none of these
How many types of sub queries?
a) one
b) two
c) three
d) four
Explanation: single-row subquery, multiple-row subquery
