Answer Posted / pandian s

1.2nd Normal Form is the 'BEST' in real time scenario.

2.But, The 3rd Normal Form is good in theoritical ONLY not
in REAL TIME SCENARIO.

3.The 2nd Normal form tells "Eliminating Redundant of
Data" - The repeatition of data should be in seperate table
and mapped with parent table (PARENT - CHILD Relationship,
What we using in real scenario (Primary Key & Foreign Key).

4.The 3nd Normal form tells "Eliminating Data that is not
part of KEY" - The each and every columns' data should be a
part of KEY.

ie: We have Student(RollNo, StudName, Class, Phone,..)
table. Each columns' data should be referred from KEY
columns.

"RollNo" should be referred from Parent ROLL Table,
"StudName" should be referred from Parent NAME Table,
"Class" should be referred from Parent CLASS Table,
"Phone" should be referred from Parent PHONE Table

Finally, 2nd NF is BETTER than 3rd NF.

What is the difference between char and varchar2 datatype in sql?

1049

---

Define inner join? Explain with an example?

958

---

Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?

977

---

What is change data capture (cdc) feature?

1040

---

Explain triggers?

983

---

How does recursive cte works in sql server?

982

---

What is merge statement?

1064

---

What are the tools available in market as an alternative to sql server reporting services?

129

---

How will you find out if there are expensive SQL statements running or not?

996

---

Explain how to maintain a fill factor in existing indexes?

971

---

Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

1840

---

what is sql server? : Sql server database administration

969

---

What is the difference between locking and multi-versioning?

971

---

List all the types of user-defined functions?

1067

---

How to connect to SQL Azure Database by using sqlcmd?

136

---