Week2 - Data Definition 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 create a table named 'station'.

create table station(
  id integer not null,
  name varchar(100) not null,
  locality varchar(100) not null,
  is_interchange integer
);

2. Write a query to rename table 'station' to 'station_details'.

rename station to station_details;

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.