Referential integrity refers to______________
A) The enforced uniqueness of a row in a table
B) The enforced uniqueness of a column in a table
C) Ensuring that a Foreign Key attribute cannot be NULL
D) The enforced synchronization of Primary Key and Foreign Key values
i say is D the answer mainly because that way you ensure the integrity of data by, for example, avoiding orphan records and is part of the basis of db relational theory.
however, this question is hard because of A.
thus, if this is multiple choice, i definitely say is A and D.
however, if this choosing only one answer, i say this is definitely D.
By Stefan Grünwedel in forum Database
Last Post: 01-04-2002, 03:32 PM
By Deb H. in forum Database
Last Post: 01-08-2001, 09:56 AM
Last Post: 10-27-2000, 02:32 PM
By Chris Hunter in forum Database
Last Post: 09-27-2000, 01:00 AM
By Aaron in forum VB Classic
Last Post: 03-17-2000, 04:24 PM
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL