SQL Statements & Functions 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. Which statement correctly displays 99999 for NULL Zip Codes in the Customer_Contact table?

Question 2 2. How should the field names in the INSERT INTO statement and the values in the VALUES statement should be arranged?

Question 3 3. The word set in the update clause specifies:

Question 4 4. The update clause allows us to:

Question 5 5. If a field allows blank or NULL values, it is _____ to specify it in the INSERT statement.

Page 2

Question 6 6. What directly follows the update clause?

Question 7 7. Which of the following is mandatory in the use of an update clause?

Question 8 8. NVL can be used in the following databases:

Question 9 9. NVL can be used with the following data types:

Question 10 10. The update clause can:

Page 3

Question 11 11. You can insert multiple rows into the table by adding _____ to the INSERT statement.

Question 12 12. INSERT is part of a categorization of SQL statements called _____

Question 13 13. Which statement will correctly insert a new record into the genre table?

Question 14 14. NVL is a function used for _____

Question 15 15. In order to ensure a string is replaced when a numeric field is NULL, use the _____ keyword

SQL Statements & Functions 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