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).
The result of the operation X ⟖ (X.S = Y.S) Y (right outer join) will be:
Pick an option to check yourself, or open the answer below.
Show answer & explanation
Correct answer: B. Columns S, Si, C, P, D: (J,1,M,S1,CA), (B,2,N,P1,AB), (R,3,H,D1,DC), (A,NULL,NULL,H1,MD)
Explanation
The matching rows J, B and R are joined, and Y's unmatched row A appears with NULL in X's columns (Si, C) — option B. Option A is the left outer join.
More Database Management Systems questions
- Which of the following join is used to get all the tuples of relation X and Y with Null values of corresponding missing values?
- Number of tuples by applying right outer join on relation X and Y is/are :
- 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…