Answer Posted / santosh

you can use dbms_stats package

how can a session indicate its interest in receiving alerts?

1091

---

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

1154

---

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?

2042

---

how can you record information about current session?

1100

---

what functionality does oracle provide to secure sensitive information?

1048

---

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

1138

---

What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

1058

---

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

1181

---

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

2123

---

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

1191

---

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

2453

---

What is the difference between clustered and non-clustered index? : sql server DBA

1141

---

What is transparent data encryption? : sql server DBA

1251

---

Where do you find the default index fill factor and how to change it? : sql server DBA

1121

---

what are the benefits of flashback feature?

1089

---