Copyright

SQL Basics & Syntax Chapter Exam

Exam Instructions:

Choose your answers to the questions and click 'Next' to see the next set of questions. You can skip questions if you would like and come back to them later with the yellow "Go To First Skipped Question" button. When you have completed the practice exam, a green submit button will appear. Click it to see your results. Good luck!

Page 1

Question 1 1. The ORDER By clause must be paired with:

Question 2 2. The ORDER BY clause:

Question 3 3. A CROSS JOIN is performed on two tables. Table A has 15 rows; Table B has 5. How many rows will the SQL query return?

Question 4 4. A CROSS JOIN is also known as a _____

Question 5 5. In computer terms, what is an SQL query?

Page 2

Question 6 6. Which of the following is NOT an operation that can be performed by SQL?

Question 7 7. Examine the following SQL statement. What table is the subquery querying?

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

Question 9 9. The SQL statement clause that is used to identify the criteria to be matched for inclusion in the results is the _____ clause.

Question 10 10. Which term below refers to strict structural patterns when related to SQL?

Page 3

Question 11 11. Which of the following is NOT a command affected by cursors?

Question 12 12. What is the first cursor command executed in code?

Question 13 13. Which of the following correctly completes the INNER JOIN statement?

Question 14 14. The following is only the first part of an INNER JOIN query. Which of the following is the correctly-written full query?

Question 15 15. What is NOT the conditions required for an SQL Injection?

Page 4

Question 16 16. What is SQL Injection?

Question 17 17. Which of these would NOT be needed to use JOIN in SQL to join tables?

Question 18 18. Which is the best analogy to JOIN in SQL?

Question 19 19. Which part a self-join statement ensures that one record per criteria is returned?

Question 20 20. Examine the following code. What is missing from the self-join statement?

Page 5

Question 21 21. When UNPIVOT is executed, it restores _____ of the information affected by PIVOT.

Question 22 22. The purpose of the SQL PIVOT command is to?

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

Question 24 24. Which of the following is the correct full outer join syntax?

Question 25 25. Which type of database supports SQL LEFT and RIGHT Joins?

Page 6

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

Question 27 27. What notation must be used to end an GROUP BY clause or any SQL statement?

Question 28 28. How is the Cartesian product of A and B represented?

Question 29 29. SQL was released in 1979 by _____ and developed by _____ in the early 1970s.

Question 30 30. Examine the following subquery: What is missing from this SQL statement?

SQL Basics & Syntax Chapter Exam Instructions

Choose your answers to the questions and click 'Next' to see the next set of questions. You can skip questions if you would like and come back to them later with the yellow "Go To First Skipped Question" button. When you have completed the practice exam, a green submit button will appear. Click it to see your results. Good luck!

SQL Tutorial & Training  /  Computer Science Courses
Support