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 are primary keys and foreign keys?

Question Posted / guest

Answers were Sorted based on User's Feedback



What are primary keys and foreign keys?..

Answer / nevual

Primary keys are the unique identifiers for each row. They
must contain unique values and cannot be null. Due to their
importance in relational databases, Primary keys are the
most fundamental of all keys and constraints. A table can
have only one Primary key.
Foreign keys are both a method of ensuring data integrity
and a manifestation of the relationship between tables.

Is This Answer Correct ?    7 Yes 0 No

What are primary keys and foreign keys?..

Answer / sudarsan

Primary key is a unique id for each table. This prevents
duplication of records. Each table can have a single
primary key. They can be refrenced by any tables as a
foreign key.

Is This Answer Correct ?    4 Yes 0 No

What are primary keys and foreign keys?..

Answer / jai prakash chauhan

Primary keys are by default clustered index.

Is This Answer Correct ?    3 Yes 2 No

What are primary keys and foreign keys?..

Answer / hr@tgksolutions.com

• Primary Key: A unique identifier for a table’s record (e.g., id in a table).
• Foreign Key: A column in a table that refers to the primary key of another table, establishing a relationship between tables.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

please differentiate between delete and truncate?

0 Answers  

How do I completely remove sql server instance?

0 Answers  

What is the native system stored procedure to execute a command against all databases?

0 Answers  

What is the basic difference between clustered and a non-clustered index?

9 Answers   Infogain,

What are data files?

0 Answers  

1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

0 Answers  

default databases available in sql server and there uses ?

4 Answers   TCS,

What is scan table/view and seek table/view when its occurs? : sql server database administration

0 Answers  

select names starts with a,b,c

8 Answers   Scope International,

Selet all the data from table where last name is n of employee

2 Answers  

How ssrs maintain security?

0 Answers  

What is the difference between indexing and hashing?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories