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'

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

How can you change “Hansen” into “Nilsen” in the “LastName” column in the Persons table?

UPDATE Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’

UPDATE Persons SET LastName=’Hansen’ INTO LastName=’Nilsen’

MODIFY Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’

MODIFY Persons SET LastName=’Hansen’ INTO LastName=’Nilsen’

Find the names of these cities with temperature and condition whose condition is neither sunny nor cloudy.

SELECT city, temperature, condition FROM weather WHERE condition NOT IN (‘sunny’, ‘cloudy’)

SELECT city, temperature, condition FROM weather WHERE condition NOT BETWEEN (‘sunny’, ‘cloudy’)

SELECT city, temperature, condition FROM weather WHERE condition IN (‘sunny’, ‘cloudy’)

SELECT city, temperature, condition FROM weather WHERE condition BETWEEN (‘sunny’, ‘cloudy’);

In what order does SQL process the instructions?

SELECT - FROM - WHERE - ORDER BY

FROM - SELECT - WHERE - ORDER BY

WHERE - FROM - SELECT - ORDER BY

SELECT - FROM - ORDER By - WHERE

SQL

Authored by Vineetha Maliakal

Computers

12th Grade

CCSS covered

Used 953+ 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

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

Remove

Cancel

Delete

Eradicate

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

Add To

Update To

Add Into

Insert Into

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Less than or equal to?

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which character returns all the data found in a table?

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which word is missing from the following SQL statement?

Select * table_name

With

Where

From

And

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

0 questions

Principles of Applied Engineering

Quiz

•

0 questions

Data Structures Quiz

Quiz

•

0 questions

PLTW IED Makeup

Quiz

•

0 questions

Sr Cos Mid-term Exam Review

Quiz

•

0 questions

Digital Evidence Midterm Review

Quiz

•

0 questions

BOS End of Level State Exam Prep

Quiz

•

0 questions

Dental and General Anatomy Final Exam Review

Quiz

•

Popular Resources on Wayground

5 questions

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

Quiz

•

1st - 5th Grade

25 questions

Multiplication Facts

Quiz

•

5th 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

11 questions

How well do you know your Christmas Characters?

Lesson

•

3rd Grade

14 questions

Christmas Trivia

Quiz

•

5th Grade

20 questions

How the Grinch Stole Christmas

Quiz

•

5th Grade

Discover more resources for Computers

26 questions

Christmas Movie Trivia

Lesson

•

8th Grade - Professio...

15 questions

Christmas Song Emoji Pictionary

Quiz

•

7th - 12th Grade

20 questions

Christmas Movies

Quiz

•

1st - 12th Grade

55 questions

CHS Holiday Trivia

Quiz

•

12th Grade

20 questions

Christmas Movie Trivia

Quiz

•

9th - 12th Grade

29 questions

christmas facts

Lesson

•

5th - 12th Grade

20 questions

Christmas Trivia

Quiz

•

5th - 12th Grade

20 questions

Stages of Meiosis

Quiz

•

9th - 12th Grade

SQL

What does "SQL" stand for?

Which statement is used to extract data from a database?

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

How do we select all rows for the "Designer" table?

How would we script a SQL query to select "Description" from the Item table?

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

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers

SQL

What does "SQL" stand for?

Which statement is used to extract data from a database?

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

How do we select all rows for the "Designer" table?

How would we script a SQL query to select "Description" from the Item table?

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

Access all questions and much more by creating a free account

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