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')

With SQL, how do you select all the records from a table named “Persons” where the value of the column “FirstName” ends with an “a”?

SELECT * FROM Persons WHERE FirstName LIKE ‘%a’

SELECT * FROM Persons WHERE FirstName=’a’

SELECT * FROM Persons WHERE FirstName LIKE ‘a%’

SELECT * FROM Persons WHERE FirstName=’%a%’

What does the ALTER TABLE clause do?

The SQL ALTER TABLE clause modifies a table definition by altering, adding, or deleting table columns and/or constraints

The SQL ALTER TABLE clause is used to insert data into database table

THE SQL ALTER TABLE deletes data from database table

The SQL ALTER TABLE clause is used to delete a database table

The UPDATE SQL clause can _____________

update more than one row at a time

delete more than one row at a time

SQL query to find all the cities whose humidity is 95.

SELECT city FROM weather WHERE humidity = 95

SELECT city WHERE humidity = 95

SELECT humidity = 89 FROM weather

Find the name of those cities with temperature and condition whose condition is either sunny or cloudy but temperature must be greater than 70.

SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ OR condition = ‘cloudy’ AND temperature > 70

SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ AND condition = ‘cloudy’ OR temperature > 70

SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ OR condition = ‘cloudy’ OR temperature > 70

SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ AND condition = ‘cloudy’ AND temperature > 70

'x OR y' returns a value from a database...

if either x or y, or both x and y are true.

Q3. What is the output of the following SQL statement? SELECT Emp.Emp_ID, Fname, LName, SSN FROM Emp e, EmpConf c WHERE e.Emp_ID = c.Emp_ID

Error - if aliasing is used, it must be used throughout

A list of all 20 employee IDs, names and SSNs

A list of only 10 employee IDs, names and SSNs

Error - tables EMP and EMPCONF have nothing in common

SQL

Quiz

•

Computers

•

University

•

Practice Problem

•

Hard

•

CCSS

RI.9-10.4, RI.11-12.4, RI.7.4

+1

Standards-aligned

MR. BSSS

Used 27+ times

FREE Resource

35 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

1 min • 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

3.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

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

Where

Order by

From

Select

4.

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

Or

Where

5.

MULTIPLE CHOICE QUESTION

45 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

If

Or

6.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

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

Remove

Cancel

Delete

Eradicate

7.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

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

Add To

Update To

Add Into

Insert Into

Create a free account and access millions of resources

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

38 questions

U6 Vocab

Quiz

•

University

32 questions

KIỂM TRA 45P- MS WORD

Quiz

•

University

39 questions

Eng-103 Vocab 4

Quiz

•

University

40 questions

CompTIA Security+ SY0-601 Chapters 9 - 12

Quiz

•

University

38 questions

ITE 292 NETWORKING 1 P2 EXAM

Quiz

•

University

36 questions

6° Semestre

Quiz

•

University

31 questions

CS-PRACTICE

Quiz

•

University

40 questions

QUIZ RPL

Quiz

•

University

Popular Resources on Wayground

5 questions

This is not a...winter edition (Drawing game)

Quiz

•

1st - 5th Grade

15 questions

4:3 Model Multiplication of Decimals by Whole Numbers

Quiz

•

5th Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

10 questions

The Best Christmas Pageant Ever Chapters 1 & 2

Quiz

•

4th Grade

12 questions

Unit 4 Review Day

Quiz

•

3rd Grade

10 questions

Identify Iconic Christmas Movie Scenes

Interactive video

•

6th - 10th Grade

20 questions

Christmas Trivia

Quiz

•

6th - 8th Grade

18 questions

Kids Christmas Trivia

Quiz

•

KG - 5th Grade

Discover more resources for Computers

26 questions

Christmas Movie Trivia

Lesson

•

8th Grade - Professio...

7 questions

Different Types of Energy

Interactive video

•

4th Grade - University

20 questions

Slopes and Slope-Intercept Form

Quiz

•

8th Grade - University

7 questions

Force and Motion

Interactive video

•

4th Grade - University

7 questions

Biomolecules (Updated)

Interactive video

•

11th Grade - University

20 questions

Winter/Holiday Trivia

Quiz

•

KG - University

10 questions

WINTER WIN Time - ELA - 12/9/2025

Quiz

•

KG - University

7 questions

Human Impact on Resources

Interactive video

•

4th Grade - University

SQL

35 questions

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?

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?

Which word is missing from the following SQL statement?

Select * table_name

Create a free account and access millions of resources

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers

SQL

35 questions

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?

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?

Which word is missing from the following SQL statement?Select * table_name

Create a free account and access millions of resources

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers

Which word is missing from the following SQL statement?

Select * table_name