Sunday, April 29, 2012

SQL interview questions: 19 out 20 right!

I didn't think I was much of a SQL guru, but maybe there is hope


Try this w3schools test, and leave your result in the comments. I think this is way to easy for interview prep, but a good self-esteem booster
take test here


1. What does SQL stand for?

 Correct Answer!

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

 Correct Answer!

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

 Correct Answer!

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

 Correct Answer!

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

 Correct Answer!

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

 Correct Answer!

7. With SQL, how do you select all the columns from a table named "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"?

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

 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

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

 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>'Hansen' AND LastName<'Pettersen'   Wrong Answer! 13. Which SQL statement is used to return only different values?  Correct Answer! 14. Which SQL keyword is used to sort the result-set?  Correct Answer! 15. With SQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"?  Correct Answer! 16. With SQL, how can you insert a new record into the "Persons" table?  Correct Answer! 17. With SQL, how can you insert "Olsen" as the "LastName" in the "Persons" table?  Correct Answer! 18. How can you change "Hansen" into "Nilsen" in the "LastName" column in the Persons table?  Correct Answer! 19. With SQL, how can you delete the records where the "FirstName" is "Peter" in the Persons Table?  Correct Answer! 20. With SQL, how can you return the number of records in the "Persons" table?  Correct Answer! 1. What does SQL stand for?  Correct Answer! 2. Which SQL statement is used to extract data from a database?  Correct Answer! 3. Which SQL statement is used to update data in a database?  Correct Answer! 4. Which SQL statement is used to delete data from a database?  Correct Answer! 5. Which SQL statement is used to insert new data in a database?  Correct Answer! 6. With SQL, how do you select a column named "FirstName" from a table named "Persons"?  Correct Answer! 7. With SQL, how do you select all the columns from a table named "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"?  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"?  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  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"?  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>'Hansen' AND LastName<'Pettersen' 
 Wrong Answer!

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

 Correct Answer!

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

 Correct Answer!

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

 Correct Answer!

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

 Correct Answer!

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

 Correct Answer!

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

 Correct Answer!

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

 Correct Answer!

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

 Correct Answer!


No comments: