Multiple choice technology databases

To retrieve data from more than one table we could use

  1. Joins

  2. Unions

  3. Nested SELECT

  4. All of the above
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

To retrieve data from multiple tables, SQL provides several mechanisms: Joins combine columns from different tables; Unions combine rows from different queries; and Nested SELECT statements query tables hierarchically. Thus, all of these methods can be used.

Keep practicing — related questions