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).
Which of the following join is used to get all the tuples of relation X and Y with Null values of corresponding missing values?
Pick an option to check yourself, or open the answer below.
Show answer & explanation
Correct answer: D. Full outer join
Explanation
A full outer join keeps all tuples of both relations, filling missing values with NULL.
More Database Management Systems questions
- 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…
- 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…