Directions (Q96–100): Consider the relations X(S, Si, C) and Y(S, P, D):
| X | ||
|---|---|---|
| S | Si | C |
| J | 1 | M |
| B | 2 | N |
| R | 3 | H |
| T | 4 | G |
| Y | ||
|---|---|---|
| S | P | D |
| J | S1 | CA |
| B | P1 | AB |
| R | D1 | DC |
| A | H1 | MD |
The number of tuples obtained by applying a right outer join on relations X and Y is:
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) + 1 unmatched Y tuple (A) = 4.More Database Management Systems questions
- The number of tuples obtained by applying the Cartesian product over X and Y is:
- The total cost of retrieving records in sorted order using an unclustered B+ tree is (P = average number of records per data page, N = numb…
- Let R(A, B, C, D) be a relational schema with functional dependencies A → B, B → C, C → D and D → B. The decomposition of R into (A, B), (B…
- Consider the following statements: A. A database design is in BCNF if each member of the set of relation schemas that constitutes the desig…
- Which of the following scenarios may lead to an irrecoverable error in a database system?
- Let R(A, B, C, D, E, F) be a relational schema with the functional dependencies C → F, E → A, EC → D, A → B. Which of the following is a ke…