Answer Posted / krishna

int data type

Define right outer join?

929

---

Which tcp/ip port does the sql server run on? How can it be changed?

993

---

How you can find out if an index is useful to the optimizer?

870

---

What is plan freezing?

907

---

How to drop an existing table?

957

---

What is acid properties?

1014

---

What is cached report?

135

---

What is meant by referential integrity?

956

---

How to find the service pack installed? : sql server database administration

970

---

What are the system database in sql server 2008?

974

---

Tell me what is difference between clustered and non clustered index?

896

---

What is the difference between function and stored procedure in sql server?

986

---

What does the on update no action do?

960

---

How to list all user names in a database?

1003

---

Do you know the different ddl commands in sql?

993

---