Answer Posted / ramesh l.v.

Normalization is the process of efficiently organizing data
in a database. There are two goals of the normalization
process: eliminating redundant data and ensuring data
dependencies make sense

Explain what is the difference between union and union all?

1070

---

What are rows and columns?

1066

---

Explain logical operators in sql server?

1184

---

Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

1124

---

What is a db view?

951

---

What are the default system databases in sql server 2000?

1084

---

What is model database? : SQL Server Architecture

1192

---

Explain the dbcc pintable command when would you use it?

971

---

What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?

1023

---

What is multilevel indexing?

981

---

Explain filestream storage of sql server 2008?

1080

---

Explain the concept of view and Types of views in SQL server?

1037

---

Explain a checkpoint?

1089

---

Which is better statement or preparedstatement?

984

---

Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio

954

---