Define Foreign Key?

Question Posted / mohamed ibrahim

3 Answers
8565 Views
ADP, College School Exams Tests, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Define Foreign Key?..

Answer / vani

it is a primary key which is referenced to another table

Is This Answer Correct ?

19 Yes

5 No

Define Foreign Key?..

Answer / manoj pandey

Foreign Key is used to establish Referential Integrity/Constraint between 2 tables. Mainly it is a column in a table that uniquely identifies every record in another table. A table can have 1 or more than 1 FKs.

~Manoj (sqlwithmanoj.wordpress.com)

Is This Answer Correct ?

10 Yes

0 No

Define Foreign Key?..

Answer / pravati

foreign key of one table points to a primary key of another table.

Is This Answer Correct ?

1 Yes

0 No

Post New Answer

More SQL Server Interview Questions

Can you have a nested transaction?

4 Answers HCL,

there is a table having two columns no and name and the data is 1 A 2 B 3 C write a query that will result a horizontal output A,B,C

9 Answers tdfc, vsworx,

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

1 Answers

What types of replication are supported in sql server?

0 Answers

What is an execution plan?

0 Answers

How would you add a section to a table?

0 Answers

Define candidate key, alternate key, composite key.

13 Answers Infosys, Software India,

Explain differentiate between a having clause and a where clause?

0 Answers

What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security