Data Management 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. The database administrator has already set permissions for several people to use the system. Three of the users need to be able to use the database at the same time. What function does the administrator need to set?

Question 2 2. _____ refers to how many records in a table are related to the number of records in another table.

Question 3 3. Which of the following statements is false with respect to distributed databases?

Question 4 4. Which of the following is an advantage of a hierarchical data model?

Question 5 5. What is the primary strategic goal of database management for an organization?

Page 2

Question 6 6. What does a database model provide?

Question 7 7.

Given the following table called Students, how many records would be returned using the following SQL database query?

SELECT Student ID

FROM Students

WHERE Financial Aid = Yes AND GPA > 3.0

Question 8 8. What is a computer server?

Question 9 9. Which of the following statements about cloud computing is INCORRECT?

Question 10 10. What does the acronym DBMS stand for?

Page 3

Question 11 11. A field in a database table whose values are the same as the primary key of another table is called:

Question 12 12. What is a computer virus?

Question 13 13. Why is SQL so widely used?

Question 14 14. What is data encryption?

Question 15 15. Computers represent data in a finite manner. What does this mean?

Page 4

Question 16 16. Each column in a database table is also called _____?

Question 17 17. What is the difference between data and information?

Question 18 18. Which of the following is an example of an integer data type?

Question 19 19. Which of the following is not a benefit of cloud computing?

Question 20 20. Which of the following is NOT true of a data warehouse?

Page 5

Question 21 21. Which of the following DBMS models would be used to manage a collection of audio files ?

Question 22 22. What would be the benefits to a chain of grocery stores from using a database?

Question 23 23. What is a firewall?

Question 24 24. What makes a relational database so effective ?

Question 25 25. Which of the following database models uses parent-child relationships where each child can have multiple parents?

Page 6

Question 26 26. What is the primary advantage of using a distributed database?

Question 27 27. How would a university that needs to have records of student grades store this information ?

Question 28 28. Sometimes data values consist of numbers, yet they are best stored as text. To which of the following does this apply?

Question 29 29. Where is a multi-user database typically located?

Question 30 30. Which SQL statement is used to sort the result of a database query?

Data Management 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!

Business 104: Information Systems and Computer Applications  /  Business Courses
Support