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 Primary key and foreign key? Give an example

Question Posted / guest

Answers were Sorted based on User's Feedback



What is Primary key and foreign key? Give an example..

Answer / vipin

Primary key which enforce the uniqueness in each row og table .
Foreign key win which the existing value in table must be there in other table .
diffrence is that PK does not allow Null Values anf FK allow null values

Is This Answer Correct ?    17 Yes 2 No

What is Primary key and foreign key? Give an example..

Answer / brajesh kumar srivastava

Primary key enforce uniqueness of column and deny to allow
null values to this column and enforce referential data
integrity constraint to other table column which is call
foreign key.
Foreign key column may contain null value

Is This Answer Correct ?    4 Yes 1 No

What is Primary key and foreign key? Give an example..

Answer / aaaaaaaaaaaaa

Primary key is a primary key that is an attribute.

Is This Answer Correct ?    4 Yes 4 No

What is Primary key and foreign key? Give an example..

Answer / alquama rizvi

MS-Access requires a special way of recognising every record of a table. For this you have to set or make a primary key. If you do not do so, MS-Access does this itself by adding a new field , serving as the primary key. A table may have only one primary key, although it may have more than one fields.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

Explain what you mean by 3 tier architecture.

0 Answers   TCS,

What do you know about system database? : SQL Server Architecture

0 Answers  

9. Write a query to list a new column with the difference in temp of the cities Delhi and Mumbai, Mumbai and Jammu and soon. Consider the following table : City_id City Temp. 1 delhi 40 2 Mumbai 35 3 Jammu 32 4 Pune 18

2 Answers  

What is the difference between locking and multi-versioning?

0 Answers  

What is difference between primary key and foreign key?

0 Answers  

How to Check if table exists in sql server?

0 Answers  

How to create a store procedure with encryption?

0 Answers  

What is openrowset sql server?

0 Answers  

what is statistics

1 Answers  

Can the query output be sorted by multiple columns in ms sql server?

0 Answers  

What are translations and its use? : sql server analysis services, ssas

0 Answers  

Do you know what are the restrictions applicable while creating views? : SQL Server Architecture

0 Answers  

For more SQL Server Interview Questions Click Here
Categories