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 are the characteristics of modern DBMS?

0 Answers   Ericsson,

---

What is clustered primary key?

0 Answers  

---

What is user-defined inline table-valued function?

0 Answers  

---

wht's the differece between sqlserver05 and sqlserver2000

3 Answers  

---

In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

0 Answers  

---

---

WHAT OPERATOR PERFORMS PATTERN MATCHING?

2 Answers   CarrizalSoft Technologies, CTS,

---

What is the difference between login and a user?

13 Answers   CTS, TCS,

---

What is the importance of three tier architecture?

0 Answers   QuestPond,

---

why we use cursor?

4 Answers   CarrizalSoft Technologies, Melstar, TCS,

---

if a parameter is not send to a stored procedure what type of identifier is to be used in Stp and if that parameter is not feed to the a query inside the Stp how to validate with out useing IF condition

1 Answers   Aviva,

---

Explain the truncate command?

0 Answers  

---

i need to know how i display department which has salary > =5000 for the below table Department ----------- salary deptname 1000 a 3000 a 2000 b 3000 b 4000 c 5000 c kindly send the query to thilakvinoth13@gmail.com

6 Answers  

---