BASIC COMPUTER CONCEPTS
INFORMATION SYSTEMS VS INFORMATION TECHNOLOGY
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Foreign keys are the field that uniquelyrepresents each record in a table.
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
Explanation:
Detailed explanation-1: -A foreign key is a column or columns of data in one table that refers to the unique data values–often the primary key data–in another table. Foreign keys link together two or more tables in a relational database.
Detailed explanation-2: -A foreign key can refer to either a unique or a primary key of the parent table.
Detailed explanation-3: -Foreign keys uniquely identify the table in which they are present. Foreign keys are the primary keys of some related tables. The values present in the foreign key column must be present in the primary key of the related table.
Detailed explanation-4: -Q 26-Which of the following is not true about a FOREIGN KEY constraint? A-It is a referential integrity constraint.
There is 1 question to complete.