SQL Programming Language

Time: 00:00:00

Attempted

Not Attempted

Marked For Review

Attempted & Reviewed

Question 1 of 17

Consider the following table:

Product Table:

|Category|Product_Name|Product_Price|State|Country| |---|---|---|---|---| |Furniture|Chair|700 Rs|Colordo|US| |Furniture|Bed|2000 Rs|Colordo|US| |Electronics|TV|1200 Rs|Capetown|Africa| |Electronics|Radio|700 Rs|Delhi|India| |Leather|Bag|800 Rs|Mumbai|India| |Garments|Jacket|2300 Rs|Nairobi|Kenya|

Determine the name and price of the product of the US country. Select the correct option.

Select Your Answer:

SELECT product_name FROM product WHERE country= 'US'

SELECT product_name FROM product WHERE product_name IN (SELECT product_name FROM Product WHERE country= US)

SELECT product_name FROM product WHERE product_name IN (SELECT product_name FROM Product WHERE country= 'US')

Both (1) and (3)

None of the above

Mark for Review

All Questions

Attempted

Not Attempted

Marked for Review

Attempted & Reviewed

Current