Multiple choice technology

_________ is a join that provides an alternative path between 2 tables. This join helps in improving the performance of a query.

  1. Shortcut Join

  2. Outer Join

  3. Inner Join

  4. Full Join
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

A Shortcut Join creates a direct alternative path between two tables, bypassing intermediate tables in the join path. This improves query performance by reducing the number of joins the database engine must execute. The other options are standard SQL join types that don't specifically provide optimized alternative routes.

Keep practicing — related questions