Question

Question 19 (1 point) 19. Which statement can help us to find out which phone has never been ordered by customers? a. select Products.ProdName, Orders.Quantity from Products left outer join Orders on Products.ProdID=Orders.ProdID where Orders. Quantity is null; b. select Products.ProdName, Orders.Quantity from Products right outer join Orders on Products ProdID=Orders.ProdID where Orders. Quantity is null: c. select Products ProdName, Orders. Quantity from Products inner join Orders on Products. ProdID=Orders.ProdID where Orders.Quantity is null; d. select Products. ProdName, Orders.Quantity from Products full inner join orders on Products. ProdID=Orders.ProdID where Orders.Quantity is null; Question 20 (1 point) 20. Suppose we execute the following statement select Products.ProdName. Orders.Quantity from Products right outer join Orders on Products ProdID=Orders.ProdID; In the final report, what should we see in last ProdName cell? a. iPhone b. Android c. Windows d. null

Answer 1

`Hey,

Note: If you have any queries related to the answer please do comment. I would be very happy to resolve all your queries.

19) OPTION B IS CORRECT

20) OPTION D IS CORRECT

Kindly revert for any queries

Thanks.