77-885 · Question #119
James works as a Database Designer for Tech Perfect Inc. The company has a Windows Vista-based computer with Microsoft Office 2010 installed on it. The computer has a database named Accounts and two…
The correct answer is A. The related fields contain the same format. B. Table1 and Table2 are related to the same database. C. The common field is the primary key of the primary table. The following are required for establishing referential integrity between two tables: The common field is the primary key of the primary table. The related fields contain the same format. Both tables are related to the same database. Answer: D is incorrect. In order to…
Question
Options
- AThe related fields contain the same format.
- BTable1 and Table2 are related to the same database.
- CThe common field is the primary key of the primary table.
- DThe related field must have different formats.
How the community answered
(37 responses)- A73% (27)
- D27% (10)
Explanation
The following are required for establishing referential integrity between two tables: The common field is the primary key of the primary table. The related fields contain the same format. Both tables are related to the same database. Answer: D is incorrect. In order to establish referential integrity, it is required that both tables have the same format.
Topics
Community Discussion
No community discussion yet for this question.