Jump to content

sqlserver


radha1

Recommended Posts

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...