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

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’

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

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’);

SQL query to find the temperature in increasing order of all cities.

SELECT city, temperature FROM weather ORDER BY city

SELECT city FROM weather ORDER BY temperature

SELECT city, temperature FROM weather

SELECT city, temperature FROM weather ORDER BY temperature

Which of the queries is most likely to have produced this result?

ANSWER: SELECT id, name, year FROM movies WHERE year > 2010;

ANSWER: SELECT id, name, year FROM movies WHERE year < 2010;

ANSWER: SELECT * FROM movies WHERE year > 2010;

ANSWER: SELECT id, name, year FROM movies WHERE YEAR > 2010;

Which of the following statements will return the most records?

SELECT * FROM Gymnasts WHERE Name LIKE %i%

SELECT * FROM Gymnasts WHERE HighScore > 8.0

SELECT * FROM Gymnasts WHERE Competition LIKE R%

SELECT * FROM Gymnasts WHERE Competition LIKE %o%

SQL-ponovitev-enostavno

Authored by Kvizi FMF

Computers

University

CCSS covered

Used 5+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

35 questions

Show all answers

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

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

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

Which word is missing from the following SQL statement?

Select * table_name

With

Where

From

And

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the correct order of clauses in a SQL statement?

SELECT, FROM, ORDER BY, WHERE

SELECT, FROM, WHERE, ORDER BY

SELECT, WHERE, FROM, ORDER BY

WHERE, FROM, SELECT, 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

35 questions

PHP Quiz

Quiz

•

University

35 questions

ITD11303 DATABASE

Quiz

•

University

40 questions

OP 4 SPECIAL EXAM MIDTERM

Quiz

•

University

40 questions

REMED PASAT INFORMATIKA 2025

Quiz

•

10th Grade - University

35 questions

Midterm Exam

Quiz

•

University

31 questions

Adversarial Search and CSP Quiz

Quiz

•

University

30 questions

Examen Extraordinario Introduccion a la Computacion

Quiz

•

1st Grade - University

40 questions

PAK

Quiz

•

University

Popular Resources on Wayground

7 questions

History of Valentine's Day

Interactive video

•

4th Grade

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

15 questions

Valentine's Day Trivia

Quiz

•

3rd Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

Discover more resources for Computers

18 questions

Valentines Day Trivia

Quiz

•

3rd Grade - University

12 questions

IREAD Week 4 - Review

Quiz

•

3rd Grade - University

23 questions

Subject Verb Agreement

Quiz

•

9th Grade - University

5 questions

What is Presidents' Day?

Interactive video

•

10th Grade - University

7 questions

Renewable and Nonrenewable Resources

Interactive video

•

4th Grade - University

20 questions

Mardi Gras History

Quiz

•

6th Grade - University

10 questions

The Roaring 20's Crash Course US History

Interactive video

•

11th Grade - University

17 questions

Review9_TEACHER

Quiz

•

University

SQL-ponovitev-enostavno

Which statement is used to extract data from a database?

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

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?

Which word is missing from the following SQL statement?

Select * table_name

What is the correct order of clauses in a SQL statement?

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

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

Which query would return only the fields DesignerID and Designer?

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-ponovitev-enostavno

Which statement is used to extract data from a database?

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

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?

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

What is the correct order of clauses in a SQL statement?

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

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

Which query would return only the fields DesignerID and Designer?

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