Answer Posted / deepak

alter index <indexname> rebulid;

What are the different sql server versions you have worked on? : sql server DBA

1009

---

How to start SQL Server in minimal configuration mode?

7966

---

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

2487

---

How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

2466

---

What are the commands used in dcl? : sql server DBA

1070

---

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

1134

---

currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba

2434

---

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

1076

---

how can you enable flashback feature?

949

---

what are the types of connection load-balancing?

996

---

what is asm?

1046

---

I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB

1934

---

What is dcl? : sql server DBA

1265

---

What are the different types of database compression introduced in sql server 2008? : sql server DBA

1102

---

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

2459

---