Answer Posted / santosh

you can use dbms_stats package

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

1092

---

what are the differences of where and if in SAS?

2197

---

what functionality does oracle provide to secure sensitive information?

1001

---

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

2067

---

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

2736

---

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

2720

---

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

1192

---

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?

1985

---

internal architecture

2201

---

What is the default port no on which sql server listens? : sql server DBA

1164

---

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

1135

---

What is a system database and what is a user database? : sql server DBA

1240

---

What happens on checkpoint? : sql server DBA

1099

---

List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

1295

---

Why does Oracle not permit the use of PCTUSED with indexes?

2947

---