Practice mode DBMS and SQL

Supply(s, p) contains (s1,p1), (s1,p2), (s2,p1), (s3,p1), (s3,p2), (s3,p3), and Parts(p) contains p1 and p2. What is Supply divided by Parts?

Correct answer A. {s1, s3}

Explanation

Division returns each s value that is paired in Supply with every p value in Parts, which answers "suppliers who supply all the listed parts". s1 supplies p1 and p2, and s3 supplies p1 and p2 (plus p3, which is allowed). s2 supplies only p1, so it is excluded. The answer {s3} wrongly demands an exact match with Parts rather than a superset.

Report a problem

Answer checked How we write and check questions

Tip: press A, B, C or D to answer, and N for the next question.

Advertisement

Have a question about this answer?

Your email address will not be published. Required fields are marked *

Links and website addresses are not allowed in comments.