SQL Basics Quiz

SQL Basics Quiz

Professional Development

12 Qs

quiz-placeholder

Similar activities

OSHA (AMENDMENT) 2022

OSHA (AMENDMENT) 2022

Professional Development

10 Qs

PAYG

PAYG

Professional Development

11 Qs

Customer Relations Refresher Quiz

Customer Relations Refresher Quiz

Professional Development

12 Qs

Admin/Clerical | Pre-Training Review

Admin/Clerical | Pre-Training Review

Professional Development

15 Qs

HR Skills

HR Skills

Professional Development

10 Qs

WCF-DSE-Q7

WCF-DSE-Q7

Professional Development

10 Qs

Character Functions

Character Functions

Professional Development

10 Qs

Chapter 20: Audit of payroll and personnel cycle

Chapter 20: Audit of payroll and personnel cycle

Professional Development

15 Qs

SQL Basics Quiz

SQL Basics Quiz

Assessment

Quiz

Other

Professional Development

Easy

Created by

Harrison Kitema

Used 2+ times

FREE Resource

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;

Create a free account and access millions of resources

Create resources
Host any resource
Get auto-graded reports
or continue with
Microsoft
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?