Which query would return only the fields DesignerID and Designer?

SELECT DesignerID, Designer FROM Designers

SELECT DesignerID, Name FROM Designers

SELECT DesignerID AND Designer FROM Designers

You are required to update the phone number for only the DesignerID "SMI01" in the "Designer" table. Which of these would successfully do that?

UPDATE Designer SET PhoneNo = '01224123456' WHERE DesignerID = 'SMI01'

UPDATE Designer SET PhoneNo = '01224123456'

UPDATE Designer (PhoneNo) VALUES ('01224123456')

UPDATE PhoneNo = '01224123456' FROM Designer WHERE DesignerID = 'SMI01'

With SQL how can I return all items in the Item table sorted from the lowest priced to the highest priced?

SELECT * FROM Items ORDER BY Price ASC

SELECT * FROM Items ORDER BY Price ASCENDING

SELECT * FROM Items BY Price LOWEST TO HIGHEST

SELECT * FROM Items ORDER BY Price DESC

How would you DELETE records from the Items table with a "Chair" Type?

DELETE FROM Items WHERE Type = 'Chair'

DELETE Type FROM Items WHERE Type = 'Chair'

DELETE ITEMS WHERE Type = 'Chair'

How would you display Chairs in the Items table that have a Price greater than £50.

SELECT * FROM Items WHERE Type = 'Chair' AND Price > 50

SELECT * FROM Items WHERE Type = 'Chair' OR Price < 100

SELECT * FROM Iterms WHERE Type = 'Chair' AND Price >= 50

SELECT * FROM Items WHERE Price > 50

Which SQL statement would add a record to the database?

INSERT INTO Designer VALUES ('SMI01', 'M Smith', 'mail@msmith.com', '01224123456')

INSERT VALUES ('SMI01', 'M Smith', 'mail@msmith.com', 01224123456') INTO Designer

INSERT ('SMI01', 'M Smith', 'mail@msmith.com', '01224123456') INTO Designer

INSERT Designer INTO VALUES (''SMI01', 'M Smith', 'mail@msmith.com', '01224123456')

SQL Select/Insert/Update/Delete

Authored by Mr McCormack

Computers

9th - 11th Grade

CCSS covered

Used 30+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

20 questions

Show all answers

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does "SQL" stand for?

Structured Question Language

Structured Query Language

Simple Query Language

Simple Question Language

Which statement is used to extract data from a database?

Extract

Get

Open

Select

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

If you were wanting to filter data, which clause would you use?

Where

Order by

From

Select

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Using which word allows you to specify that more than one condition must be met in a query?

Also

And

Where

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Using which word allows you to specify that only one of a series of conditions needs to be met in a query filter?

And

Maybe

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In order to amend data in a database we would use which SQL statement?

Update

Amend

Alter

Modify

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

To remove a record from a table which SQL statement would you use?

Remove

Cancel

Delete

Eradicate

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

20 questions

System and network support and management

Quiz

•

11th Grade - Professi...

17 questions

Email Lớp 6

Quiz

•

6th Grade - University

15 questions

حاسب 2

Quiz

•

10th Grade

15 questions

Cyber Security Homework 1

Quiz

•

7th - 9th Grade

20 questions

End of year quiz: Python

Quiz

•

9th Grade

20 questions

Computer Hardware(Memory Types)

Quiz

•

8th - 9th Grade

17 questions

1.8a Environmental Issues

Quiz

•

10th - 11th Grade

15 questions

J808 LO1 and LO2 planning project keywords / terms

Quiz

•

9th - 11th 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

10 questions

Exploring Digital Citizenship Essentials

Interactive video

•

6th - 10th Grade

SQL Select/Insert/Update/Delete

What does "SQL" stand for?

Which statement is used to extract data from a database?

If you were wanting to filter data, which clause would you use?

Using which word allows you to specify that more than one condition must be met in a query?

Using which word allows you to specify that only one of a series of conditions needs to be met in a query filter?

In order to amend data in a database we would use which SQL statement?

To remove a record from a table which SQL statement would you use?

Which statement allows us to add a record to a table?

Less than or equal to?

Which character returns all the data found in a table?

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers