Answer Posted / pavana kumar.s

Just query the registry$history view in oracle to view the las t exact date of update.

What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

986

---

what is a user-defined lock?

983

---

internal architecture

2140

---

What is the importance of a recovery model? : sql server DBA

966

---

Query processing is slow(eg select query)how will u solve that

7753

---

Why would you call update statistics? : sql server DBA

947

---

How would you go about verifying the network name that the local_listener is currently using?

3155

---

what do you understand by fine-grained auditing?

1014

---

what is the use of ocr?

960

---

I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution

2043

---

how can you find out if a table can be redefined?

961

---

how can you schedule a job in database?

1043

---

. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

2398

---

What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

937

---

What is dbcc? : sql server DBA

1216

---