Answer Posted / manoj kumar

linked server

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

2410

---

What are statistics, under what circumstances they go out of date, how do you update them?

2250

---

How do you trace the traffic hitting a sql server? : sql server DBA

1569

---

What would you do with an "in-doubt" distributed transaction?

1886

---

What are the different ways you can create databases in sql server? : sql server DBA

1136

---

What are the operating modes in which database mirroring runs? : sql server DBA

1186

---

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

2041

---

when does an alert gets signaled?

1050

---

what is a crs resource?

1166

---

How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

2470

---

I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB

1935

---

What the different types of replication and why are they used? : sql server DBA

1177

---

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

2463

---

How do you open a cluster administrator? : sql server DBA

1100

---

how does an oracle clusterware manage crs resources?

1086

---