SQL Fundamentals

What is your mood today?

• Happy 😊

• Motivated 💼

• Optimistic 🌈

• Relaxed 😎

• Stressed 😩

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

• SELECT

• WHERE

• GROUP BY

• DISTINCT

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

• SELECT

• WHERE

• DISTINCT

• GROUP BY

Which of the following SQL operators are used for logical conjunction?

• OR

• AND

• NOT

• XOR

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

• True

• False

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

• True

• False

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

• SELECT

• WHERE

• GROUP BY

• DISTINCT

Which of the following SQL clauses are used for filtering rows based on multiple conditions?

• OR

• NOT

• IN

• DISTINCT

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

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

• True

• False