to enroll in courses, follow best educators, interact with the community and track your progress.
29 lessons,
3h 12m
Enroll
320
Referential integrity constraint question with solution( in Hindi )
944 plays

More

## Nisha Mittal is teaching live on Unacademy Plus

U
Hi mam. i started to see your DNA from today but i wasted too much time to find the news in hindu so its humble request to mebtion the page number and also mentioned either the news from Hindu or any other NP... Thanks
this is the hindu course so current affairs will be from The Hindu only . page numbers were not mentioned only in today's lesson .. in the previous lessons i have marked the pages as well and will mention in future also :)
S
Thanks mam
LJ
thank you mam
A
1. REFERENTIAL INTEGRITY CONSTRAINT

2. REFERENTIAL INTEGRITY CONSTRAINT

3. REFERENTIAL INTEGRITY CONSTRAINT

4. Let R(a,b,c) and S(d,e,f) be two relations in which d is the foreign key of S that refers to the primary key of R. Consider the following four operations R and S. I. Insert into R Il Insert into S Ill Delete from R IV. Delete from S Which of the following can cause violation of the referential integrity constraint above? A. Both I and IV B. Both Il and IlI C. All of these D. None of these

5. Let R(a,b,c) and S(d,e,f) be two relations in which d is the foreign key of S that refers to the primary key of R. Consider the following four operations R and S. I. Insert into R Il Insert into S III. Delete from R IV. Delete from S Which of the following can cause violation of the referential integrity constraint above? A. Both I and IV B. Both Il and IlI C. All of these D. None of these a(PK d(FK)e 4 4

6. l Insert into R cannot cause any violation. O Insert into S can cause violation if any value is inserted into d of S, which value is not in a of R. a(PK) b d(FK) e 4 4

7. Delete from S would cause no violation Delete from R would cause violation if it any tuple is deleted,and as a result a value in a gets deleted which is refereed to by d in S. O a(PK)b d(FK) e 4 4

8. Insert into R cannot cause any violation. O Insert into S can cause violation if any value is inserted into d of S, which value is not in a of R. Delete from S would cause no violation. O Delete from R would cause violation if it any tuple is deleted,and as a result a value in a gets deleted which is refereed to by d in S. a(PK)b d(FK)e 4 4

9. Let R(a,b,c) and S(d,e,f) be two relations in which d is the foreign key of S that refers to the primary key of R. Consider the following four operations R and S. I. Insert into R Il Insert into S III. Delete from R IV. Delete from S Which of the following can cause violation of the referential integrity constraint above? A. Both I and IV B. Both II and IIIInsert into R cannot cause any violation. C. All of these Insert into S can cause violation if any value is inserted into d of S, which D. None of these value is not in a of R. Delete from S would cause no violation. Delete from R would cause violation if it any tuple is deleted,and as a result a value in a gets deleted which is refereed to by d in S

10. Let R(a,b,c) and S(d,e,f) be two relations in which d is the foreign key of S that refers to the primary key of R. Consider the following four operations R and S. I. Insert into R Il Insert into S III. Delete from R IV. Delete from S Which of the following can cause violation of the referential integrity constraint above? A. Both I and IV B. Both Il and IlI c. All of theInsert in D. None of t to R ca nnot cause anv violation Inse d of S, which ', INB. Both II and ill t valu Dele Delete from R would ca use violation if it any tuple is deleted,and as a result a value in a gets deleted which is refereed to by d in S