Managing Data in Databases 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 MS-SQL command will check to see if the table exists before dropping?

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

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

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

Question 5 5. What happens to sequentially-numbered (auto-numbered) fields after TRUNCATE?

Page 2

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

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

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

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

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

Page 3

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

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

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

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

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

Managing Data in Databases 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!

Relational Databases Tutorial  /  Business Courses
Support