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

Authored by Bennies Computing

Computers

12th Grade

Used 1+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

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 Microsoft

or continue with

Facebook

Apple

Others

Already have an account?

Similar Resources on Wayground

23 questions

Basic Computer Cables and Ports

Quiz

•

9th - 12th Grade

21 questions

Visual Basic Assessment

Quiz

•

11th - 12th Grade

22 questions

AP CSP Midterm Review

Quiz

•

10th - 12th Grade

21 questions

Artificial Intelligence

Quiz

•

9th - 12th Grade

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

Popular Resources on Wayground

24 questions

PBIS-HGMS Day 10

Quiz

•

6th - 8th Grade

10 questions

HCS SCI 03 Summer School Review 3

Quiz

•

3rd Grade

11 questions

Home Scope

Quiz

•

7th - 8th Grade

15 questions

HCS SCI 05 Summer School Assessment 3 Review

Quiz

•

5th Grade

35 questions

Lufkin Road Middle School Student Handbook & Policies Assessment

Quiz

•

7th Grade

18 questions

Geo 11.3 Area of Circles and Sectors

Quiz

•

9th - 11th Grade

SQL 1

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