Answer Posted / sd

Normalization is process of reducing redundancy of a
database , by decomposing the database into several smaller
files ( tables) and using the concept of codification

Forms 1NF,2NF,#NF , boyce codd NF

What is the difference between functions and scalar functions?

1124

---

How to delete an existing database user?

968

---

If a table does not have a unique index, can a cursor be opened on it?

872

---

Explain candidate key, alternate key, and composite key?

939

---

how do you test proper tcp/ip configuration windows machine? : Sql server database administration

998

---

How to list all login names on the ms sql server?

1078

---

what is checksum in sql server.........???

1618

---

what are the core components of SSRS?

121

---

What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?

840

---

Explain steps of normalization?

939

---

Can we linked SharePoint to a SQL database?

971

---

What are the advantages of using cte?

951

---

What is the full form of ddl?

864

---

whats new about truncate in sql server 2008?

2440

---

Is it important for a database administrator to understand the operating system and file access?

929

---