Removing Data in SQL 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 happens to sequentially-numbered (auto-numbered) fields after TRUNCATE?

Question 2 2. TRUNCATE _____ all rows from the table.

Question 3 3. The correct syntax for dropping a column in SQL Server is:

Question 4 4. Omitting the WHERE clause on a DELETE FROM statement will do what?

Question 5 5. In Oracle, the following condition on the DROP TABLE command prevents writing to the recycle bin:

Page 2

Question 6 6. The following syntax will drop a table from the database

Question 7 7. Releasing the space of the deleted the rows prevents what?

Question 8 8. Which table is a good candidate to be dropped from a database?

Question 9 9. A(n) _____ is required at the end command.

Question 10 10. By default, TRUNCATE will _____ the space left behind by the deleted rows.

Page 3

Question 11 11. Which MS-SQL command will check to see if the table exists before dropping?

Question 12 12. To drop/delete a row of data, use the _____ command.

Question 13 13. Which of the following is the correct syntax to remove the table shopping_cart?

Question 14 14. A _____ is a record of data; a _____ is a data field.

Question 15 15. Before removing the table from the database, DROP TABLE _____ the data.

Removing Data in SQL 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