Answer Posted / kittu

by issuing above statement it freezes tablespace it won't
allow single transaction to datafile. by this time redologs are generated & excessive redologs also

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2669

---

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

2779

---

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?

3454

---

If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA

1078

---

What are the steps you will take to improve performance of a poor performing query?

2898

---

can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com

1805

---

Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

2162

---

what do you understand by fine-grained auditing?

1105

---

Explain materialized views and how they are used.

2498

---

What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

1166

---

What are the recovery models for a database? : sql server DBA

1181

---

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

4479

---

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

1251

---

What is dbcc? : sql server DBA

1352

---

how can a session indicate its interest in receiving alerts?

1095

---