What is Primary key and foreign key? Give an example

Question Posted / guest

4 Answers
9783 Views
TCS, I also Faced
E-Mail Answers

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 is raid? : SQL Server Architecture

0 Answers

how to use DTS package in 2000,2005,2008 in sql server

0 Answers Microsoft,

Is it possible to create trigger on views?

0 Answers

how can we know that how many users are connected in perticuler server??????

2 Answers

1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do

0 Answers CSC, IBM,

List the different types of joins?

0 Answers

How to use linked server?

0 Answers

What are four major operators that can be used to combine conditions on a where clause?

0 Answers

What is difference between rollback immediate and with no_wait during alter database?

0 Answers

What are the benefits of filtered indexes?

0 Answers

Differentiate between SQL and ORACLE joins and write their syntax.

0 Answers Global Logic,

What does it mean to be in union?

0 Answers

For more SQL Server Interview Questions Click Here