radha1 Posted January 6, 2008 Share Posted January 6, 2008 Question 36: There are 19 rows in the Titles table and 9 rows in the Publishers table of the SQL Server 2000 database PUBS. The result of executing the query below returns only 18 rows.SELECT title, pub_nameFROM Titles INNER JOINPublishers ON titles.pub_id = publishers.pub_idWhich of the following statements correctly describe a possible reason why all 19 rows of the Titles table are not returned? A. There is a row in the Titles table with a publisher that has no matching value in the Publishers table. B. There is a row in the Titles table with a NULL value in the pub_id column. C. There is a row in the Publishers table with a publisher that has no matching value in the Titles table. D. There is a row in the Publishers table with a NULL value in the pub_id column. E. There is a row in the Titles table that contains a publisher with no titles. Link to comment Share on other sites More sharing options...
Skemcin Posted January 6, 2008 Share Posted January 6, 2008 Do your own homework. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.