Describe the update set-to-null option (for implementing a referential integrity constraint)
What will be an ideal response?
The update set-to-null option allows a record to be changed 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 being changed, the value of the foreign key is set to null.
You might also like to view...
Which of the following is a social factor that influences consumer buying behavior?
A) family B) life-cycle stage C) economic situation D) personality E) occupation
The primary reason managers are given power is to ______.
a. provide problem-solving for employees b. promote organizational culture c. achieve organizational objectives d. maximize profits
Which of the following is FALSE concerning the handshake?
a. The initial handshake in an interview helps to form a favorable first impression. b. Candidates with an impressive handshake are viewed by interviewers as having stronger social skills. c. The handshake is more important for men than for women in making a positive impression in the interview. d. All of the above are true.
An offer must be in a particular form to have legal effect
a. True b. False Indicate whether the statement is true or false