With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"?

SELECT * FROM Persons WHERE FirstName='Peter'

SELECT [all] FROM Persons WHERE FirstName='Peter'

SELECT [all] FROM Persons WHERE FirstName LIKE 'Peter'

SELECT * FROM Persons WHERE FirstName<>'Peter'

With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" starts 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%'

With SQL, how do you select all the records from a table named "Persons" where the "FirstName" is "Peter" and the "LastName" is "Jackson"?

SELECT * FROM Persons WHERE FirstName='Peter' AND LastName='Jackson'

SELECT * FROM Persons WHERE FirstName<>'Peter' AND LastName<>'Jackson'

SELECT FirstName='Peter', LastName='Jackson' FROM Persons

With SQL, how do you select all the records from a table named "Persons" where the "LastName" is alphabetically between (and including) "Hansen" and "Pettersen"?

SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pettersen'

SELECT LastName>'Hansen' AND LastName<'Pettersen' FROM Persons

SELECT * FROM Persons WHERE LastName>'Hansen' AND LastName<'Pettersen'

With SQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"?

SELECT * FROM Persons ORDER BY FirstName DESC

SELECT * FROM Persons SORT 'FirstName' DESC

SELECT * FROM Persons SORT BY 'FirstName' DESC

SELECT * FROM Persons ORDER FirstName DESC

With SQL, how can you insert a new record into the "Persons" table?

INSERT INTO Persons VALUES ('Jimmy', 'Jackson')

INSERT ('Jimmy', 'Jackson') INTO Persons

INSERT VALUES ('Jimmy', 'Jackson') INTO Persons

With SQL, how can you insert "Olsen" as the "LastName" in the "Persons" table?

INSERT INTO Persons (LastName) VALUES ('Olsen')

INSERT INTO Persons ('Olsen') INTO LastName

INSERT ('Olsen') INTO Persons (LastName)

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

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

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

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

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

With SQL, how can you delete the records where the "FirstName" is "Peter" in the Persons Table?

DELETE FROM Persons WHERE FirstName = 'Peter'

DELETE ROW FirstName='Peter' FROM Persons

DELETE FirstName='Peter' FROM Persons

SQL

Authored by FUAT CALISKAN

Computers

12th Grade

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

2 mins • 1 pt

What does SQL stand for?

Structured Query Language

Strong Question Language

Structured Question Language

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

Which SQL statement is used to extract data from a database?

SELECT

OPEN

GET

EXTRACT

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

Which SQL statement is used to update data in a database?

SAVE AS

UPDATE

MODIFY

SAVE

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

Which SQL statement is used to delete data from a database?

DELETE

COLLAPSE

REMOVE

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

Which SQL statement is used to insert new data in a database?

INSERT NEW

ADD NEW

INSERT INTO

ADD RECORD

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

With SQL, how do you select a column named "FirstName" from a table named "Persons"?

EXTRACT FirstName FROM Persons

SELECT FirstName FROM Persons

SELECT Persons.FirstName

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

With SQL, how do you select all the columns from a table named "Persons"?

SELECT Persons

SELECT * FROM Persons

SELECT *.Persons

SELECT [all] FROM Persons

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 Microsoft

or continue with

Facebook

Apple

Others

Already have an account?

Similar Resources on Wayground

20 questions

Microsoft PPT. - Scavenger Hunt

Quiz

•

6th - 12th Grade

15 questions

Introduction to MySQL

Quiz

•

11th - 12th Grade

18 questions

Programming in C language

Quiz

•

12th Grade - University

19 questions

Citation Vocabulary

Quiz

•

9th - 12th Grade

16 questions

Computer Security Risk

Quiz

•

11th Grade - University

15 questions

Grade 12-Python selection&iteration

Quiz

•

11th - 12th Grade

20 questions

Python Recap

Quiz

•

7th Grade - University

15 questions

Vocabulary of Computer

Quiz

•

12th Grade

Popular Resources on Wayground

10 questions

HCS SCI 03 Summer School Assessment 1

Quiz

•

3rd Grade

15 questions

HCS SCI 05 Summer School Assessment 1 Review

Quiz

•

5th Grade

22 questions

Day 9 Equations and Inequalities Review

Quiz

•

9th Grade

10 questions

Writing and Identifying Ratios Practice

Quiz

•

5th - 6th Grade

7 questions

PYRAMID PERSPECTIVES part 1

Presentation

•

9th - 12th Grade

12 questions

Understanding the Fourth of July

Quiz

•

9th Grade

15 questions

Soccer World Cup Quiz Questions

Quiz

•

7th Grade

Discover more resources for Computers

7 questions

PYRAMID PERSPECTIVES part 1

Presentation

•

9th - 12th Grade

SQL

What does SQL stand for?

Which SQL statement is used to extract data from a database?

Which SQL statement is used to update data in a database?

Which SQL statement is used to delete data from a database?

Which SQL statement is used to insert new data in a database?

With SQL, how do you select a column named "FirstName" from a table named "Persons"?

With SQL, how do you select all the columns from a table named "Persons"?

With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"?

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

The OR operator displays a record if ANY conditions listed are true. The AND operator displays a record if ALL of the conditions listed are true

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers