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

How to enter binary string literals in ms sql server?

0 Answers  

Why use triggers?

0 Answers  

What is the basic functions for master, msdb, tempdb databases?

2 Answers   CSC,

Explain the concept of view and Types of views in SQL server?

0 Answers   HCL,

How to execute function in stored procedure sql server?

0 Answers  

How to Display, Amount of Disk Activity Generated by Transact-SQL Statements?

1 Answers  

what are the critical issues you have resloved in your company

0 Answers   Wipro,

Is it possible we can connect our SQL database to GUI application? If it is yes than how tell me the explanation

2 Answers  

How to insert a new row into a table with "insert into" statements in ms sql server?

0 Answers  

What is system stored procedures?

0 Answers  

Do you know what is similarity and difference between truncate and delete in sql?

0 Answers  

Does server sql treat char as a variable-length or fixed-length column?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories