Which of the following is a rule of referential integrity??

A. ?A record can be added to a related table even if a matching record exists in the primary table.
B. ?The value of the primary key in the primary table cannot be changed if matching records exist in a related table.
C. ?A record in the primary table can be deleted if matching records exist in the related table.
D. ?The Cascade Delete Related Records option cannot be used to delete records in the primary table as well as in a related table.


Answer: B

Computer Science & Information Technology

You might also like to view...

You can control which shape appears on top by changing the ____________________ of layers.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology

Many compilers automatically set all elements of integer-valued and real-valued arrays to ____.

A. blanks B. zeros C. null D. ones

Computer Science & Information Technology

Your network has been segmented into the following security zones. Zone 1 connects to the Internet through a router. Zone 2 is a closed research and development network. Zone 3 contains an intermediary switch supporting a SAN, dedicated to long-term audit log and file storage. Zone 4 contains a DMZ with an email server The company has budgeted for a single patch server. To which zone should this

limited resource be deployed? A. Zone 1 B. Zone 2 C. Zone 3 D. Zone 4

Computer Science & Information Technology

The _____ attribute of the output element sets the system identifier in the declaration.

A. ?doctype-public B. ?encoding C. ?version D. ?doctype-system

Computer Science & Information Technology