What does the following command do? DELETE FROM Employees WHERE EmpID = 1;

Deletes the record where EmpID is 1.

Deletes the number 1 from the EmpID field.

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

Match the following SQL term with a description - SELECT

The field and order used to sort the results

Match the following SQL term with a description - WHERE

The field and order used to sort the results

Match the following SQL term with a description - ORDER BY

The field and order used to sort the results

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%’

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’

The UPDATE SQL clause can _____________

update more than one row at a time

delete more than one row at a time

What is the FROM statement used for?

It is used to specify which table to select data from.

It is used to select a database

What would this SQL query display? SQL * FROM Pupils

It would display all records from the Pupils table.

It would display pupils who have a * in their name.

It would not display any pupils.

To count all records of the table named PRODUCTS (fields: name and price) use the command:

SELECT COUNT(*) AS num FROM TOWARY

SELECT DISTINCT name AS ile FROM TOWARY

SELECT SUM(*) AS num FROM TOWARY

syntax to create a table called students with parameters name, surname, email

create table student ( name varchar(50), surname varchar(50), email varchar(50) );

Create table student ( name int(50), surname varchar(50), email varchar(50) );

Create table student ( name float(50), surname varchar(50), email varchar(50) );

create table students ( name varchar(50), surname varchar(50), email varchar(50) );

Relational Databases

Authored by George Dong

Computers

12th Grade

Used 3+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

47 questions

Show all answers

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does SQL stand for?

Sequal Query Language

Structured Quotes Language

Structured Query Language

Sequential Query Language

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is NOT a command for modifying data in a database?

INSERT

UPDATE

ADD

DELETE

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

SQL can be used to retrieve data from the database. It completes this action through the use of the ______ command.

ADD

INTO

SELECT

CHECK

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What command do we use to give access privileges to a user?

CREATE

UPDATE

INSERT

GRANT

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The database would be more secure if every user was given user admin access.

True

False

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The commands to check database integrity and backup data are often unique to each different database management system.

True

False

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

With the following command:

1. UPDATE Employees
2. SET LastName = 'Thompson', City= 'Swindon'
3. WHERE EmpID = 1;

What is the purpose of line 3?

Identifies the database you wish to update.

Identifies the table you wish to update.

Identifies the field you wish to update.

Identifies the record you wish to update.

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

50 questions

Computer Components

Quiz

•

9th - 12th Grade

50 questions

Digital Media II Final Study Guide

Quiz

•

9th - 12th Grade

50 questions

kuis Jaringan Internet

Quiz

•

9th Grade - University

50 questions

Computer Science Multiple Choice Review

Quiz

•

9th - 12th Grade

42 questions

IT Fun 1.0 Concepts and Terms

Quiz

•

11th - 12th Grade

50 questions

PHOTOSHOP INTRO

Quiz

•

9th - 12th Grade

45 questions

Skills for Real World Survival

Quiz

•

9th - 12th Grade

45 questions

Cybersecurity Quiz

Quiz

•

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

Relational Databases

What does SQL stand for?

Which of the following is NOT a command for modifying data in a database?

SQL can be used to retrieve data from the database. It completes this action through the use of the ______ command.

What command do we use to give access privileges to a user?

The database would be more secure if every user was given user admin access.

The commands to check database integrity and backup data are often unique to each different database management system.

With the following command:1. UPDATE Employees2. SET LastName = 'Thompson', City= 'Swindon' 3. WHERE EmpID = 1; What is the purpose of line 3?

What does the following command do?DELETE FROM Employees WHERE EmpID = 1;

All databases require you to understand SQL.

Which of the following is NOT a command for modifying data in a database?

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers

With the following command:

1. UPDATE Employees
2. SET LastName = 'Thompson', City= 'Swindon'
3. WHERE EmpID = 1;

What is the purpose of line 3?

What does the following command do?

DELETE FROM Employees
WHERE EmpID = 1;