Database-Management-System
August 29, 2024Database-Management-System
August 29, 2024Database-Management-System
| Question 817 |
Let R1(a,b,c) and R2(x,y,z) be two relations in which a is the foreign key of R1 that refers to the primary key of R2 . Consider following four options.
- (a) Insert into R1
(b) Insert into R2
(c) Delete from R1
(d) Delete from R2
Which of the following is correct about the referential integrity constraint with respect to above ?
| Operations (a) and (b) will cause violation.
| |
| Operations (b) and (c) will cause violation. | |
| Operations (c) and (d) will cause violation. | |
| Operations (d) and (a) will cause violation. |
Question 817 Explanation:
In case of referential integrity Insertion into table containing the foreign key and Deletion from table whose Primary key is referred can cause the violation.
Correct Answer: D
Question 817 Explanation:
In case of referential integrity Insertion into table containing the foreign key and Deletion from table whose Primary key is referred can cause the violation.