Consider the following vendor table and write the queries

Asked by admin @ in Computer Science viewed by 1399 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 313 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 322 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 313 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 352 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 370 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 352 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 394 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 330 persons

Write tables 2 to 20​

Write steps to create table in a presentation software

Asked by admin @ in Computer Science viewed by 348 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 318 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 367 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 330 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 326 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 350 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 294 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 19024 persons

Domestic data entry operator ncert book class 9 solutions

Asked by admin @ in Computer Science viewed by 15811 persons

Information technology code 402 class 9 solutions chapter 1

Asked by admin @ in Computer Science viewed by 10973 persons

Ncert solutions for class 8 computer chapter 1 computer system

Asked by admin @ in Computer Science viewed by 10403 persons

A scrum team works on a 4 weeks sprint

Asked by admin @ in Computer Science viewed by 8722 persons

Which of the following occupies more memory in c

Asked by admin @ in Computer Science viewed by 8137 persons

A database of motor vehicles has the base entity

Asked by admin @ in Computer Science viewed by 7842 persons

The network architecture can be termed as a mcq

Asked by admin @ in Computer Science viewed by 6490 persons

Cat5 and cat6 cabling refer to which reference model layer

Asked by admin @ in Computer Science viewed by 5791 persons

Class 7 computer chapter 3 questions and answers

Asked by admin @ in Computer Science viewed by 5693 persons

Choose the correct options about usability and user experience

Asked by admin @ in Computer Science viewed by 5476 persons

Which advocates daily team meetings for coordination and integration

Asked by admin @ in Computer Science viewed by 4981 persons

Which three security features match the database security level

Asked by admin @ in Computer Science viewed by 4972 persons

Which of the dbms package is not available

Asked by admin @ in Computer Science viewed by 4684 persons

________ aid a business grow and attain its objectives

Asked by admin @ in Computer Science viewed by 4488 persons