Basic SQL Queries in Snowflake: Beginner-Level Quiz

SQL queries form the backbone of any database interaction, and Snowflake is no exception. Understanding how to write and execute basic SQL queries is crucial to Snowflake's data warehousing capabilities. This beginner-level quiz covers general concepts, practical applications, code completion, and true/false questions. Test your knowledge and ensure you have a solid foundation of SQL queries in Snowflake.

1 / 20

How do you retrieve the names of employees who earn more than 60000 from the "employees" table?

SELECT name FROM employees WHERE salary < 60000

SELECT name FROM employees WHERE salary >= 60000

SELECT name FROM employees WHERE salary > 60000

SELECT name FROM employees WHERE salary != 60000

2 / 20

Which SQL command will add a new column "email" to the "employees" table?

INSERT COLUMN email INTO employees;

MODIFY TABLE employees ADD COLUMN email;

ALTER TABLE employees ADD COLUMN email VARCHAR(255);

ADD COLUMN email TO employees;

3 / 20

The UPDATE command is used to modify existing records in a table.

False

True

4 / 20

What is the purpose of the WHERE clause?

To join data

To sort data

To group data

To filter data

5 / 20

Which keyword is used to sort the result set in ascending or descending order?

SORT BY

GROUP BY

FILTER BY

ORDER BY

6 / 20

How do you remove duplicate records in the result set?

FILTER

DISTINCT

GROUP BY

UNIQUE

7 / 20

How do you retrieve the distinct departments from the "students" table?

SELECT UNIQUE department FROM students;

SELECT department FROM students;

SELECT ALL department FROM students;

SELECT DISTINCT department FROM students;

8 / 20

Fill in the blank to find all employees whose name starts with 'A':

SELECT * FROM employees WHERE name _______ 'A%';

EQUALS

MATCHES

9 / 20

What does the LIKE operator do?

Searches for a specified pattern in a column

Compares exact matches

Groups similar data

Joins two tables

10 / 20

The DROP command removes specific rows from a table.

True

False

11 / 20

Fill in the blank to get the total count of employees:

SELECT ______(*) FROM employees;

NUMBER

SUM

COUNT

TOTAL

12 / 20

Which keyword is used to combine the results of two SQL queries?

UNION

JOIN

INTERSECT

MERGE

13 / 20

Which statement correctly retrieves all records from the "employees" table?

FETCH * FROM employees

GET * FROM employees

RETRIEVE * FROM employees

SELECT * FROM employees

14 / 20

What does the SELECT statement do in Snowflake?

Updates data in a table

Deletes data from a table

Retrieves data from a table

Inserts data into a table

15 / 20

What does the HAVING clause do in Snowflake?

Specifies the join condition

Sorts the result set

Filters groups based on a condition

Limits the number of rows returned

16 / 20

How do you add a new column to an existing table?

MODIFY TABLE

ALTER TABLE

CHANGE TABLE

ADD COLUMN

17 / 20

Which SQL clause is used to remove rows from a table?

REMOVE

CLEAR

DELETE

DROP

18 / 20

Identify the error in the following SQL code:

SELECT name salary FROM employees;

Incorrect table name

Incorrect column name

Missing table alias

Missing comma between "name" and "salary"

19 / 20

Which statement updates the "salary" column in the "employees" table for employees with the job title "Manager"?

UPDATE employees SET salary = salary + 1000 WHERE job_title = 'Manager';

MODIFY

ALTER

CHANGE

UPDATE

20 / 20

The SELECT statement can only retrieve data from one table at a time.

True

False

Your score is

The average score is 0%

This beginner-level quiz will test your knowledge of basic SQL queries in Snowflake. As a new user, this quiz will help you learn the fundamental SQL commands that make Snowflake a powerful cloud data platform.

Snowflake is unique in data warehousing because it manages structured and semi-structured data with unmatched adaptability and scalability. A solid understanding of SQL queries is required to utilize its capabilities fully.

Take this quiz if you want:

to test your knowledge of Snowflake’s essential SQL commands.
practical questions that mimic real-world situations.
to develop confidence and readiness for more advanced topics.

Good luck.