Answer / monal

TO CREATE REFERENTIAL INTEGRITY BETWEEN 2 TABLE.

Answer / jagadeesh b

If you maintain this relation ship you can get more advantages

1)you can not delete primary table directly..

2)duplicate values are not allowed in primary key table.

3)Null values are not inserted into primary key table so
validation is very easy fro m front end.(for ex; .net 2005).

Answer / deepak

1) PRIMARY KEY IS USED AS UNIQUE KEY, FOR AVOID DUPLICATION.
2) FOR VALIDATING DATA FROM PRIMARY KEY TABLE FOREIGN KEY USE.

Answer / rajendraprasad cherukuri

To segregate the data in different tables belongs to a
particular entity so that data can be retrieved when
required more economically and in a faster way.

What do you mean by COLLATION?

4 Answers   ABC, BirlaSoft,

---

hi friends please answer this question ASAP:- how to count the no. of employee in a each department or no. of employee in each location by using emp/dept table

7 Answers   Indecomm,

---

Is sql server 2016 free?

0 Answers  

---

What is MSDE?

2 Answers  

---

explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

0 Answers  

---

---

John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?

0 Answers  

---

What is conditional split?

0 Answers  

---

Explain acid?

0 Answers  

---

Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?

0 Answers  

---

What is the difference between UNIQUE and DISTINCT keywords in DBMS?

1 Answers   Genpact,

---

What is the difference between cross join and Full outer join?

1 Answers   HP, Standard Bank,

---

Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication

0 Answers  

---