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

Quiz

•

Computers

•

12th Grade

•

Practice Problem

•

Easy

Bennies Computing

Used 1+ times

FREE Resource

26 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

What does SQL stand for?

Standard Query Language

Sequential Query Language

Structured Query Language

Simple Query Language

2.

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

3.

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

What type of language is SQL?

Procedural

Object-oriented

Declarative

Functional

4.

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

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

True

False

5.

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

Which command is used to list fields to be displayed?

SELECT

FROM

WHERE

ORDER BY

6.

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

7.

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

22 questions

Steve Jobs

Quiz

•

6th - 12th Grade

22 questions

PowerPoint 2013

Quiz

•

9th - 12th Grade

25 questions

InDesign q1

Quiz

•

9th - 12th Grade

25 questions

Lesson 4_Advanced Motion Tweening

Quiz

•

9th - 12th Grade

23 questions

Basic Computer Cables and Ports

Quiz

•

9th - 12th Grade

21 questions

Visual Basic Assessment

Quiz

•

11th - 12th Grade

21 questions

AI history

Quiz

•

9th - 12th Grade

21 questions

Artificial Intelligence

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