SQL Fundamentals

Front

What is your mood today?

Back

Happy, Motivated, Optimistic, Relaxed, Stressed

Front

Which SQL clause is used to filter rows based on a specified condition?

Back

WHERE

Front

Which SQL clause is used to retrieve unique values from a column?

Back

DISTINCT

Front

Which of the following SQL operators are used for logical conjunction? OR, AND, NOT, XOR

Back

AND

Front

The GROUP BY clause is used to filter rows based on a specified condition

Back

False

Front

The BETWEEN operator is used to retrieve values within a specified range, inclusive of the boundary values.

Back

True

Front

Which SQL clause is used to group rows that have the same values into summary rows?

Back

GROUP BY

Front

Which of the following SQL clauses are used for filtering rows based on multiple conditions? OR, NOT, IN, DISTINCT

Back

OR

Front

The SQL keyword ______ is used to select only unique values.

Back

DISTINCT

Front

The IN operator is used to specify a range of values for a column

Back

False