Suppose relation R(a,b,c) has the following tuples: (1,1,3), (1,2,3), (2,1,4), (2,3,5), (2,4,1), (3,2,4), and (3,3,6). Determine the result of the following query: SELECT V.d, SUM(V.c) FROM (SELECT a+b AS d, R.c GROUP BY V.d HAVING COUNT(*) <> 1; Which of the following tuples is in the result set? O a. (3, 12) O b. (3,6) FROM R)AS V O c. (5, 7) O d. (6, 7)

Let R be a relation on A = {0, 1, 6, 8} and R = {(0,0), (8, 6), (6, 6), (8, 8), (1, 1), (1,0), (0, 1)}. Are the following statements true or false? 1. R is symmetric ? ? ? ? ? ? V V 2. R is transitive 3. R is reflexive 4. R is an equivalence relation 5. R is anti-symmetric 6. R is a partial order

Relation R has schema R(a,b,c). In the result of the query SELECT a, b, c FROM R ORDER BY DESC, b ASC What condition must a tuple t satisfy so that i necessarily precedes the tuple (5,5,5)? Identify one such tuple from the list below. O a. (8, 6, 5) O b. (5, 5, 6) O c. (7, 5, 5) O d. (0, 9, 5)

3