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 roles ? How can we implement roles ?
What is Auditing ?
what is different between view and sequence?
What are the use of Roles ?
What are the system resources that can be controlled through Profile ?
What are the responsibilities of a Database Administrator ?
What are the options available to refresh snapshots ?
Differentiate simple and complex, snapshots ?
What is user Account in Oracle database ?
What are the steps to switch a database's archiving mode between NO ARCHIVELOG and ARCHIVELOG mode ?
How will you enforce security using stored procedures ?
what is snapshot log ?