MIS 561 Week 4 Midterm Exam (Fall Session) | 100% correct answers | Highly RATED Paper

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) Before a newly installed DBMS can … used effectively, standards and procedures must … developed for database usage. Name some of these standards that, if practiced, could help in reducing cost of supporting end users. 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 the physical process design. As a DBA, how do you calculate the amount of storage space usage required to store a table? 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 … accessed more rapidly. One way to improve performance is to reduce the number of input/output when requesting data from a database. Which method do you recommend for possible reduced I/O when querying chunks of data? How does it improve the amount of input/output and what are the disadvantages of the method? Question: (TCO 5) What is a lock in a database and what does it accomplish? As a DBA, you are asked to add a column in the middle of an existing table that is already populated with data. What steps do you take in accomplishing this task? With what factors are you … ? Question: (TCO 7) Downtime is not … by some businesses. The cost of downtime varies from business to business. Which factors do you consider when estimating the cost of downtime? Question: (TCO 2) Each of the major DBMS products changes quite rapidly, and keeping DBMS software up-to-date can … a difficult task. As a DBA, what are the issues to consider when upgrading to a new DBMS version to have little or no disruption? Question: (TCO 5) What is a COMMIT in a database and what does it accomplish? Question: (TCO 1) What are the duties of a system administrator (SA) in regards to a database, and how are a DBA’s (Database Administrator) responsibilities different from an SA when supporting a database? 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. What are the physical data storage issues with a table’s data that must … addressed by the DBA? 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: (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? Question: (TCO 1) What are the duties of a data administrator (DA) with regards to a database, and how are a DBA’s (Database Administrator) tasks different from a DA’s in dealing with a database? Question: (TCO 2) Before a newly installed DBMS can be used effectively, standards and procedures must be developed for database usage. Name some of these standards that, if practiced, could help in reducing cost of supporting end users. Question: (TCO 6) What is the role of DDL? What are the limitations of DDL in modifying a database? Question: (TCO 7) How is availability different from performance in a database? How do you define availability for a database? 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. One way to improve performance is to reduce the number of input/output when running queries against a table. If you are retrieving a row or small set of data using the key values, which method will enable quick direct access to data? Explain the method by listing advantages and disadvantages? Question: (TCO 5) Name two popular standard interfaces that enable application programs to access databases using SQL. What are the similarities and differences between them? 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 … when determining the required storage size. Show Less