Sign up now
to enroll in courses, follow best educators, interact with the community and track your progress.
Download
Referential integrity constraint question with solution( in Hindi )
494 plays

More

Nisha Mittal is teaching live on Unacademy Plus

Nisha Mittal
🌟 MCA Gold Medalist 🌟 Star Educator 🌟Gate Qualified 🌟YouTuber ☆🌟BOOK published on LINUX ADMINISTRATION by kalyani publisher ☆🌟 7+ years teac

Unacademy user
  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