Join Expressions Quiz PDF: Questions and Answers - 227

MCQ 1131: The right outer join is symmetric to the

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

MCQ 1132: Index structures are referred to as

1. Index scans
2. Access paths
3. Nature of operation
4. Seek paths

MCQ 1133: OLAP on large amounts of data requires that data be resident in a

1. Database
2. Application
3. Process
4. Procedure

MCQ 1134: The operation result that contains all pairs of tuples from the two relations, regardless of whether their attribute values match, is said to be

1. Intersection operation
2. Cartesian Product operation
3. Union operation
4. Join operation

MCQ 1135: A join expressions using the on condition can express a richer class of join conditions than

1. Outer join
2. Inner join
3. Natural join
4. Full outer join