W3Schools SQL Quiz

SQL QUIZ	Points: 25 out of 25

1. What does SQL stand for?

You answered:

Structured Query Language

Correct Answer!

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

You answered:

SELECT

Correct Answer!

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

You answered:

UPDATE

Correct Answer!

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

You answered:

DELETE

Correct Answer!

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

You answered:

INSERT INTO

Correct Answer!

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

You answered:

SELECT FirstName FROM Persons

Correct Answer!

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

You answered:

SELECT * FROM Persons

Correct Answer!

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

You answered:

SELECT * FROM Persons WHERE FirstName='Peter'

Correct Answer!

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"?

You answered:

SELECT * FROM Persons WHERE FirstName LIKE 'a%'

Correct Answer!

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

You answered:

True

Correct Answer!

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"?

You answered:

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

Correct Answer!

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"?

You answered:

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

Correct Answer!

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

You answered:

SELECT DISTINCT

Correct Answer!

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

You answered:

ORDER BY

Correct Answer!

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

You answered:

SELECT * FROM Persons ORDER BY FirstName DESC

Correct Answer!

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

You answered:

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

Correct Answer!

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

You answered:

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

Correct Answer!

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

You answered:

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

Correct Answer!

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

You answered:

DELETE FROM Persons WHERE FirstName = 'Peter'

Correct Answer!

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

You answered:

SELECT COUNT(*) FROM Persons

Correct Answer!

21. What is the most common type of join?

You answered:

INNER JOIN

Correct Answer!

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

You answered:

BETWEEN

Correct Answer!

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

You answered:

True

Correct Answer!

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

You answered:

Correct Answer!

25. Which SQL statement is used to create a table in a database?

You answered:

CREATE TABLE

Correct Answer!