Question

29. The manager of a car showroom uses a database to store data about cars he sells. This is part of the
database, car
Make
Model
Size of Registration Price (Rs.)
engine
Opel
Vectra
1.8
VSE 648
9,00.000
Zafira
2.0
BFK 297
9.29,000
Volkswagen Golf
1.4
SB A5526 14,15,000
Volkswagen Polo
1.2
DD B4978 23,11,000
Volkswagen Jetta
1.6
B G8347
11.19,000
Renault
Magne
1.4
1233 CD 33 18.17,000
Renault
Clio
1.2
6289 XF 54 9.11.000
Opel
a) The records shown are to be sorted in descending order of size of engine. What will be the
Registration of the first record in the database after it has been sorted?
b) Write an SQL query to delete Size of engine column.
c) Identify the field type of the 'model' field.
d) Write an SQL query to display the details of all Volkswagen models.
e) Write an SQL query to display the details of all records where Price > 10,00,000.​

Answer 1

Answer:

I do not know about this answer