Join Expressions Multiple Choice Questions with Answers – PDF Download

MCQ 1: To specify a normal join, using the keyword inner is:

1. Mandatory
2. Optional
3. Independent
4. Free

MCQ 2: The join preserves tuples only in the relation named after the right outer join operation, is to be:

1. Right outer join
2. Right inner join
3. Left inner join
4. Left outer join

MCQ 3: The ON predicate is written like a:

1. From clause
2. Select clause
3. Where clause
4. Define clause

MCQ 4: To specify that a normal join is to be used, a join clause can specify inner join instead of:

1. Outer join
2. Natural join
3. Outer right join
4. Outer left join

MCQ 5: The left outer join preserves tuples only in the relation named before:

1. Right outer join operation
2. Right inner join operation
3. Left inner join operation
4. Left outer join operation