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

(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 from a DBA. A DBA must ensure that: databases are useful, usable, available, and correct. there is database performance, monitoring, and tuning. there is access authorization and security. there is database backup and recovery. there are interfaces with databases. (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. Your Answer: Standards are common practices that ensure the consistency and effectiveness of the database environment, such as database naming conventions. Procedures are defined, step-by-step instructions that direct the processes required for handling specific events, such as a disaster recovery plan. Failure to implement database standards and procedures will result in a database environment that is confusing and difficult to manage. The DBA should develop database standards and procedures as a component of corporate-wide IT standards and procedures. They should be stored together in a central location as a printed document, in an online format, or as both. Several vendors offer canned standards and procedures that can be purchased for specific DBMS products.