Question

39. T(a) Write a Query to create a Tablew
Table Product
the following structure
Pname
Description
Price
Field
PID
Datatype
Charl)
Varchar(20)
Varchar(40)
Decimal
(b) Consider the following Vendor table and wate the queries
Table Vendor
Vendorid VName DateofRegistration
V001 Mother Dairy
20-01-2009
V002 Havmor
01-04-2015
V003
Amul
12-05-2012
V004 Kwality Walls 15-10-2013
Location
Gurat
Kolkata
Mumbai
Write a Query to display all records
(1) Write a Query to add a new row with the following details
("V005', 'Vadilar, 2010-03-20". Pune)
(iii) Write a query to modify the location of Voo3 from Kolkata to Gujrat​

Answer 1

Friend all the best for board exam . I am also writing boards. please mark answer as brainliest and also follow me.