As of last week bigsortcom had servers that use 4kb

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: t answers on the answer sheet (not here!) [2.5pt] a. SELECT owner FROM dogs WHERE breed = “greyhound” AND owner NOT IN (SELECT dogid FROM photos); b. SELECT owner FROM dogs, photos WHERE dogs.breed = “greyhound” AND dogs.dogid != photos.dogid; c. SELECT owner FROM dogs WHERE breed = “greyhound” AND dogid NOT IN (SELECT dogid FROM photos); d. SELECT owner FROM dogs LEFT OUTER JOIN photos ON dogs.dogid = photos.dogid WHERE photos.photo IS NULL; e. SELECT owner FROM dogs RIGHT OUTER JOIN photos ON dogs.dogid = photos.dogid WHERE photos.photo IS NULL; c (a) would fail to return owners who have other dogs that do have photos. (b) would fail if there’s at least 1 non- matching photo in the photos table. (d) and (e) fail because they 4 don’t select for “greyhound”s, but (d) would’ve succeeded if we hadn’t forgotten to put that in there. Oops! 8. How many rows are returned by R x R for a...
View Full Document

Ask a homework question - tutors are online