BUSINESS ADMINISTRATION
COMPUTER APPLICATION IN BUSINESS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
A table can have only one foreign key
|
|
True
|
|
|
False
|
Explanation:
Detailed explanation-1: -A table can have multiple foreign keys based on the requirement.
Detailed explanation-2: -A table with a foreign key reference to itself is still limited to 253 foreign key references. Greater than 253 foreign key references are not currently available for columnstore indexes, memory-optimized tables, Stretch Database, or partitioned foreign key tables. Stretch Database is deprecated in SQL Server 2022 (16.
Detailed explanation-3: -The foreign key values in a table can be null. The foreign key may contain duplicate values. A table may have more than one foreign key. The parent table records can be deleted if no child table record exists.
There is 1 question to complete.