Multiple choice technology databases

What can NOT you accomplish using a SQL SELECT statement?

  1. Creation of a new table based off of the output of SELECT statements

  2. Return information from specific columns

  3. Return information from specific rows

  4. The combination of values in different tables
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

A SELECT statement returns a result set but does not create tables by itself - creating a table requires CREATE TABLE AS SELECT (CTAS) or SELECT INTO, which are DDL statements, not pure SELECT. Options B, C, and D are all capabilities of SELECT: specifying columns in the SELECT list, filtering rows with WHERE, and combining tables with JOIN.

Keep practicing — related questions