How do you find all employees whose names start with 'J' in the 'Employees' table?

SELECT * FROM Employees WHERE name LIKE 'J*'

SELECT * FROM Employees WHERE name LIKE 'J%'

SELECT * FROM Employees WHERE name IN 'J'

SELECT * FROM Employees WHERE name BETWEEN 'A' AND 'J'

How would you find all orders placed in 2023 from a table named 'Orders'?

SELECT * FROM Orders WHERE order_date BETWEEN '2023-01-01' AND '2023-12-31'

SELECT * FROM Orders WHERE order_date = '2023'

SELECT * FROM Orders WHERE order_date LIKE '%2023%'

SELECT * FROM Orders WHERE order_date IN 2023

Which query retrieves customers from 'Customers' table who live in either 'New York' or 'Los Angeles'?

SELECT * FROM Customers WHERE city = 'New York' OR city = 'Los Angeles'

SELECT * FROM Customers WHERE city LIKE 'New York' AND city LIKE 'Los Angeles'

SELECT * FROM Customers WHERE city IN ('New York', 'Los Angeles')

SELECT * FROM Customers WHERE city BETWEEN 'New York' AND 'Los Angeles'

How would you join the 'Orders' table and the 'Customers' table on the customer_id field?

SELECT * FROM Orders JOIN Customers ON Orders.customer_id = Customers.customer_id

SELECT * FROM Orders, Customers WHERE Orders.customer_id = Customers.customer_id

SELECT * FROM Orders WHERE Orders.customer_id = Customers.customer_id

SQL 1

12th Grade

•

26 Qs

Similar activities

dLab Hackathon Quiz

12th Grade - Professional Development

•

22 Qs

Fetch Execute Cycle / Output Devices

10th Grade - University

•

22 Qs

Scratch

4th Grade - Professional Development

•

22 Qs

Python_12BG

11th - 12th Grade

•

21 Qs

Fun facts about video game design

4th Grade - Professional Development

•

21 Qs

Chapter 17

11th - 12th Grade

•

21 Qs

Y3 Unit 1

3rd Grade - University

•

21 Qs

2.5 The Broadband Internet Connection

12th Grade

•

22 Qs

SQL 1

Quiz

•

Computers

•

12th Grade

•

Practice Problem

•

Easy

Bennies Computing

Used 1+ times

FREE Resource

26 questions

Show all answers

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

What does SQL stand for?

Standard Query Language

Sequential Query Language

Structured Query Language

Simple Query Language

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

What is SQL primarily used for?

Designing web pages

Querying and updating tables in a relational database

Creating graphics

Managing operating systems

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

What type of language is SQL?

Procedural

Object-oriented

Declarative

Functional

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

All database software packages will generate their own SQL when using a GUI

True

False

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

Which command is used to list fields to be displayed?

SELECT

FROM

WHERE

ORDER BY

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

Which command is used to list the table or tables the data will come from?

SELECT

FROM

WHERE

ORDER BY

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

Which command is used to list search criteria?

SELECT

FROM

WHERE

ORDER BY

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Similar Resources on Wayground

25 questions

CPA Inkscape Quiz 01

Quiz

•

7th - 12th Grade

25 questions

Microsoft Word: Module 2

Quiz

•

9th - 12th Grade

24 questions

Final Cut Pro Vocabulary

Quiz

•

9th - 12th Grade

21 questions

Database Quiz 4 SQL

Quiz

•

12th Grade

21 questions

A2 DT Networks 2

Quiz

•

12th Grade

23 questions

Adobe Lightroom Review

Quiz

•

11th - 12th Grade

22 questions

1.02 Setting a PC System Vocabulary : Zack DeBenedictis

Quiz

•

9th - 12th Grade

25 questions

Unit 2 - Turtle Graphics Quiz for Python Computer Programming I

Quiz

•

9th - 12th Grade

Popular Resources on Wayground

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

15 questions

Equivalent Fractions

Quiz

•

4th Grade

20 questions

Figurative Language Review

Quiz

•

6th Grade

Discover more resources for Computers

18 questions

[AP CSP] JavaScript Programming Lesson 2025-2026

Lesson

•

9th - 12th Grade

SQL 1

26 questions

What does SQL stand for?

What is SQL primarily used for?

What type of language is SQL?

All database software packages will generate their own SQL when using a GUI

Which command is used to list fields to be displayed?

Which command is used to list the table or tables the data will come from?

Which command is used to list search criteria?

Which command is used to list fields the data should be sorted on?

Which symbol is used as a wildcard in SQL for the SELECT command?

Which symbols could be used as a wildcard in SQL for the LIKE command (depending on the software)?

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers