Register

ISRO2009-72

3,908 views

2 Answers

Best answer
7 votes
7 votes
Purpose of F.K. in a table is to ensure referential integrity. i.e the f.k of one table can only have the values that are in some unique/primary key of referenced table (or f.k. will have NULL VALUE), it can not have any unmatched values.
• selected by
User Avatar
1 votes
1 votes

 foreign key is a field (or collection of fields) in one table that uniquely identifies a row of another table

User Avatar
Voting & Accepting an answer helps improve the community
Answer:
← PreviousNext →
← Previous in categoryNext in category →

Related questions

5 votes
5 votes
2 answers
1
go_editor asked Jun 15, 2016
5,664 views
ISRO2009-71
Which of the following contains complete record of all activity that affected the contents of a database during a certain period of time? Transaction log Query language Report writer Data manipulation language
Which of the following contains complete record of all activity that affected the contents of a database during a certain period of time?Transaction logQuery languageRepo...
User Avatar
6 votes
6 votes
5 answers
2
Desert_Warrior asked Jun 3, 2016
4,372 views
ISRO2009-70
A locked database file can be Accessed by only one user Modified by users with the correct password Used to hide sensitive information Updated by more than one user
A locked database file can beAccessed by only one userModified by users with the correct passwordUsed to hide sensitive informationUpdated by more than one user
User Avatar
4 votes
4 votes
4 answers
3
ajit asked Oct 5, 2015
4,573 views
ISRO2009-69
The 'command' used to change contents of one database using the contents of another database by linking them on a common key field? Replace Join Change Update
The 'command' used to change contents of one database using the contents of another database by linking them on a common key field?ReplaceJoinChangeUpdate
User Avatar
Link Copied!