Consider the following vendor table and write the queries

Asked by admin @ in Computer Science viewed by 1402 People

Page 5 of 5

39. (a) Write a Query to create a Table with the following structureTable ProductField DatatypePID Char(4)Pname Varchar(20)Description Varchar(40)Price Decimal(b) Consider the following Vendor table and write the queriesTable VendorVendorID VName DateofRegistration LocationV001 Mother Dairy 20-01-2009 DelhiV002 Havmor 01-04-2015 GujratV003 Amul 12-05-2012 Kolkata V004 Kwality Walls 15-10-2013 Mumbai(2+3)(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​

Answered by admin @


Answer:

Hope this helps you friend.

All the best for your board exam....


Similar Questions

Write the following as numbers in the given table

Asked by admin @ in Math viewed by 314 persons

1. Write the following as numbers in the given table (a)TensOnesTenths​

Which of the following is considered a naturalistic teaching strategy

Asked by admin @ in English viewed by 324 persons

Discrete trial teaching differs from naturalistic teaching strategies in that: a. Discrete trial instruction is child-initiated and naturalistic teaching strategies are adult initiated b. Discrete trial instruction is more effective …

How to write a linear equation from a data table

Asked by admin @ in Mathematics viewed by 315 persons

Which equations represent the data in the table? Check all that apply. y – 6 = (x + 2) y – 2 = –(x – 1) y + 2 = …

Which of the following is considered a hybrid organizational form

Asked by admin @ in Business viewed by 355 persons

Is a hybrid organizational structure in which two or more forms of departmentalization are used together?

Which of the following is not considered proper tire maintenance

Asked by admin @ in Law viewed by 373 persons

Witch of the following its not considered proper tire maintenance

Which of the following would be considered a nonrenewable resource

Asked by admin @ in Social Studies viewed by 354 persons

Which of the following would be considered a nonrenewable resource? sun wind lumber petroleum ANSWER: petroleum

Which of the following characters would be considered an archetype

Asked by admin @ in English viewed by 396 persons

Which of the following characters would be considered an archetype? A. Troublesome dog B. Unhappy parent C. Shy little girl D. Funny sidekick I know its not C.

Write table 2 to 20

Asked by admin @ in Math viewed by 332 persons

Write tables 2 to 20​

Write steps to create table in a presentation software

Asked by admin @ in Computer Science viewed by 350 persons

Write steps to create table in presentation software ​

Write down the electronic configuration of the following elements

Asked by admin @ in Physics viewed by 320 persons

write down the electronic configuration of the following element's from the given atomic numbers. answer the following questions with explanation.3Li,14Si,2He,11Na15P which of these element's belong to be period 3?

The following is considered as a positive biotic interaction

Asked by admin @ in Environmental Sciences viewed by 369 persons

4) The following is considered as a positive biotic-interaction:O CompetitionOPredationSymbiosisHerbivory​

Which one from the following is considered as poor

Asked by admin @ in Economy viewed by 332 persons

which one of the following is considered as poor (a rich landlord/businessman/landless labour/teacher)​

Write each of the following as decimals 5 10

Asked by admin @ in Math viewed by 328 persons

Write each of the following as decimals: (a)5/10 (b)3+7/10 (c)200+60+5+(1/10) (d)70+8/10 (e)88/10 (f)4_2/10 (g)3/2 (h)2/5 (i)12/5 (j)3_3/5 (k)4_1/2

Which of the following can be considered paas offering

Asked by admin @ in Computer Science viewed by 353 persons

Which of the following can be considered PaaS offering ? a. Google Maps b. Gmail c. Google Earth d. Google Drive

Which of the following is not considered to be malware

Asked by admin @ in Computer Science viewed by 295 persons

Which one of the following is not a malware? a. virus b. worm c. humanware d. adware ​

Most viewed questions in Computer Science

A programmer mistakenly writes gor instead of for

Asked by admin @ in Computer Science viewed by 19030 persons

Domestic data entry operator ncert book class 9 solutions

Asked by admin @ in Computer Science viewed by 15816 persons

Information technology code 402 class 9 solutions chapter 1

Asked by admin @ in Computer Science viewed by 10977 persons

Ncert solutions for class 8 computer chapter 1 computer system

Asked by admin @ in Computer Science viewed by 10407 persons

A scrum team works on a 4 weeks sprint

Asked by admin @ in Computer Science viewed by 8723 persons

Which of the following occupies more memory in c

Asked by admin @ in Computer Science viewed by 8145 persons

A database of motor vehicles has the base entity

Asked by admin @ in Computer Science viewed by 7845 persons

The network architecture can be termed as a mcq

Asked by admin @ in Computer Science viewed by 6492 persons

Cat5 and cat6 cabling refer to which reference model layer

Asked by admin @ in Computer Science viewed by 5796 persons

Class 7 computer chapter 3 questions and answers

Asked by admin @ in Computer Science viewed by 5696 persons

Choose the correct options about usability and user experience

Asked by admin @ in Computer Science viewed by 5479 persons

Which advocates daily team meetings for coordination and integration

Asked by admin @ in Computer Science viewed by 4986 persons

Which three security features match the database security level

Asked by admin @ in Computer Science viewed by 4976 persons

Which of the dbms package is not available

Asked by admin @ in Computer Science viewed by 4690 persons

________ aid a business grow and attain its objectives

Asked by admin @ in Computer Science viewed by 4492 persons