When two inputs that we desire to pipeline into the join are not already sorted it is the                            technique.

Related MCQs

• Which are the join types in join condition:
• How many join types in join condition:
• Which join refers to join records from the write table that have no matching key in the left table are include in the result set:
• With SQL, how can you return all the records from a table named “Persons” sorted descending by “FirstName”?
• In a                    the system makes repeated requests for tuples from the operation at the top of the pipeline.
• Each operation in a demand-driven pipeline can be implemented as an          that provides the following functions: open(), next(), and close().
• Which of the following in not Outer join?
• Which of the following in not Outer join?
• Which of the join operations do not preserve non matched tuples?
• What type of join is needed when you wish to include rows that do not have matching values?