Multiple choice

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|

  1. SELECT product SET product_name='Jeans' WHERE product_price> 2000

  2. UPDATE product _nameSET product_name='Jeans' WHERE product_price> 2000

  3. UPDATE product SET product_name='Jeans' WHERE product_price> 2000

  4. UPDATE product SET product_name='Jeans' WHERE product_price IN (Select MAX (product_price) from product)

  5. None of the above
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

This is the correct SQL query for the specified result.

Keep practicing — related questions