Health Care > EXAM > MIS 561 Week 4 Midterm | complete guide with correct answers & instructor's explanation, A+ Guide. (All)

MIS 561 Week 4 Midterm | complete guide with correct answers & instructor's explanation, A+ Guide.

Document Content and Description Below

MIS 561 Midterm Exam Question 1. Question : (TCO 1) We know that a DBA (Database Administrator) should have knowledge of database structures, such as tables and SQL. List and describe at least fou... r other categories of tasks expected from a DBA. Question 2. Question : (TCO 2) Suppose that as a DBA, you are tasked with installing a new database management system in your organization. Would you choose the default system parameters when installing the system software? Explain and support your answer with reasoning. Question 3. Question : (TCO 3) Designing and implementing a physical database from a logical data model is not just a simple matter of mapping entities to tables, attributes to columns, and relationships to referential constraints. Quite a few other database design issues must be addressed. Effective storage planning is part of physical process design. As a DBA, you do consider the size of table structures. Here, focus on other structures that need to be considered when determining the required storage size. Question 4. Question : (TCO 4) When implementing a physical database from a logical data model, you must consider database performance by allowing data in the database to be accessed more rapidly. In order to increase data availability, the DBA may break up data that are accessed together to be stored together. Which method will improve the performance of this structure when running queries? What are advantages and disadvantages of this method? Question 5. Question : (TCO 5) What is a COMMIT in a database and what does it accomplish? Question 6. Question : (TCO 6) How could a DBA make changes to the amount of free space for a database object? What steps should be taken to accomplish this task? Question 7. Question : (TCO 7) Data are generated more than ever with business intelligence applications, data warehousing, data marts, and advanced analytics for business decision support. What kind of challenges with respect to data availability does a DBA face in this environment? [Show More]

Last updated: 7 months ago

Preview 1 out of 7 pages

Buy Now

Instant download

We Accept: