Question: 8. Assume that a table named VEHICLE is already existed with the following rows. [5 Marks] VEHICLE VehicleID VehicleType 155 Sport 305 Sedan 700 Coupe

 8. Assume that a table named VEHICLE is already existed with

8. Assume that a table named VEHICLE is already existed with the following rows. [5 Marks] VEHICLE VehicleID VehicleType 155 Sport 305 Sedan 700 Coupe a) Add a new column. Column Name Data Type Size Constraint - Column Level Model Number 10 should not be empty b) Modify the Vehicle type with Station Wagon for the Vehicle ID 305. c) Delete the constraint of Model column. 9. Assume that the table 'VEHICLE' is available in "user102. [4 Marks] a) Give the permissions to allow the user user100 to modify the data in table "VEHICLE. b) Create a save point with the name of SP3. c) Write a query to modify Vehicle Type of Vehicle ID 700 to Classic by user "user100". d) Cancel all the transactions up to save point SP3. e) Cancel all the privileges given to user user100

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!