Multiple choice technology databases

A subquery can consist of a statement located within a clause from a parent 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
B,C,D Correct answer
AI explanation

A subquery is a SELECT nested inside a clause of an outer statement, and it's commonly used to return values from specific columns, filter based on specific rows, or compare/combine values from different tables (e.g. inside a WHERE or FROM clause). Creating a brand-new table from the output of a SELECT is instead done with CREATE TABLE ... AS SELECT, which is a separate DDL operation, not what a subquery itself does.

Keep practicing — related questions