Login/Logout System

Points: 11 out of 20| 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: GET Wrong 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! 0. 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: False Wrong 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 UNIQUE Wrong Answer! 14. Which SQL keyword is used to sort the result-set? You answered: SORT BY Wrong 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 SORT BY ‘FirstName’ DESC Wrong Answer! 16. With SQL, how can you insert a new record into the “Persons” table? You answered: INSERT VALUES (‘Jimmy’, ‘Jackson’) INTO Persons Wrong 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=’Hansen’ INTO LastName=’Nilsen’ Wrong Answer! 19. With SQL, how can you delete the records where the “FirstName” is “Peter” in the Persons Table? You answered: DELETE FirstName=’Peter’ FROM Persons Wrong Answer! 20. With SQL, how can you return the number of records in the “Persons” table? You answered: SELECT COUNT() FROM Persons Wrong Answer!

Leave a Reply

Your email address will not be published. Required fields are marked *