Question

Which of the following multi-row operators can be used with a sub-query?

Answer 1

Operators which can be used with multiple-row subqueries are IN, ALL, ANY, and EXISTS.

Answer 2

Complete question:

Which of the following operators cannot be used in a sub-query?

1. AND

2. <

3. >

4. <>

Answer:

The correct answer is option 1. AND.

Explanation:

• Single-row operators include =, >, <, >=, <=, and <>.
• Multi-row operators are used with multiple-row subqueries include IN, ALL, ANY, and EXISTS.
• Hence, the correct answer among all the options is option 1. AND.

(#SPJ3)