Q13.Consider the following Vendor table and write the quries. VID V NAME DATE OF REGISTRATION LOCATION VO01 Mother dairy 20-1-2009 Delhi V002 Havmor 01-04-2015 Gujrat V003 Amul 12-05-2012 Kolkata V004 kwality 15-10- 2013 Mumbai (i)Write the query to display all the records. (ii)write a query to add new row with the following details: ("v005", vadilal', '20-3-2010. pune") (iii)write a query to modify the location of v003 from Kolkata to Gujrat. (iv)write SQL command to change the column name 'Location' In Place
Answers
25. Consider the following table. Write the queries for the following statements: Table Vendor
Vendorld VName DateofRegistration Location
V001 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
(a) Write the query to display all the records.
(b) Write a query to add a new record with following description:
1.V005'. Vadilal', '2010-03-20", "Pune' }
(c) Write a query to modify the location of V003 to Gujrat.
(d) Display the details of those vendors which are located in Delh
Show answers
Another question on Computer Science
Computer Science, 20.08.2019 15:00
Write down difference between ram and rom.
Cevap: 2
Show answer
Computer Science, 21.08.2019 23:00
Difference between web cam and digital camera
Cevap: 1
Show answer
Computer Science, 22.08.2019 03:00
Write the steps to open ms word and save the files shortcut keys
Cevap: 2
Show answer
Computer Science, 22.08.2019 14:00
Short answer dont copy computer
Cevap: 2
Show answer
You know the right answer?
25. Consider the following table. Write the queries for the following statements: Table Vendor
Questions
Political Science, 13.12.2019 16:15
What is the difference between e. mail and gmail? ...
Answer
English, 13.12.2019 16:15
answer it fast fast fast will answer at first will be marked as brainiest
Answer
Math, 13.12.2019 16:15
7m2. what is the length of the side a, if the perimeter of the polygon is 53....
Answer
Math, 13.12.2019 16:15
if20% reduction insuit = 1600 findthe price of woolen suitits original price....
Answer
History, 13.12.2019 16:15
Expert with deep understanding of art is required in the art market ...
Answer
Math, 13.12.2019 16:15
If the two same angels of a isosceles triangle are 65 degrees, what is the missing angle? ...
Answer
Political Science, 13.12.2019 16:15
What benefit to the weavers and traders...
Answer
Business Studies, 13.12.2019 16:15
In what ways do you managers job have changed over last 20 years why have these changes occurred...
Answer
Business Studies, 13.12.2019 16:15
4. barrier in effective communication is(a) language(b) distancec) individual differences(d) all of these...
Answer
India Languages, 13.12.2019 16:15
Who is the first prime minister of green land...
Answer
English, 13.12.2019 16:15
How old was grandma when sick first climb the tree? who taught her tree climbing...
Answer
English, 13.12.2019 16:15
Word cline for scared, fearful, frightened...
Answer
Biology, 13.12.2019 16:15
18name the technique of growing plants without soil. why vigorousbubbling of air is essential for technique ? ...
Answer
Social Sciences, 13.12.2019 16:15
How many oceans in the world and what are ...
Answer
Biology, 13.12.2019 16:15
Puri face aur silent rahata sangh ke jantuon mein kya antar hai...
Answer
CBSE BOARD X, 13.12.2019 16:15
✌️god create universe but the real builder is teacher✌️explanation in simple and easy language.plz about it....
Answer
Physics, 13.12.2019 16:15
Two bodies a and b have the same number of protons. after rubbing a with b a become positively charge what would happen if both the
Answer:
- Select* from VENDOR;
- Insert into Vendor values (‘V005’, ‘Vadilal’, ‘2010-03-20’, ‘Pune’);
- Update Vendor
SET Location = ‘Gujrat’
WHERE Location = ‘Kolkata’;
4. Alter Table Vendor
Rename Column= ' Location'
To Column = 'Place' ;