W3Schools SQL Quiz
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!
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!
Very informative post. Thanks for sharing W3schools SQL Quiz.
ReplyDeleteApp Development company
Nice information. I was searching for the same. It helped me alot and saved my time. Thanks a lot.
ReplyDeleteSEO services Melbourne
App Development company
website design melbourne
These provided information was really so nice,thanks for giving that post and the more skills to develop after refer that post. Your articles really impressed for me,because of all information so nice.Website Development Bangalore | Web Design Company Bangalore
ReplyDeleteWonderful blog & good post.Its really helpful for me, awaiting for more new post. Keep Blogging!
ReplyDeleteECommerce Website developers in bangalore
Outsource magento ecommerce services india