online.sql

一个基于PHP的在线考试系统

# phpMyAdmin MySQL-Dump
# http://phpwizard.net/phpMyAdmin/
#
# Host: localhost Database : online

# --------------------------------------------------------
#
# Table structure for table 'ans1'
#

CREATE TABLE ans1 (
   testid int(11) NOT NULL auto_increment,
   questionpaperid int(11) DEFAULT '0' NOT NULL,
   studentid varchar(20) NOT NULL,
   datetime datetime,
   sessionid varchar(20) NOT NULL,
   type varchar(10) DEFAULT 'answer' NOT NULL,
   a0 tinyint(4) DEFAULT '0' NOT NULL,
   a1 tinyint(4) DEFAULT '0' NOT NULL,
   a2 tinyint(4) DEFAULT '0' NOT NULL,
   a3 tinyint(4) DEFAULT '0' NOT NULL,
   a4 tinyint(4) DEFAULT '0' NOT NULL,
   a5 tinyint(4) DEFAULT '0' NOT NULL,
   a6 tinyint(4) DEFAULT '0' NOT NULL,
   a7 tinyint(4) DEFAULT '0' NOT NULL,
   a8 tinyint(4) DEFAULT '0' NOT NULL,
   a9 tinyint(4) DEFAULT '0' NOT NULL,
   a10 tinyint(4) DEFAULT '0' NOT NULL,
   a11 tinyint(4) DEFAULT '0' NOT NULL,
   a12 tinyint(4) DEFAULT '0' NOT NULL,
   a13 tinyint(4) DEFAULT '0' NOT NULL,
   a14 tinyint(4) DEFAULT '0' NOT NULL,
   a15 tinyint(4) DEFAULT '0' NOT NULL,
   a16 tinyint(4) DEFAULT '0' NOT NULL,
   a17 tinyint(4) DEFAULT '0' NOT NULL,
   a18 tinyint(4) DEFAULT '0' NOT NULL,
   a19 tinyint(4) DEFAULT '0' NOT NULL,
   PRIMARY KEY (testid),
   UNIQUE UC_testid (testid)
);

#
# Dumping data for table 'ans1'
#


# --------------------------------------------------------
#
# Table structure for table 'questionbank'
#

CREATE TABLE questionbank (
   questionid int(11) NOT NULL auto_increment,
   subjectid int(11) DEFAULT '0' NOT NULL,
   question varchar(255) NOT NULL,
   choice1 varchar(50),
   choice2 varchar(50),
   choice3 varchar(50),
   choice4 varchar(50),
   answer tinyint(4),
   date date,
   questionmaker varchar(15),
   PRIMARY KEY (questionid),
   UNIQUE UC_questionid (questionid)
);

#
# Dumping data for table 'questionbank'
#

INSERT INTO questionbank VALUES ( '1', '2', 'who is  the c.m of tamil nadu', 'jayalalitha', 'karunanidhi', 'moopanar', 'stalin', '1', '0000-00-00', '');
INSERT INTO questionbank VALUES ( '2', '3', 'Merry', 'Gay', 'sad', 'love', 'noise', '1', '0000-00-00', '');
INSERT INTO questionbank VALUES ( '3', '3', 'alieniate', 'freedom', 'insincere', 'estrange', 'crushed', '3', '0000-00-00', '');
INSERT INTO questionbank VALUES ( '4', '3', 'solicit', 'to appease', 'to request', 'bold', 'poison', '1', '0000-00-00', '');
INSERT INTO questionbank VALUES ( '5', '3', 'heap', 'to pile', 'to  dig', 'to effuse', 'to hide', '1', '0000-00-00', '');
INSERT INTO questionbank VALUES ( '6', '3', 'cargo			', 'load', 'vehicle', 'freight', 'gallon	', '3', '0000-00-00', '');
INSERT INTO questionbank VALUES ( '7', '3', 'momentary								', 'permanent', 'stationary', 'motion', 'transient	', '4', '0000-00-00', '');
INSERT INTO questionbank VALUES ( '8', '3', 'veer												', 'exchange	', 'diverge', 'converge', 'turning', '2', '0000-00-00', '');
INSERT INTO questionbank VALUES ( '9', '3', 'dispel																', 'insipate', 'insipid', 'Dissipate	', 'potential', '3', '0000-00-00', '');
INSERT INTO questionbank VALUES ( '10', '3', 'admonish																				', 'not caring', 'adjucate	', 'haughty', 'Cautious', '4', '0000-00-00', '');
INSERT INTO questionbank VALUES ( '11', '3', 'meager	 																						', 'plenty', 'large', 'Scanty', 'huge', '3', '0000-00-00', '');
INSERT INTO questionbank VALUES ( '12', '3', 'latitude		 			 																						', 'Scope', 'longitude	', 'absurd', 'candy', '1', '0000-00-00', '');
INSERT INTO questionbank VALUES ( '13', '5', 'latent				 			 																						', 'heat', 'power	', 'Potential	', 'fusion	', '3', '0000-00-00', '');
INSERT INTO questionbank VALUES ( '14', '3', 'covet									 			 																						', 'qualify', 'wanted', 'Crave	', 'nice', '3', '0000-00-00', '');
INSERT INTO questionbank VALUES ( '15', '3', 'discretion										 			 																						', 'Prudence	', 'proud	', 'boast', 'gaut', '1', '0000-00-00', '');
INSERT INTO questionbank VALUES ( '16', '1', 'In the command scanf, h is used for														 			 																						', 'short int', 'long int', 'int', 'float', '1', '0000-00-00', '');
INSERT INTO questionbank VALUES ( '17', '1', 'a  process is defined as																		 			 																						', 'operating system', 'compiler', 'process in execution', 'client', '3', '0000-00-00', '');
INSERT INTO questionbank VALUES ( '18', '1', 'a thread is																						 			 																						', 'a detachable unit of executive code', 'non-detachable unit', 'theoretical code', ' not executable code', '1', '0000-00-00', '');
INSERT INTO questionbank VALUES ( '19', '1', 'What is the advantage of Win NT over Win 95																										 			 																						', 'more memory space', 'speed is faster', 'robust and secure', 'none', '3', '0000-00-00', '');
INSERT INTO questionbank VALUES ( '20', '1', 'How is memory management done in Win95																															 			 																						', 'only paging', 'only segmentation', 'through paging and segmentation', 'none of the above', '3', '0000-00-00', '');
INSERT INTO questionbank VALUES ( '65', '1', 'Corba stands for ...			', 'common object request broker architecture	', 'combined recovery based system', 'code recovery bench architecture', 'none of the above', '1', '0000-00-00', '');
INSERT INTO questionbank VALUES ( '66', '1', 'which is anon-procedural language?		 	 	 	', 'effiel', 'ada', 'small talk', 'sql', '1', '0000-00-00', '');
INSERT INTO questionbank VALUES ( '67', '1', 'which language supports associative arrays		 	', 'pl/i', 'rpg', 'perl', 'none of the bove', '1', '0000-00-00', '');
INSERT INTO questionbank VALUES ( '68', '1', 'whichnetwurkprotocolsupportsibmmainframe		 	', 'SNA', 'TCP/IP', ' X.25', 'none of the above', '1', '0000-00-00', '');
INSERT INTO questionbank VALUES ( '69', '1', 'The achronym DAN stands for			', 'data acess network	', 'distributed area network', 'desktop area network', 'disk access node	', '1', '0000-00-00', '');