(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?
(TCO 2) Each of the major DBMS products changes quite rapidly, and keeping DBMS software up-to-date can be 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?
(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.
(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?
(TCO 5) What is a lock in a database and what does it accomplish?
(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?
(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?