Answer Posted / hari

Normalization is the process of designing the datamodel and
effocientely store the data in database.to reduce the
redundancy.
1Normal form: Elimanate the repeating groups for individual
table
-Create sepeare table for each set of related data
-identify the each set of related data with a primary key
2nd normal form : create separate table for set of values
that apply the multipule records.
--Releate these tables with a forgign key
3rd Normal Form : Eliminate fields that do not depend on
the key

Difference between report and query parameter. Why do we need different type of parameter?

932

---

How to execute a sql statement using odbc_exec()?

1117

---

Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many

925

---

What is analysis service repository?

1008

---

What are the differences between DDL, DML and DCL in SQL?

1204

---

What are different types of subquery?

1212

---

List types of tables in SQL Azure?

126

---

What is the default server name for sql server?

1140

---

How the authentication mode can be changed?

1111

---

How do I find the sql server instance name?

954

---

What is inline variable assignment?

1001

---

How do I find sql server instance name?

946

---

Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?

946

---

How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?

1077

---

Which tcp/ip port does the sql server run on? How can it be changed?

1031

---