Database Systems: Design, Implemen...

13th Edition
Carlos Coronel + 1 other
Publisher: Cengage Learning
ISBN: 9781337627900

Database Systems: Design, Implemen...

13th Edition
Carlos Coronel + 1 other
Publisher: Cengage Learning
ISBN: 9781337627900


Chapter 16, Problem 27RQ
Textbook Problem

What are typical activities in the maintenance of the DBMS and its utilities and applications? Would you consider application performance tuning to be part of the maintenance activities? Explain your answer.

Expert Solution
Program Plan Intro

Database Administrator (DBA's):

The person responsible for the maintaining the shared and centralized database is known as Database Administrator (DBA).

The role and responsibilities of the DBA varies from organization to organization based on the size of the organization. Based on the organization, DBA defined either in line position or staff position.

The DBA’s technical role needs the functions of database management system (DBMS), structure, programming languages, and methodologies of data-modeling and design.

Explanation of Solution

Typical activities in maintenance of DBMS and its utilities and applications:

The activities for maintenance of Database Administrator (DBA) are operational activities extension and that activities dedicated to DBMS environment preservation.

  • One of the major activities in maintenance is restructuring the data physical position in organization.
  • Design the restructure of database to allot the contiguous locations of disk-page to DBMS to increase the performance.
  • The process of restructure help to free the space which is allotted to removed data, thus offering the more disk space for new data.
  • This activity involves the updating of DBMS and utility software...

Want to see this answer and more?

Bartleby provides explanations to thousands of textbook problems written by our experts, many with advanced degrees!

See solution

Chapter 16 Solutions

Database Systems: Design, Implementation, & Management
Show all chapter solutions
Ch. 16 - Describe the DBAs responsibilities.Ch. 16 - How can the DBA function be placed within the...Ch. 16 - Why and how are new technological advances in...Ch. 16 - Explain the DBA departments internal organization...Ch. 16 - Explain and contrast differences and similarities...Ch. 16 - Explain how the DBA plays an arbitration role...Ch. 16 - Describe and characterize the skills desired for a...Ch. 16 - What are the DBAs managerial roles? Describe the...Ch. 16 - What DBA activities support end users?Ch. 16 - Explain the DBAs managerial role in the definition...Ch. 16 - Protecting data security, privacy, and integrity...Ch. 16 - Discuss the importance and characteristics of...Ch. 16 - Assume that your company has assigned you the...Ch. 16 - Describe the activities that are typically...Ch. 16 - Why are testing and evaluation of the database and...Ch. 16 - Identify some bottlenecks in DBMS performance, and...Ch. 16 - What are typical activities in the maintenance of...Ch. 16 - How do you normally define security? How is your...Ch. 16 - What are the levels of data confidentiality?Ch. 16 - What are security vulnerabilities? What is a...Ch. 16 - Define the concept of a data dictionary, and...Ch. 16 - Using SQL statements, give some examples of how...Ch. 16 - What characteristics do a CASE tool and a DBMS...Ch. 16 - Briefly explain the concepts of information...Ch. 16 - Identify and explain some critical success factors...Ch. 16 - How have cloud-based data services affected the...Ch. 16 - What tool is used in Oracle to create users?Ch. 16 - In Oracle, what is a tablespace?Ch. 16 - In Oracle, what is a database role?Ch. 16 - In Oracle, what is a datafile? How does it differ...Ch. 16 - In Oracle, what is a database profile?

Additional Engineering Textbook Solutions

Find more solutions based on key concepts
Show solutions
List two general types of upright drill press heads.

Precision Machining Technology (MindTap Course List)

What do the terms organizational culture and organizational learning mean?

Principles of Information Systems (MindTap Course List)

The angle of twist for a shaft subjected to twisting torque can be expressed by the equation: =TLJG where = th...

Engineering Fundamentals: An Introduction to Engineering (MindTap Course List)

Convert 5 megawatts of power into BTU/hr, ft-lbs/s, and kJ/hr.

Fundamentals of Chemical Engineering Thermodynamics (MindTap Course List)

What is optoisolation?

Electric Motor Control

If your motherboard supports ECC DDR3 memory, can you substitute non-ECC DDR3 memory?

A+ Guide to Hardware (Standalone Book) (MindTap Course List)

quarantine (191) a. destructive event or prank a virus was created to deliver b. copyrighted software that is d...

Enhanced Discovering Computers 2017 (Shelly Cashman Series) (MindTap Course List)

What two welding processes are semiautomatic processes?

Welding: Principles and Applications (MindTap Course List)