7/16/2021 W3Schools Quiz Results

  HTML CSS   
 Menu  Log in

SQL Quiz Results

76% Correct:

Question 1:
What does SQL stand for?

 Structured Query Language     Your answer  

Strong Question Language

Structured Question Language

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

 SELECT     Your answer  

OPEN

EXTRACT

GET

https://www.w3schools.com/quiztest/result.asp 1/13
7/16/2021 W3Schools Quiz Results

Question
 3:
HTML CSS   

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

 UPDATE     Your answer  

SAVE

SAVE AS

MODIFY

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

 DELETE     Your answer  

REMOVE

COLLAPSE

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

 INSERT INTO     Your answer  

INSERT NEW

ADD RECORD

ADD NEW

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

https://www.w3schools.com/quiztest/result.asp 2/13
7/16/2021 W3Schools Quiz Results

SELECTHTML
  FirstName FROM Persons  
CSS   Your
 answer  
 

SELECT Persons.FirstName

EXTRACT FirstName FROM Persons

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

 SELECT * FROM Persons     Your answer  

SELECT *.Persons

SELECT [all] FROM Persons

SELECT Persons

Question 8:
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'     Your answer  

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

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

SELECT * FROM Persons WHERE FirstName='Peter'     Correct answer  

Question 9:
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'     Your answer  

https://www.w3schools.com/quiztest/result.asp 3/13
7/16/2021 W3Schools Quiz Results

 SELECTHTML
 * FROM Persons
CSS WHERE FirstName='a'   

SELECT * FROM Persons WHERE FirstName LIKE 'a%'     Correct answer  

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

Question 10:
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

 True     Your answer  

False

Question 11:
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   Your answer  

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

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

Question 12:
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   Your answer  

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

https://www.w3schools.com/quiztest/result.asp 4/13
7/16/2021 W3Schools Quiz Results

 SELECTHTML
 * FROM Persons
CSS WHERE LastName>'Hansen' AND   
LastName<'Pettersen'

Question 13:
Which SQL statement is used to return only different values?

 SELECT DISTINCT     Your answer  

SELECT DIFFERENT

SELECT UNIQUE

Question 14:
Which SQL keyword is used to sort the result-set?

 ORDER BY     Your answer  

SORT

ORDER

SORT BY

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

 SELECT * FROM Persons SORT BY 'FirstName' DESC     Your answer  

SELECT * FROM Persons SORT 'FirstName' DESC

SELECT * FROM Persons ORDER BY FirstName DESC     Correct answer  

SELECT * FROM Persons ORDER FirstName DESC

https://www.w3schools.com/quiztest/result.asp 5/13
7/16/2021 W3Schools Quiz Results

  HTML CSS   
Question 16:
With SQL, how can you insert a new record into the "Persons" table?

 INSERT VALUES ('Jimmy', 'Jackson') INTO Persons     Your answer  

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

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

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

 INSERT INTO Persons (LastName) VALUES ('Olsen')     Your answer  

INSERT INTO Persons ('Olsen') INTO LastName

INSERT ('Olsen') INTO Persons (LastName)

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

 UPDATE Persons SET LastName='Hansen' INTO   Your answer  

UPDATE Persons SET LastName='Nilsen' WHERE   Correct answer  

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

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

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

https://www.w3schools.com/quiztest/result.asp 6/13
7/16/2021 W3Schools Quiz Results

DELETEHTML
  FROM Persons
CSS WHERE FirstName = 'Peter'     Your
 answer  
 

DELETE FirstName='Peter' FROM Persons

DELETE ROW FirstName='Peter' FROM Persons

Question 20:
With SQL, how can you return the number of records in the "Persons" table?

 SELECT COUNT(*) FROM Persons     Your answer  

SELECT NO(*) FROM Persons

SELECT LEN(*) FROM Persons

SELECT COLUMNS(*) FROM Persons

Question 21:
What is the most common type of join?

 INNER JOIN     Your answer  

JOINED

JOINED TABLE

INSIDE JOIN

Question 22:
Which operator is used to select values within a range?

 BETWEEN     Your answer  

RANGE

https://www.w3schools.com/quiztest/result.asp 7/13
7/16/2021 W3Schools Quiz Results

 WITHIN
 HTML CSS   

Question 23:
The NOT NULL constraint enforces a column to not accept NULL values.

 True     Your answer  

False

Question 24:
Which operator is used to search for a specified pattern in a column?

 GET     Your answer  

FROM

LIKE     Correct answer  

Question 25:
Which SQL statement is used to create a database table called 'Customers'?

 CREATE TABLE Customers     Your answer  

CREATE DATABASE TAB Customers

CREATE DATABASE TABLE Customers

CREATE DB Customers

Study SQL in our SQL Tutorial

https://www.w3schools.com/quiztest/result.asp 8/13