Answer Posted / b.r.reddy

We can manually set the statistical values.
We can gather statistics in parallel mode.

how can you get actual data change values from previous transactions in oracle?

1071

---

What the different components in replication and what is their use? : sql server DBA

1032

---

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA

1001

---

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

2390

---

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

2601

---

How would you extract DDL of a table without using a GUI tool?

2475

---

When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

969

---

What is the default fill factor value? : sql server DBA

1103

---

What is dcl? : sql server DBA

1237

---

how can you schedule a job in database?

1095

---

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

4412

---

What authentication modes does sql server support? : sql server DBA

1190

---

i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

2042

---

how can you implement fine-grained auditing?

1110

---

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

2319

---