MIS 561 Week 4 Midterm (Spring Session) | 100% VERIFIED Answers

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 four other categories of tasks expected f rom a DBA. 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. (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 … 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 … considered when determining the required storage size. 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. (TCO 5) What is a COMMIT in a database and what does it accomplish? Question. (TCO 6) How could a DBA make changes to the amount of free space for a database object? What steps should … taken to accomplish this task? 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 Less