In RDBMS, which type of Join returns all rows that satisfy the join condition ?
Pick an option to check yourself, or open the answer below.
Show answer & explanation
Correct answer: A. Inner Join
Explanation
An inner join returns exactly the row pairs that satisfy the join condition; outer joins add unmatched rows.
More Database Management Systems questions
- Consider a relation book (title, price) which contains the titles and prices of different books. Assuming that no two books have the same p…
- In a Hierachical database, a hashing function is used to locate the ________.
- Relations produced from E - R Model will always be in ________.
- Consider the following schedules involving two transactions: S₁: r₁(X); r₁(Y); r₂(X); r₂(Y); w₂(Y); w₁(X) S₂: r₁(X); r₂(X); r₂(Y); w₂(Y); r…
- For a database relation R(a, b, c, d) where the domains of a, b, c and d include only atomic values, and only the following functional depe…
- A many-to-one relationship exists from entity set r₁ to entity set r₂. If Pk(r) denotes the primary key of relation r, how is it represente…