 Related Questions Referential integrity refers to the consistency that must be maintained between primary and foreign keys, ie every foreign key value must have a corresponding primary key value. Latest Answer : the relation of the primary key of a base table with foreign key of the reference table is known as referential integriety. ... To maintain the integrity of DB2 objects the DBD permits access to only on object at a time. Lock contention happens if several objects are required by contending application processes simultaneously. Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time? Never. Such processing could produce duplicate values violating entity integrity. Primary keys must be updated one at a time. Never. New primary key values are not a problem. However, the values of foreign key inserts must have corresponding primary key values in their related tables. And updates of primary key values may require A table called EMPLOYEE has the following columns: name, department, and phone_number. Which can limit read access to the phone_number column? A table called EMPLOYEE has the following columns: name, department, and phone_number. Which of the following can limit read access to the phone_number column? A. Using a view to access the table B. Using Which one of the following does not help to maintain referential integrity?a. Unique constraintsb. Primary keysc. Cascading actions d. Foreign keys Latest Answer : Answer is be Unique constraints. ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
