Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

What is the use of placing primary key and foreign key
constrains on columns.

Question Posted / durga prasad

Answers were Sorted based on User's Feedback



What is the use of placing primary key and foreign key constrains on columns...

Answer / monal

TO CREATE REFERENTIAL INTEGRITY BETWEEN 2 TABLE.

Is This Answer Correct ?    3 Yes 0 No

What is the use of placing primary key and foreign key constrains on columns...

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).




Is This Answer Correct ?    3 Yes 0 No

What is the use of placing primary key and foreign key constrains on columns...

Answer / deepak

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

Is This Answer Correct ?    1 Yes 0 No

What is the use of placing primary key and foreign key constrains on columns...

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.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

Why de-normalization required?

0 Answers  

How to round a numeric value to a specific precision?

0 Answers  

What is referential integrity and how is it achieved?

1 Answers   Adea Solutions,

What is stored procedures?

0 Answers  

How are the unique and primary key constraints different?

0 Answers  

What languages bi uses to achieve the goal?

0 Answers  

What is the Difference beween sql server 2005 and sql server 2008

3 Answers   CMC, Hitech,

How to add a new dsn with the odbc driver for sql server?

0 Answers  

How to connect of datebase with sql express.?

0 Answers   MCN Solutions,

What is cdc in sql server?

0 Answers  

What are the new features in SQL Server 2005 when compared to SQL Server 2000?

0 Answers  

How To Find That One Week Change in My DataBase we Have Done Like We Have A database Test I Change Table,Stored Procd. Then I Find Which SP,Table We Have Edit/Change in Seven Dayes

1 Answers   INDUS,

For more SQL Server Interview Questions Click Here
Categories