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 )
944 plays

More

Nisha Mittal is teaching live on Unacademy Plus

Nisha Mittal
🌟 MCA Gold Medalist 🌟 Star Educator 🌟Gate Qualified 🔴UGC NET qualified🔴🌟YouTuber ☆🌟BOOK published on LINUX ADMINISTRATION by kalyani publish

U
Unacademy user
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
Arpita Sharma
2 years ago
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 :)
A
done mam please upload more questions
  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