Search Header Logo

SQL Basics Quiz

Authored by Harrison Kitema

Other

Professional Development

Used 2+ times

SQL Basics Quiz
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

12 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

What does SQL stand for?

Structured Query Language

Simple Query Logic

Strong Question Language

Sequential Query Language

2.

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

Which command is used to retrieve data from a table?

GET

FETCH

SELECT

RETRIEVE

3.

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

Which SQL clause is used to filter records?

WHERE

GROUP BY

ORDER BY

HAVING

4.

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

What does the following query do? SELECT * FROM employees;

Updates all data in the employees table

Deletes all data from employees table

Retrieves all columns from the employees table

Creates a new employees table

5.

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

What is the purpose of the GROUP BY clause?

To delete rows in a group

To group rows that have the same values in specified columns

To order the rows by column

To rename columns in a result set

6.

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

Which query lists all employees in the "Sales" department?

SELECT * FROM employees WHERE department = 'Sales';

SELECT department FROM employees;

SELECT * FROM employees GROUP BY department;

SELECT * FROM employees WHERE salary > 50000;

7.

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

You want to count the number of employees in each department. Which query is correct?

SELECT COUNT(department) FROM employees;

SELECT department, COUNT(*) FROM employees GROUP BY department;

SELECT department FROM employees;

SELECT COUNT(*) FROM employees;

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?