Answer Posted / krishna chaithanya

index allows to search record in a table making the search
meachnism faster and effective

Explain about merge replications?

1031

---

Tell me what is difference between view and materialized view?

943

---

What is @@error in sql?

1072

---

Explain a differential backup?

1014

---

What area unit the various kinds of info compression introduced in sql server 2008?

1100

---

Can we perform backup restore operation on tempdb? : sql server database administration

1002

---

How to verify the port number of the sql server?

1169

---

Explain cross join or cartesian product in sql?

894

---

How do you delete duplicate records in sql server?

1067

---

What is store procedure? How do they work? When do you use?

949

---

What is 2nf normalization?

1033

---

How to get a list of columns in a view using "sys.columns" in ms sql server?

995

---

What is the default schema of your login session in ms sql server?

1051

---

What is the difference between migration and upgradation in sql server?

1101

---

what are the different types of replication you can set up in sql server? : Sql server database administration

1031

---