In context of databases consider set operations on relation R and S, and select a true statement :
डाटाबेस के संदर्भ में रिलेशन R तथा S पर सेट ऑपरेशनों पर विचार करें तथा सत्य कथन का चुनाव कीजिए :
Pick an option to check yourself, or open the answer below.
Show answer & explanation
Correct answer: C. (R – S) ∩ (S – R) = φ
Explanation
R − S has tuples only in R and S − R tuples only in S; no tuple can be in both, so (R − S) ∩ (S − R) = φ. Their union is the symmetric difference, not φ, R ∩ S or R ∪ S in general.
R − S में केवल R के और S − R में केवल S के टपल हैं; कोई टपल दोनों में नहीं हो सकता, अतः (R − S) ∩ (S − R) = φ।
More Database Management & SQL questions
- In context of 2-phase locking protocol in DBMS, a transaction issues lock requests in ......... phase and unlock requests in ........ phase.
- Choose the SQL commands to perform following operations on a relation R : I : Retain Relation R in database, but delete all tuples in R. II…
- If the following functional dependencies holds on a selection R : A → B, A → C, BC → D, C → F, B → E, then which of the following dependenc…
- The ........... of weak entity set distinguishes among all those entities in the weak entity set that depends upon one particular strong en…
- A function that has no partial functional dependencies is in …….. form.
- Which of the following is not a valid aggregate function ?