How do you define a foreign key?



How do you define a foreign key?..

Answer / Osh Gupta

A Foreign Key is a field in one table that refers to the primary key of another table. It's used to establish a relationship between two tables, ensuring referential integrity by preventing actions such as deleting a record from the parent table if there are related records in the child table.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What are string functions in sql?

1 Answers  


From an Employee table, how will you display the record which has a maximum salary?

29 Answers   Cap Gemini, Exilant, Synechron,


What is the use of desc in sql?

1 Answers  


I need a exceptoin in pl/sql block so that if any errors occur in the block then no exception should errors should raise?

1 Answers  


What is the difference between a primary key and a clustered index?

1 Answers  


What is difference between TRUNCATE & DELETE?

16 Answers   Ahn Infotech, CitiGroup, ICICI, PreVator, Saama Tech, SkyTech, TCS,


What can be a size of a pl/sql block? Is there any limit?

2 Answers  


What is having clause in sql?

1 Answers  


In a package if we have 10 procedures or functions,How to know which will execute first?

1 Answers   Sollet Soft,


How do I create a sql script?

1 Answers  


Why are aggregate functions called so?

1 Answers  


What does the file extension accdb stand for?

1 Answers  


Categories