VID VName Reg LocationV001 Mother Dairy 20-01-2009 Delhi V002 Havmor 0

1.	VID VName Reg LocationV001 Mother Dairy 20-01-2009 Delhi V002 Havmor 01-04-2015 Gujrat V003 Amul 12-05-2012 Kolkata V004 Kwality Walls 15-10-2013 Mumbai (i) Write a Query to display all records (ii) Write a Query to add a new row with the following details (‘V005’, ‘Vadilal’, ‘2010-03-20’, ‘Pune’) (iii) Write a query to modify the location of V003 from Kolkata to Gujrat.(iv) Write a Query to delete the record of id no ‘V004’.(v) Replace the Location as ‘Delhi’ for the id V002.(vi) Write a query to delete the entire table Vendor.
Answer» EXPLANATION: GG vi UV CM HC CNN mcl lz bl cz cm cz cm cz do TA do y'all PAL pal vaishakh

VID VName Reg LocationV001 Mother Dairy 20-01-2009 Delhi V002 Havmor 01-04-2015 Gujrat V003 Amul 12-05-2012 Kolkata V004 Kwality Walls 15-10-2013 Mumbai (i) Write a Query to display all records (ii) Write a Query to add a new row with the following details (‘V005’, ‘Vadilal’, ‘2010-03-20’, ‘Pune’) (iii) Write a query to modify the location of V003 from Kolkata to Gujrat.(iv) Write a Query to delete the record of id no ‘V004’.(v) Replace the Location as ‘Delhi’ for the id V002.(vi) Write a query to delete the entire table Vendor.

Answer»

GG vi UV CM HC CNN mcl lz bl cz cm cz cm cz do TA do y'all PAL pal vaishakh