1. (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?
2. (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.
3. (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
4. (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 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?
5. (TCO 5) What is a COMMIT in a database and what does it accomplish?
6. 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 concerned?
7. (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?
Комментариев нет:
Отправить комментарий