If a relationship has a cascade updates constraint, then if ________ in the parent table is changed, then the same change will automatically be made to any corresponding foreign key value.

Related MCQs

• Consider a hash table of size seven, with starting index zero, and a hash function (3x + 4)mod7. Assuming the hash table is initially empty, which of the following is the contents of the table when the sequence 1, 3, 8, 10 is inserted into the table using closed hashing? Note that ‘_’ denotes an empty location in the table.
• State true or false: If a relation consists of a foreign key, then it is called a referenced relation of the foreign key dependency.
• Drop Table cannot be used to drop a table referenced by a                    constraint.
• Drop Table cannot be used to drop a table referenced by a …………… constraint.
• What SQL command will allow you to change the table STUDENT to add the constraint named GradeCheck that states that the values of the Grade column must be greater than 0?
• State true or false i) A candidate key is a minimal super key. ii) A candidate key can also refer to as surrogate key.
• An                          consists of a search-key value and pointers to one or more records with that value as their search-key value.
• An ____________ consists of a search-key value and pointers to one or more records with that value as their search-key value.
• If several concurrent transactions are executed over the same data set and the second transaction updates the database before the first transaction is finished, the ____ property is violated and the database is no longer consistent.
• A relation is said to be in 3 NF if (i) it is in 2 NF (ii) non-key attributes are independent of one another (iii) key attribute is not dependent on part of a composite key (iv) has no multi-valued dependency