Relational Databases Tutorial  /  Business Courses

Test Prep Plan - Take a practice test

Take this practice test to check your existing knowledge of the course material. We'll review your answers and create a Test Prep Plan for you based on your results.
How Test Prep Plans work
1
Answer 50 questions
Test your existing knowledge.
2
View your test results
Based on your results, we'll create a customized Test Prep Plan just for you!
3
Study smarter
Study more effectively: skip concepts you already know and focus on what you still need to learn.

Database Basics 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. _____ is another word for a database record.

Question 2 2. A database is comprised of tables, which each have columns and rows. Housed in one specific column and row is one unit of data called:

Question 3 3. _____ can be used to change data in a record.

Question 4 4. In a database, records _____ run vertically (down the page) and _____ run horizontally (across the page)

Question 5 5. In the database example shown here, which fields are numeric (numbers only):

Page 2

Question 6 6. Which of the following can NOT be repeated in a set of database records?

Question 7 7. What type of language is ''delete'' in SQL?

Question 8 8. The following terms all describe a set of records:

Question 9 9. _____ will add a new row to the table.

Question 10 10. Which SQL statement would return ALL records from the artist table?

Page 3

Question 11 11. What purpose does a junction table serve?

Question 12 12. Which of these is the best definition of a database?

Question 13 13. _____ will remove data from the table or database.

Question 14 14. What is a query?

Question 15 15. A query can perform the following:

Database Basics 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!

Support