What is Primary key and foreign key? Give an example

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

What do you mean by a dependent functionality in a build?

0 Answers   HCL,


What are the different types of stored procedures?

0 Answers  


How do you manipulate data?

0 Answers  


Difference between primary key and clustered index?

0 Answers  


sql database suspect We have a sql database that is showing as suspect. How can we recover?

0 Answers  






What are the components of dbms?

0 Answers  


IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

0 Answers  


What is mean by dml?

0 Answers  


i want table name basis on column name.

5 Answers  


What is lookup override?

0 Answers   Informatica,


Differencr Between DELETE and TRUNCATE?

3 Answers   ADP,


What will happen when a Rollback statement is executed inside a trigger?

1 Answers   Flextronics, Hexaware,


Categories