Week2 - Data Manipulation Language / Assess

The questions can come in any order, so make sure you are selecting right option for all questions.

1. Write a query to insert any 4 records into the 'route' table.

insert into route values(1,'Delhi');
insert into route values(2,'UP');
insert into route values(3,'Bihar');
insert into route values(4,'Punjab');

2. Write a query to change the route_name from 'East West line' to 'South West line' in the 'route' table.

update route set route_name = 'South West line' where route_name = 'East West line';

Note: Only a few questions from the test are listed here. If you are asked any other question that is not on the list, just comment the question and I'll answer the question as soon as I can.