Answer / arun anoop m

1)1NF
->it has a primary key.
->Each column is atomic.
2)2NF
->It is in 1NF
-> Every non-key column is fully functinally dependend on
primary key.
3)3NF
->It is in 2NF
->Every non-key column is functinally dependend only on
primary key.
->non-key column cant be dependend on another non-key colum.

What is difference between global temporary tables and local temporary tables?

0 Answers   Tech Mahindra,

---

Explain system rowset functions?

0 Answers  

---

What are the 7 disadvantages to a manual system?

0 Answers  

---

Difference between writing SQL query and stored procedure ?

15 Answers   Cognizant, Infosys, TCS, Veritas,

---

How to rename an existing column with sql server management studio?

0 Answers  

---

What are the various Operating system files that every SQL server 2005 database has and what is the purpose.

0 Answers   Microsoft,

---

how to avoid cursors? : Sql server database administration

0 Answers  

---

How can I track the changes or identify the latest insert-update-delete from a table?

0 Answers  

---

1. How to fetch all the duplicate records from the table. 2. How to fetch the second highest salary from the table.

12 Answers   Accenture,

---

What is the appropriate number of test cases that you can write on a database?

2 Answers   Microsoft,

---

What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security

0 Answers  

---

what is the output for this query select * from employee where 1=1;

4 Answers  

---