Directions (Q96–100): Relations X(S, Si, C) with tuples (J, 1, M), (B, 2, N), (R, 3, H), (T, 4, G), and Y(S, P, D) with tuples (J, S1, CA), (B, P1, AB), (R, D1, DC), (A, H1, MD).
Number of tuples by applying right outer join on relation X and Y is/are :
Pick an option to check yourself, or open the answer below.
Show answer & explanation
Correct answer: D. 4
Explanation
3 matching tuples (J, B, R) plus Y's unmatched tuple A gives 4.
More Database Management Systems questions
- Let R(A, B, C, D) be a relational schema with dependencies A → B, B → C, C → D and D → B. The decomposition of R into (A, B), (B, C), (B, D…
- Which of the following scenario may lead to an irrecoverable error in a database system?
- Given the basic E R diagram and relational model, which of the the following is incorrect?
- Given below are two statements: Which of the following concurrency control protocol ensures both conflict serializability and freedom from…
- Let T1 transfer ₹50 from account A to account B: 1 Read(A); 2 A := A − 50; 3 Write(A); 4 Read(B); 5 B := B + 50; 6 Write(B). What is the st…
- Consider the relation Student(stuid, dept, clsroll) with FDs: FD1: stuid → dept, FD2: dept → stuid, FD3: stuid → clsroll, FD4: clsroll → st…