Multiple choice technology databases

What are the Capabilities of SELECT Statement?

  1. Selection

  2. Projection

  3. Joining

  4. None of these
Reveal answer Fill a bubble to check yourself
A,B,C Correct answer
Explanation

The SELECT statement in SQL supports three fundamental capabilities: Selection (filtering rows with WHERE), Projection (choosing columns), and Joining (combining data from multiple tables). These are the core operations that make SELECT versatile. Option D is incorrect because all three listed capabilities are valid and fundamental to SQL queries.

Keep practicing — related questions