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

Explain various On-Delete options in a DB table. Which is the default option?

0 Answers   Akamai Technologies,

What is the purpose of the tempdb database?

0 Answers  

How to create a login account in ms sql server to access the database engine using "create login" statements?

0 Answers  

How do I run a trace in sql server?

0 Answers  

How to delete duplicate rows in sql server?

0 Answers  

What is the difference between update lock and exclusive lock?

0 Answers  

Working with TLogs

0 Answers  

What is sql server profiler trace data file?

0 Answers  

What are the differences between DDL, DML and DCL in SQL?

0 Answers   ABB, Aspire, Infogain,

What is molap and its advantage? : sql server analysis services, ssas

0 Answers  

What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?

0 Answers  

what are the main differences between ms access and sqlserver

1 Answers   C DAC, CDAC,

For more SQL Server Interview Questions Click Here
Categories