answersLogoWhite

0


Best Answer

data base administrator is the person who control the data in the organisation its main function to control the information of the particular enterprise

1.3 Functions of a DBMS

The functions performed by a typical DBMS are the following:

· Data Definition

The DBMS provides functions to define the structure of the data in the

application. These include defining and modifying the record structure, the

type and size of fields and the various constraints/conditions to be satisfied by

the data in each field.

· Data Manipulation

Once the data structure is defined, data needs to be inserted, modified or

deleted. The functions which perform these operations are also part of the

DBMS. These function can handle planned and unplanned data manipulation

needs. Planned queries are those which form part of the application.

Unplanned queries are ad-hoc queries which are performed on a need basis.

· Data Security & Integrity

The DBMS contains functions which handle the security and integrity of data

in the application. These can be easily invoked by the application and hence

the application programmer need not code these functions in his/her

programs.

· Data Recovery & Concurrency

Recovery of data after a system failure and concurrent access of records by

multiple users are also handled by the DBMS.

· Data Dictionary Maintenance

Maintaining the Data Dictionary which contains the data definition of the

application is also one of the functions of a DBMS.

· Performance

Optimizing the performance of the queries is one of the important functions of

a DBMS. Hence the DBMS has a set of programs forming the Query Optimizer

which evaluates the different implementations of a query and chooses the

best among them.

Thus the DBMS provides an environment that is both convenient and efficient to use

when there is a large volume of data and many transactions to be processed.

User Avatar

Wiki User

14y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What are the main function of a database administrator?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Continue Learning about Management

What is the difference between database and database administrator?

Database is the data stored in the server and Database administrator is the person who designs the database.


What responsibilities does an Oracle Database Administrator have?

The responsibilities are quite important. Interacting with consumers and employees is a main responsibility. Database design and repair are also other main responsibilities.


What is the explanation for the role of the database administrator?

A database administrator oversees all aspects of the database. He/she will be the person who has the ability to make anything happen with the management of the database.


What are the primary duties of a remote database administrator?

A database administrator's responsibilities can include the following tasks: future storage requirements for the database system. Creating primary database and the database tools and applications are executed on remote computers.


Difference between database administrator and system administrator?

A System Administrator is generically responsible for all parts of the computer network, such as user accounts, computer accounts, domain trusts, email accounts, etc. The System Administrator is probably specialized in the network server operating systems and user administration. A Database Administrator would deal specifically and in depth with all aspects of one or more databases. The Database Administrator will be highly specialized with the specific database server and client software.

Related questions

What are the main function of a database system?

create the database


What is the difference between database and database administrator?

Database is the data stored in the server and Database administrator is the person who designs the database.


What responsibilities does an Oracle Database Administrator have?

The responsibilities are quite important. Interacting with consumers and employees is a main responsibility. Database design and repair are also other main responsibilities.


What is the explanation for the role of the database administrator?

A database administrator oversees all aspects of the database. He/she will be the person who has the ability to make anything happen with the management of the database.


Can I get database administrator training online?

Try visiting www.gatlineducation.com/mcdbacertification.html. They offer Database Administrator training courses.


Who is responsible for database security?

Each database can have a security administrator who is in charge of enforcing and maintaining the database security policy. If the database system is small, the database administrator may also have security administrator responsibilities. To learn more about data science please visit- Learnbay.co


How do you explain in detail the role of dba also explain oracle tools available?

The database administrator performs a critical role within an organization and is an important and key role in Database Management Systems. The major responsibility of a database administrator is to handle the process of developing the database and maintaining the database of an organization. The database administrator is responsible for defining the internal layout of the database and ensuring the internal layout optimizes system performance.The database administrator has full access over all type of important data of an organization. The database administrator decides what data will be stored in the database and how to organize data in database so that it can be access easily on requirement or need of an organization. To design the database of an organization, the database administrator must have a meeting with users and determine their requirements.


What kinds of duties does a database administrator have?

A database administrator is responsible for the design, implementation, maintenance and repair of an organization's database. They also develop and design database strategies. http://en.wikipedia.org/wiki/Database_administrator


What are the primary duties of a remote database administrator?

A database administrator's responsibilities can include the following tasks: future storage requirements for the database system. Creating primary database and the database tools and applications are executed on remote computers.


What dBa stands for?

DataBase Administrator.


How do you abbreviate dba?

DataBase Administrator


What is the job description of an Oracle database administrator?

The database administrator performs a critical role within an organization and is an important and key role in Database Management Systems. The major responsibility of a database administrator is to handle the process of developing the database and maintaining the database of an organization. The database administrator is responsible for defining the internal layout of the database and ensuring the internal layout optimizes system performance. The database administrator has full access over all type of important data of an organization. The database administrator decides what data will be stored in the database and how to organize data in database so that it can be access easily on requirement or need of an organization. To design the database of an organization, the database administrator must have a meeting with users and determine their requirements. The database administrator is also responsible for preparing documentation, including recording the procedures, standards, guidelines, and data descriptions necessary for the efficient and continuing use of the database environment. Documents should include materials to help end users, database application programmers, the operation staff, and all personnel connected with the database management system. The database administrator is responsible for monitoring the database environment, such as seeing that the database is meeting performance standards, making sure the accuracy, integrity, and security of data are maintained. The database administrator is also responsible to manage any enhancements into the database environment