Describe the delete set-to-null option (for implementing a referential integrity constraint)
What will be an ideal response?
The delete set-to-null option allows a record to be deleted if its primary key value is referred to by a foreign key value of a record in another relation. As a consequence, in all of the records where the foreign key value refers to the primary key of the record that is being deleted, the value of the foreign key is set to null.
You might also like to view...
It easier to persuade a competitor's customer to switch to product or service in the:
A) introduction stage of the product life cycle. B) growth stage of the product life cycle. C) maturity stage of the product life cycle. D) decline stage of the product life cycle.
Even though it is often said that ignorance of the law is no excuse, the courts have sometimes allowed recovery if one or both parties to an illegal bargain are ignorant of the facts that made the bargain illegal.
Answer the following statement true (T) or false (F)
Many companies are ________ project work to contractors and consultants as a means of dealing with the peaks and valleys of resource allocation among projects.
Fill in the blank(s) with the appropriate word(s).
Which of the following is the best tip for replying to e-mail messages?
A) Reply to an e-mail message immediately because reading additional e-mail messages before replying might confuse you. B) If you can't reply immediately, acknowledge receipt of the message and tell the sender when you'll be able to reply. C) Include the sender's entire original message in the body of your reply to clarify the meaning of your response. D) Retain the original subject line to identify a conversation thread even if the topic shifts.