Match the following terms to their descriptions: Can run independently from the

Question

Match the following terms to their descriptions:

Can run independently from the outer query

Evaluates as true when the subquery returns a matching value

Evaluates as true when the target contains no data

Refers to values from the outer query

Evaluates as true when the subquery returns at least one row

EXISTS

Uncorrelated subquery

IN

Correlated subquery

IS NULL

If value is NULL, checkmark the boxes for all statements which should resolve as true:

ISNULL(value,0) = ISNULL(value,0)

value= ISNULL(value,1)

value = value

value >= -1

ISNULL(value,'X') = 'X'

Can run independently from the outer query

Evaluates as true when the subquery returns a matching value

Evaluates as true when the target contains no data

Refers to values from the outer query

Evaluates as true when the subquery returns at least one row

1.

EXISTS

2.

Uncorrelated subquery

3.

IN

4.

Correlated subquery

5.

IS NULL

Explanation / Answer

Please find my answer:

Can run independently from the outer query => 2.   Uncorrelated subquery

Evaluates as true when the subquery returns a matching value => 1.EXISTS

Evaluates as true when the target contains no data => 5. IS NULL

Refers to values from the outer query => 4.   Correlated subquery

Evaluates as true when the subquery returns at least one row => 3. IN

ISNULL(value,0) = ISNULL(value,0) => null = null => true
   
value= ISNULL(value,1) => null = null => true
   
value = value => null = null => true
   
value >= -1 => null compared with any result in null => false
   
ISNULL(value,'X') = 'X' => false

Related Questions

Navigate

• Browse (All)
• Browse M
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.