DBMT - Chapter 12

What are distinct purposes of backups?

) to recover data from an earlier time 2) to recover after a data loss event

What is the purpose of backups?

1) to recover data from an earlier time 2) to recover after a data loss event

What is Database performance tuning?

optimizing performance of a database

What are the major functions of data administration?

A high-level function responsible for the overall management of data resources in an organization, including maintaining corporate-wide definitions and standards. Process by which data is monitored, maintained and managed by a data administrator.

What are the major functions of database administration?

A technical function that is responsible for physical database design and for dealing with technical issues such as security enforcement, database performance, and backup and recovery. The function of managing and maintaining database management systems (DBMS) software.

38. What are controls called that are designed to restrict access and activities?

Access Controls / Authorization Rules

As database administration automation increases, what is the impact on personnel needs?

As automation increases, the personnel needs of the organization splits into two categories 1) highly skilled workers to create and manage the automation 2) a group of less skilled "line" DBAs who execute and monitor the automation.

What is a discrete unit of work called that must be processed completely or not at all in an operational system?

Atomicity

22. What are the characteristics of a Database Administrator's work?

Complex, repetitive, time-consuming and requires specialized training An exceptional DBA is trustworthy, enjoys technology, challenge (opportunities to learn something new), the process of problem solving (troubleshooting), enjoys learning, accepts responsibility, manages time well, good with details (the job is all about details, very thorough and meticulous as they perform their work), and embraces change.

What are case tools

Computer Aided Software Engineering Automated Framework for the SDLC Front-End Tool Planning, Analysis, Design Back-End Tools Coding and Implementation

What are a DBA's managerial responsibilities?

Control and Planning related to Database Administration Coordinating, Monitoring, and Allocating database administration resources Defining Goals and Formulating Strategic Plans for the Database Administration function End-User Support; Setting Policies, Procedures, Standards Evaluating Data Security, Privacy, Integrity Data Backup and Recovery Controlling Data Distribution and Use

What is the Systems DBA managerial role?

Coordinate the efforts, requirements, and sometimes conflicting goals of various user groups to develop community-wide solutions. Responsible for the installation, configuration, upgrade, administration, monitoring and maintenance of databases in an organization. Duties differ depending upon job description

What do we call the function of managing and maintaining database management systems (DBMS) software?

Database Administration

What do we call the technical function responsible for database design, security, and disaster recovery?

Database Administration (DBA)

What are the phases in the database life cycle?

Database planning. Data analysis. Database design Database implementation. Operation and maintenance.

What type of DBA is responsible for data model design and maintenance and DDL generation?

Development DBA

What is the intention of DBA automation?

Enable DBAs to focus on more proactive activities around database architecture, deployment, performance and service level management.

What are DBMS policies, procedures, and standards?

End-User Support This is a DBA managerial responsibility

What is an example of network security controls?

Firewalls and Access Controls

What occurs during database implementation?

First step is creation and initial load of the database - called populating the database: Resolve data inconsistencies. Establish security controls. Establish backup and recovery procedures. Train system users.

Why do we need database administrators?

Global economy has become dependent upon capturing, storing, managing and processing information. Analysis of data supports decision making and transaction processing. Databases have become mission critical for many organizations. We need to manage and administer data. A good database administrator avoids problems and hopefully solves problems if they arise before a problem becomes a crisis. There are many routine database and data administration tasks that can be delegated and automated, but an experienced, resourceful and thoughtful DBA is indispensable.

What is data administration?

High-level function responsible for the overall management of data resources in an organization, including maintaining corporate-wide definitions and standards. Process by which data is monitored, maintained and managed by a data administrator.

What type of DBA focuses on physical aspects of database administration like installation and configuration?

Operations DBA

25. What are the 3 types of DBAs?

Operations, Development,Application

What are the responsibilities of a Database Administrator?

Physical database design Technical issues like security, performance, and backup/recovery

Approximately how many steps are involved in the process of creating a new database?

Process of creating a new database can consist of hundreds or thousands of unique steps from satisfying prerequisites to configuring backups where each step must be successful before the next can start.

What are the primary purposes of a database?

Process transactions, atomic, consistent, isolated and durable units of work performed within a DBMS in a database. Support Managerial Decision Making at all levels of an organization Provide a seamless flow of information throughout an organization

What is a data dictionary

Store the Description of all objects that interact with the database Integrated; > limited to data of DBM Stand-alone; > include data outside of DBMS

What are the major tasks in the maintenance phase?

They include: database backup and recovery, performance tuning, design modifications, access management and audits, usage monitoring, hardware maintenance, upgrades.

What is the problem of database security?

Unauthorized or unintended activity or misuse Malware infections, including deletion of or damage to the data or programs, interruption or denial of database services Physical damage to database servers Design flaws and programming bugs creating security vulnerabilities data loss/corruption, performance degradation Data corruption and/or loss caused by the entry of invalid data or commands Mistakes in database or system administration processes Sabotage/criminal damage Databases should have many layers and types of security

24. What is the role of a database administrator?

technical, managerial,