Answer Posted / ravindra

create pfile from spfile;

Which autogrowth database setting is good? : sql server DBA

1049

---

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?

2612

---

Where would you look for errors from the database engine?

2787

---

how can you generate profile of pl/sql applications to identify performance bottlenecks?

1021

---

how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?

3343

---

What is a correlated sub-query? : sql server DBA

1004

---

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

1105

---

what are the performance views in an oracle rac environment?

999

---

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

2743

---

how does an oracle clusterware manage crs resources?

1025

---

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

2407

---

What is fill factor? : sql server DBA

1181

---

Explain about your sql server dba experience? : sql server DBA

1022

---

who owns the operating system files created by the utl_file package?

1009

---

What are the different types of database compression introduced in sql server 2008? : sql server DBA

1037

---