SQL Variations 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. What is the meaning of the following delimiter in PL/SQL?

Question 2 2. What is the meaning of the NULL; statement in PL/SQL?

Question 3 3. Which of the following IS a required component of the PL/SQL block?

Question 4 4. Which of the following is the correct syntax for a PL/SQL statement?

Question 5 5. Which of the following is true about PL/SQL?

Page 2

Question 6 6. Which of the following deals with grouping steps together in a unit?

Question 7 7. Which of the following is NOT a difference between T-SQL and SQL?

Question 8 8. What does T-SQL stand for?

Question 9 9. Which of the following is NOT a characteristic of SQL?

Question 10 10. Which of the following SQL commands changes information already in a database?

Page 3

Question 11 11. A dynamic SQL query would be beneficial in which scenario?

Question 12 12. Examine the following snippet from a dynamic SQL statement. Which field is dynamic?

Question 13 13. What is a negative effect of having a very large dynamic SQL query?

Question 14 14. One of the security vulnerabilities of dynamic SQL is _____

Question 15 15. Dynamic SQL can be written on _____

SQL Variations 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