Copyright

SQL Tutorial & Training Final Exam

Free Practice Test Instructions:

Choose your answer to the question and click 'Continue' to see how you did. Then click 'Next Question' to answer the next question. When you have completed the free practice test, click 'View Results' to see your results. Good luck!

Question 1 1. What does the Select statement in a SQL query do?

Question 2 2. Examine the following code. What is the function of the @productName?

Question 3 3. What is an important advantage of NoSQL over SQL in the beginning?

Question 4 4. Which of the following SQL commands changes existing information?

Question 5 5. Database schemas depend on _____ and _____.

Question 6 6. Examine the following code. What will the value of the field updateValue be if the order number exists?

Question 7 7. Why would a ZIP code make a bad primary key for an individual in SQL?

Question 8 8. What is a relational or SQL database?

Question 9 9. If you want to view a maximum value from a table, in which part of the SQL statement should the subquery be placed?

Question 10 10. Under what circumstance would you select a full outer join SQL statement?

Question 11 11. Which is the best analogy to UNION in SQL?

Question 12 12. SQL is an acronym that stands for?

Question 13 13. Which of the following operations does SQL allow you to perform?

Question 14 14. In this code, what command checks that duplicate values are not included?

Question 15 15. What is the difference between LEFT and RIGHT joins?

Tell us about yourself

Are you a student or a teacher?

I am a student I am a teacher

SQL Tutorial & Training Final Free Practice Test Instructions

Choose your answer to the question and click 'Continue' to see how you did. Then click 'Next Question' to answer the next question. When you have completed the free practice test, click 'View Results' to see your results. Good luck!

SQL Tutorial & Training  /  Computer Science Courses
Support