Answer Posted / ashwani

2 tier is client server application or in 2 tier one layer
acts as web+App and another as data layer.
in 3 tier one is web layer 2nd is app layer and third is
data layer.
web layer = where client end code resides
app layer = where business logic of application resides
data layer = database layer where database resides

What is a unique key constraint?

967

---

Explain what are the different index configurations a table can have?

1036

---

Can you change the data type of a column in a table after the table has been created? If so, which command would you use?

975

---

What do you mean by sql server 2005 express management tools?

1249

---

What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks

1987

---

What the different components in replication and what is their use?

912

---

What is the contrast amongst drop and truncate?

978

---

What are system databases into sql server (2005/2008) : sql server database administration

963

---

What is difference between rownum and rowid?

854

---

Explain Normalization and DE normalization

1052

---

What is the difference between a check constraint and a rule?

1129

---

what is the maximum size of a row? : Sql server database administration

939

---

How to download and install sql server 2005 books online?

1082

---

What is BCNF? How is it better than 2NF & 3NF?

963

---

Explain iaas, paas and saas?

90

---