DROP TABLE IF EXISTS Questions;

create table Questions (
  id smallint NOT NULL PRIMARY KEY,
  question varchar(200),
  answer tinyint,
  choice1 varchar(100),
  choice2 varchar(100),
  choice3 varchar(100),
  choice4 varchar(100));

insert into Questions values (1, 'What Javascript method for regular expressions returns an array of strings that match the parenthesized patterns in the regular expression?', 1, 'test', 'exec', 'replace', 'regexp'),
  (2, 'How do you declare a local variable in a function?', 3, 'you simply use it--all variables are by default local', 'local', 'declare', 'var'),
  (3, 'What method of an XMLHttpRequest object allows me to initialize a request?', 0, 'open', 'send', 'onreadystatechange', 'initialize');

