999 SQL Quiz

#Edu #SQL

What does SQL stand for?

Structured Query Language
Strong Question Language
Structured Question Language

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

OPEN
GET
EXTRACT
SELECT

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

UPDATE
SAVE AS
MODIFY
SAVE

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

COLLAPSE
DELETE
REMOVE

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

INSERT INTO
INSERT NEW
ADD NEW
ADD RECORD

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

SELECT FirstName FROM Persons
EXTRACT FirstName FROM Persons
SELECT Persons.FirstName

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

SELECT `[all] FROM Persons
SELECT *.Persons
SELECT * FROM Persons
SELECT Persons

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 LIKE 'Peter' SELECT [all] FROM Persons WHERE FirstName='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 LIKE 'O/oa'
SELECT * FROM Persons WHERE FirstName='a'
SELECT * FROM Persons WHERE FirstName LIKE '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

False
True

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 * FROM Persons WHERE LastName>'Hansen' AND LastName<'Pettersen'
SELECT LastName>'Hansen' AND LastName<'Pettersen' FROM Persons

Which SQL statement is used to return only different values?

SELECT DIFFERENT
SELECT DISTINCT
SELECT UNIQUE

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

ORDER
SORT BY
SORT
ORDER BY

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

SELECT * FROM Persons SORT 'FirstName' DESC
SELECT * FROM Persons SORT BY 'FirstName' DESC
SELECT * FROM Persons ORDER BY FirstName DESC
SELECT * FROM Persons ORDER FirstName DESC

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

INSERT VALUES ('Jimmy', 'Jackson') INTO Persons
INSERT INTO Persons VALUES ('Jimmy', 'Jackson')
INSERT ('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 (Olsen') INTO Persons (LastName)
INSERT INTO Persons ('Olsen') INTO LastName

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

UPDATE Persons SET LastName ='Hansen' INTO LastName='Nilsen'
MODIFY Persons SET LastName='Nilsen' WHERE LastName='Hansen'
UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen'
MODIFY 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 FirstName='Peter' FROM Persons
DELETE ROW FirstName='Peter' FROM Persons
DELETE FROM Persons WHERE FirstName = 'Peter'

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

SELECT FROM Persons
SELECT FROM Persons
SELECT COUNT( * ) FROM Persons
SELECT FROM Persons

What is the most common type of join?

INSIDE JOIN
JOINED
JOINED TABLE
INNER JOIN

Which operator is used to select values within a range?

BETWEEN
WITHIN
RANGE

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

True
False

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

LIKE
FROM
GET

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

CREATE DATABASE TAB Customers
CREATE DATABASE TABLE Customers
CREATE TABLE Customers
CREATE DB Customers

I got 25 out of 25 points on the SQL Quiz from W3Schools
https://www.w3schools.com/quiztest/quiztest.asp?qtest=SQL

!Pasted image 20250922161315.png

Table of Contents

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  
GET
OPEN
EXTRACT

Question 3:

Which SQL statement is used to update data in a database?
UPDATE    Your answer  
SAVE AS
SAVE
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  
ADD NEW
ADD RECORD
INSERT NEW

Question 6:

With SQL, how do you select a column named "FirstName" from a table named "Persons"?
SELECT FirstName FROM Persons    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 [all] FROM Persons
SELECT 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 * FROM Persons WHERE FirstName<>'Peter'
SELECT [all] FROM Persons WHERE FirstName='Peter'
SELECT [all] FROM Persons WHERE FirstName LIKE 'Peter'

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  
SELECT * FROM Persons WHERE FirstName LIKE '%a'
SELECT * FROM Persons WHERE FirstName='a'
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 LastName='Jackson'    Your answer  
SELECT * FROM Persons WHERE FirstName<>'Peter' AND LastName<>'Jackson'
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 'Hansen' AND 'Pettersen'    Your answer  
SELECT * FROM Persons WHERE LastName>'Hansen' AND LastName<'Pettersen'
SELECT LastName>'Hansen' AND LastName<'Pettersen' FROM Persons

Question 13:

Which SQL statement is used to return only different values?
SELECT DISTINCT    Your answer  
SELECT UNIQUE
SELECT DIFFERENT

Question 14:

Which SQL keyword is used to sort the result-set?
ORDER BY    Your answer  
ORDER
SORT
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 ORDER BY FirstName DESC    Your answer  
SELECT * FROM Persons ORDER FirstName DESC
SELECT * FROM Persons SORT 'FirstName' DESC
SELECT * FROM Persons SORT BY 'FirstName' DESC

Question 16:

With SQL, how can you insert a new record into the "Persons" table?
INSERT INTO Persons VALUES ('Jimmy', 'Jackson')    Your answer  
INSERT ('Jimmy', 'Jackson') INTO Persons
INSERT VALUES ('Jimmy', 'Jackson') INTO Persons

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 ('Olsen') INTO Persons (LastName)
INSERT INTO Persons ('Olsen') INTO LastName

Question 18:

How can you change "Hansen" into "Nilsen" in the "LastName" column in the Persons table?
UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen'    Your answer  
MODIFY Persons SET LastName='Hansen' INTO LastName='Nilsen
MODIFY Persons SET LastName='Nilsen' WHERE LastName='Hansen'
UPDATE 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?
DELETE FROM Persons 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 COLUMNS( * ) FROM Persons
SELECT NO( * ) FROM Persons
SELECT LEN( * ) FROM Persons

Question 21:

What is the most common type of join?
INNER JOIN    Your answer  
JOINED TABLE
INSIDE JOIN
JOINED

Question 22:

Which operator is used to select values within a range?
BETWEEN    Your answer  
RANGE
WITHIN

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?
LIKE    Your answer  
FROM
GET

Question 25:

Which SQL statement is used to create a database table called 'Customers'?
CREATE TABLE Customers    Your answer  
CREATE DATABASE TABLE Customers
CREATE DATABASE TAB Customers
CREATE DB Customers