Intro to Transformation

What does SQL stand for?

• Sequential Query Language
• Structured Query Language
• Standard Query Log
• System Queue Logic

SQL is used to manage and query relational databases.

• True
• False

The command to retrieve data from a table is (a)   .

Which clause is used to remove duplicates in a query?

• FILTER
• DISTINCT
• GROUP BY
• ORDER BY

Which SQL keyword limits the number of rows returned?

• TOP
• FIRST
• LIMIT
• MAX

To filter results by a condition, use the (a)   clause.

What keyword do you use to rename a column in the output?

• CHANGE
• LABEL
• RENAME
• AS

Which clause is used to sort results in SQL?

• FILTER
• ORDER BY
• GROUP BY
• SELECT

The SELECT clause can reference a column using its index position.

• True
• False

The function COUNT() returns the number of (a)   .