What is a field in a table that appears as a match of the primary key - ProProfs Discuss
Topics
Products
Follow Us:

What is a field in a table that appears as a match of the primary key in another table called?



A. Candidate key
B. Secondary Key
C. Foreign Key
D. Composite Key

This question is part of Database Quiz 1
Asked by Stmonicas, Last updated: Jul 10, 2020

+ Answer
Request

2 Answers

C. Block

Find happiness in writing new things.

C. Block, English Professor, M.A, Ph.D, Buffalo

Answered May 02, 2019

C is the answer to this question. This can be related to the primary key but this time, when you click on the foreign key, it will refer you to the primary table. One table may have more than one foreign keys. It will depend on the data that will be placed on the table. Each foreign key will be placed differently by the database system.

There are also instances when a foreign key can be used to refer to a constraint that is unique in nature. This will always depend on the person who is managing and handling the database on how foreign keys can be used and how many foreign keys can be available for every primary table.

 

John Smith

John Smith

Answered Feb 17, 2017

Foreign Key
 

Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer

Email Sent
We have sent an email to your address "" with instructions to reset your password.