Answer Posted / guest

We can gather statistics on a table through>>

analyze table TABLE_NAME compute statistics , or

analyze table TABLE_NAME estimate statistics


Regards
Abhinav

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

1022

---

what do you understand by flashback feature of oracle?

993

---

what is a crs resource?

1166

---

What happens on checkpoint? : sql server DBA

1093

---

how can you implement fine-grained auditing?

1136

---

how can you communicate with operating system files from oracle?

1049

---

What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

1108

---

how can you record information about current session?

1047

---

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

1214

---

how to restore files with rman?

2302

---

Can you redefine a table online?

1115

---

how can you initialize log miner?

1143

---

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

1072

---

What are the different types of upgrades that can be performed in sql server? : sql server DBA

1208

---

what are the performance views in an oracle rac environment?

1053

---