(A) select R.* from R, S where R.a=S.a
statement states that if R has duplicate tuples, then it will decide the join mutiplicity, so no need to filter out distict tuples
Please correct me if i am wrong !!!
Please explain me what does the D options do ?