Answer Posted / kunal sain

tnsnames.ora

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

2678

---

what is ora 24313?what is the procedure to exclude that error?

2568

---

what do you understand by flashback feature of oracle?

993

---

What is the difference between the 2 operating modes of database mirroring? : sql server DBA

992

---

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

2151

---

which background process invoke at the time of upgradation tell me???

2727

---

what is a user-defined lock?

1062

---

What is the difference between dropping a database and taking a database offline? : sql server DBA

1065

---

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

2466

---

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

1185

---

What is dbcc? : sql server DBA

1283

---

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

1565

---

You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?

1983

---

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

3759

---

What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

1106

---