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: 1 year ago

Preview 1 out of 7 pages

Add to cart

Instant download

We Accept:

We Accept

Buy this document to get the full access instantly

Instant Download Access after purchase

Add to cart

Instant download

We Accept:

We Accept

Reviews( 0 )


Add to cart

We Accept:

We Accept

Instant download

Can't find what you want? Try our AI powered Search



Document information

Connected school, study & course

About the document

Uploaded On

Feb 28, 2020

Number of pages


Written in



Member since 4 years

411 Documents Sold

Additional information

This document has been written for:


Feb 28, 2020





Document Keyword Tags

Recommended For You

Get more on EXAM »
What is Browsegrades

In Browsegrades, a student can earn by offering help to other student. Students can help other students with materials by upploading their notes and earn money.

We are here to help

We're available through e-mail, Twitter, Facebook, and live chat.
 Questions? Leave a message!

Follow us on

Copyright © Browsegrades · High quality services·