What are the responsibilities of a Database Administrator ?
Answers were Sorted based on User's Feedback
Answer / mayank
following:-
1.maintaining data integrity
2.preventing unauthorised user access
along with this
it also perform ACID.
| Is This Answer Correct ? | 15 Yes | 6 No |
Answer / ragini
1.Deciding the h/w devices to be used
2.Deciding the user and data to be used by user.
3.Deciding the information content data base system.
4.Deciding the data dictionary contain the data in data.
5.Deciding the validation check on data.
6.Deciding the backup and recovery.
7.Monitoring the response to be changing environment.
| Is This Answer Correct ? | 17 Yes | 9 No |
Answer / aditya das
Depending on the company and the department, this role can either be highly specialized or incredibly diverse. The primary role of the Database Administrator is to adminster, develop, maintain and implement the policies and procedures necessary to ensure the security and integrity of the corporate database. Sub roles within the Database Administrator classification may include security, architecture, warehousing and/or business analysis. Other primary roles will include:
Implementation of data models
Database design
Database accessibility
Performance issues
Capacity issues
Data replication
Table Maintainence
Database Administrators are often on-call and required to work as needed. This position carries an enormous amount of responsibility.
| Is This Answer Correct ? | 5 Yes | 2 No |
What are the responsibilities of a Database Administrator ?
What are the steps to switch a database's archiving mode between NO ARCHIVELOG and ARCHIVELOG mode ?
When will the data in the snapshot log be used ?
What are roles ? How can we implement roles ?
What is Object Auditing ?
What is Privilege Auditing ?
How can we specify the Archived log file name format and destination ?
What are the use of Roles ?
How will you enforce security using stored procedures ?
What are the various type of snapshots ?
What are the roles and user accounts created automatically with the database ?
What are the database administrators utilities avaliable ?