Answer / mayank

following:-
1.maintaining data integrity
2.preventing unauthorised user access

along with this
it also perform ACID.

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.

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.

what is meant by physical order and logical order in clustered index and non clustered index.

2 Answers  

---

How can you enable automatic archiving ?

2 Answers  

---

How can we specify the Archived log file name format and destination ?

2 Answers  

---

what is snapshot log ?

2 Answers  

---

What are the benefits of distributed options in databases ?

1 Answers  

---

How will you enforce security using stored procedures ?

2 Answers  

---

What is Tablespace Quota ?

2 Answers  

---

What is Statement Auditing ?

2 Answers  

---

What is Privilege Auditing ?

1 Answers  

---

What is the use of ANALYZE command ?

3 Answers  

---

What is a profile ?

2 Answers  

---

What are the use of Roles ?

3 Answers  

---