Our Recommendations :-
Follow IT FB Page

explain database administrator and his functions

Avatar 37a3bd7bc7328f0ead2c0f6f635dddf60615e676e6b4ddf964144012e529de45 Uma asked almost 3 years ago

    0       0 Answer Now Comment Report
3 Answers
Avatar 37a3bd7bc7328f0ead2c0f6f635dddf60615e676e6b4ddf964144012e529de45 veeru answered over 2 years ago

Data policies, procedures, standards Planning- development of organization's IT strategy, enterprise model, cost/benefit model, design of database environment, and administration plan. Data conflict (ownership) resolution Data analysis- Define and model data requirements, business rules, operational requirements, and maintain corporate data dictionary Internal marketing of DA concepts Managing the data repository What are the functions of a database administrator? Selection of hardware and software Keep up with current technological trends

    0       0 Comment Report
Important Note – Preparing for IT?
CAKART provides Indias top faculty each subject video classes and lectures – online & in Pen Drive/ DVD – at very cost effective rates. Get video classes from CAKART.in. Quality is much better than local tuition, so results are much better.
Watch Sample Video Now by clicking on the link(s) below – 
For any questions Request A Call Back  
Open uri20170510 32134 1uwcnoc?1494421631 Shubhangi Jain answered almost 3 years ago

A database administrator (DBA) directs or performs all activities related to maintaining a successful database environment. Responsibilities include designing, implementing, and maintaining the database system; establishing policies and procedures pertaining to the management, security, maintenance, and use of the database management system; and training employees in database management and use. A DBA is expected to stay abreast of emerging technologies and new design approaches. Typically, a DBA has either a degree in Computer Science and some on-the-job training with a particular database product or more extensive experience with a range of database products. A DBA is usually expected to have experience with one or more of the major database management products, such as Structured Query Language, SAP, and Oracle-based database management software. > The following are the functions of a Database administrator - **Schema Definition** The Database Administrator creates the database schema by executing DDL statements. Schema includes the logical structure of database table(Relation) like data types of attributes,length of attributes,integrity constraints etc. - **Storage structure and access method definition** Database tables or indexes are stored in the following ways: Flat files,Heaps,B+ Tree etc.. - **Schema and physical organization modification** The DBA carries out changes to the existing schema and physical organization. - **Granting authorization for data access** The DBA provides different access rights to the users according to their level. Ordinary users might have highly restricted access to data, while you go up in the hierarchy to the administrator ,you will get more access rights. - **Routine Maintenance** Some of the routine maintenance activities of a DBA is given below. - Taking backup of database periodically - Ensuring enough disk space is available all the time. - Monitoring jobs running on the database. - Ensure that performance is not degraded by some expensive task submitted by some users. - Performance Tuning

    0       0 Comment Report
Avatar 37a3bd7bc7328f0ead2c0f6f635dddf60615e676e6b4ddf964144012e529de45 Aarti Vadnerkar answered almost 3 years ago

A data administration (also known as a database administration manager, data architect, or information center manager) is a high level function responsible for the overall management of data resources in an organization. In order to perform its duties, the DA must know a good deal of system analysis and programming. These are the functions of a data administrator (not to be confused with database administrator functions): 1. Data policies, procedures, standards 2. Planning- development of organization's IT strategy, enterprise model, cost/benefit model, design of database environment, and administration plan. 3. Data conflict (ownership) resolution 4. Data analysis- Define and model data requirements, business rules, operational requirements, and maintain corporate data dictionary 5. Internal marketing of DA concepts 6. Managing the data repository What are the functions of a database administrator? 1. Selection of hardware and software Keep up with current technological trends Predict future changes Emphasis on established off the shelf products 2. Managing data security and privacy Protection of data against accidental or intentional loss, destruction, or misuse Firewalls Establishment of user privileges Complicated by use of distributed systems such as internet access and client/ server technology.

    0       0 Comment Report
Get Notifications
Videos
Books
Notes
Loading
SIGN UP
Watch best faculty demo video classes

These top faculty video lectures will
help u prepare like nothing else can.