dncateduwebapps assessment/takeltakeisp?course assess 139853-1&course; id 352197

Question

dncateduwebapps assessment/takeltakeisp?course assess 139853-1&course; id 3521977 1 &content; ida 2736314 18question nu or by getting them from another browser. Import your favorites Question Completion Status Question 6 10 points Save Answer The relation Roaib may have duplicate tuples. Which of the following queries has a result that is guaranteed not to have duplicates, regardless of what tuples Rcontains? O a SELECT FROM R WHERE a b; O b. SELECT b FROM R WHERE a IN (SELECT b FROM R O c. SELECT a, COUNT() FROM R GROUP BY a; O d. SELECT AVG(a) FROM R GROUP BY 0 912 PM

Explanation / Answer

Answer 6: c

Explaination: GROUP BY returns one records for each group, hence, all the rows will have distinct values of a always.

Query will give number of repeating rows for a value of "a"

Answer 8: b (B, COUNT(C))

Explaination: Terms which are to appear in SELECT clause when a group by clause is present should be either part of group by clause or should be present in a aggregation function

Answer 9: a

Explaination:

Result of Inner JOIN:

Result set:

Answer 10: c

Sub query result:

Result set:

x y x y 1 2 2 3 1 2 2 3 2 3 3 4 2 3 3 4 3 4 4 1 3 4 4 1 3 4 4 1 3 4 4 2 3 4 4 1 3 4 4 1 3 4 4 1 3 4 4 2 4 1 1 2 4 1 1 2 4 1 1 2 4 1 1 2 4 1 1 2 4 1 1 2 4 2 2 3

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

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