Question 2 10 points Save Answ as follows: are Compute the full outer join on B,

Question

Question 2 10 points Save Answ as follows: are Compute the full outer join on B, the left outer join on B, and the right outer join on B. In each case, Ris the left operand and s is the right operand. Then, answer the following questions for each of the three results: 1. How many rows are there in the result? 2. How many NULLs appear in the result? Finally, find the correct statement in the list below. O a. The right outer join has 2 row. O b. The full outer join has 3 NULL's. O c. The right outer join has no NULL's. O d. The left outer join has 2 NULL's 3/19/20

Explanation / Answer

b) the full outer join has three null's

d) select c,d

from s

where exist (select a,b

from r

whereb exist a=c and b=d)

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

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