Answer Posted / hari

Cursor : Curosr is allow row processing of the result set.
Static
Dynamic
forward-only
Key setdriven

What is explicit mode in sql server?

1055

---

What is the default sql server instance name?

1028

---

What is the full form of ddl?

920

---

Tell me what is the significance of null value and why should we avoid permitting null values?

979

---

Give an example of why you would want to denormalize a database

974

---

What are different types of replication in sql server?

1082

---

what method you can use to reduce the overhead of Reporting Services data sources?

253

---

What is database white box testing?

1119

---

What is logshipping and its purpose?

988

---

What method is used by the Command classes to execute SQL statements that return single values?

1062

---

What are sp_configure commands and set commands?

1018

---

How to trouble shoot if unable to connect SQL Server

1986

---

How real and float literal values are rounded?

1152

---

What is the difference between left and right outer join?

1056

---

How to recompile stored procedure at run time?

1067

---