W3Schools SQL Quiz

SQL QUIZ POINTS: 20 out of 20

1. What does SQL stand for?

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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