CREATE TABLE ONLINE_PAPERS
(
  PAPER_ID   NUMBER,
  COURSE_ID  NUMBER,
  QUESTIONS  VARCHAR2(100 BYTE),
  OPT1       VARCHAR2(1000 BYTE),
  OPT2       VARCHAR2(1000 BYTE),
  OPT3       VARCHAR2(1000 BYTE),
  OPT4       VARCHAR2(1000 BYTE)
);

ALTER TABLE ONLINE_PAPERS ADD (
  CONSTRAINT PAPER_ID_PK
 PRIMARY KEY
 (PAPER_ID));


ALTER TABLE ONLINE_PAPERS ADD (
  CONSTRAINT COURSE_ID_FK 
 FOREIGN KEY (COURSE_ID) 
 REFERENCES ONLINE_COURSE (COURSE_ID));

Insert into ONLINE_PAPERS
   (PAPER_ID, COURSE_ID, QUESTIONS, OPT1, OPT2, 
    OPT3, OPT4)
 Values
   (1, 1, 'what is 2+3?', '4', '5', 
    '6', '2');
Insert into ONLINE_PAPERS
   (PAPER_ID, COURSE_ID, QUESTIONS, OPT1, OPT2, 
    OPT3, OPT4)
 Values
   (2, 1, 'what is 2*3?', '4', '6', 
    '5', '2');
Insert into ONLINE_PAPERS
   (PAPER_ID, COURSE_ID, QUESTIONS, OPT1, OPT2, 
    OPT3, OPT4)
 Values
   (3, 1, 'what is (2*3)+(3*2)?', '20', '10', 
    '12', '24');
Insert into ONLINE_PAPERS
   (PAPER_ID, COURSE_ID, QUESTIONS, OPT1, OPT2, 
    OPT3, OPT4)
 Values
   (4, 2, 'what is sin90?', '180', '1', 
    '0', '90');
Insert into ONLINE_PAPERS
   (PAPER_ID, COURSE_ID, QUESTIONS, OPT1, OPT2, 
    OPT3, OPT4)
 Values
   (5, 2, 'what is cos90?', '0', '1', 
    '180', '90');
Insert into ONLINE_PAPERS
   (PAPER_ID, COURSE_ID, QUESTIONS, OPT1, OPT2, 
    OPT3, OPT4)
 Values
   (6, 2, 'what is tan 45?', '0', '1\2', 
    '1\4', '1');
Insert into ONLINE_PAPERS
   (PAPER_ID, COURSE_ID, QUESTIONS, OPT1, OPT2, 
    OPT3, OPT4)
 Values
   (9, 3, 'Find the cuberoot of 125?', '2', '5', 
    '3', '6');
Insert into ONLINE_PAPERS
   (PAPER_ID, COURSE_ID, QUESTIONS, OPT1, OPT2, 
    OPT3, OPT4)
 Values
   (7, 3, 'Find the square root of 121?', '12', '11', 
    '10', '13');
Insert into ONLINE_PAPERS
   (PAPER_ID, COURSE_ID, QUESTIONS, OPT1, OPT2, 
    OPT3, OPT4)
 Values
   (8, 3, 'Find the square root of 36?', '9', '3', 
    '6', '8');
Insert into ONLINE_PAPERS
   (PAPER_ID, COURSE_ID, QUESTIONS, OPT1, OPT2, 
    OPT3, OPT4)
 Values
   (10, 4, 'what is your institute name', 'ibm', 'niit', 
    'next', 'aptech');
Insert into ONLINE_PAPERS
   (PAPER_ID, COURSE_ID, QUESTIONS, OPT1, OPT2, 
    OPT3, OPT4)
 Values
   (11, 4, 'Stray losses in an induction motor generally are ____ .', 'proportional to the square of the stator current', 'proportional to the square of the rotor current', 
    'proportional to the rotor current', 'inversely proportional to the square of rotor current');
Insert into ONLINE_PAPERS
   (PAPER_ID, COURSE_ID, QUESTIONS, OPT1, OPT2, 
    OPT3, OPT4)
 Values
   (12, 4, 'Which of the following is an AC motor?', 'Synchronous motor', 'Slip ring motor', 
    'Squirrel cage Induction', 'all the above');
Insert into ONLINE_PAPERS
   (PAPER_ID, COURSE_ID, QUESTIONS, OPT1, OPT2, 
    OPT3, OPT4)
 Values
   (13, 5, 'Which of the following needs to be measured after rewinding of motor?', 'No load current', 'winding resistance', 
    'air gap', 'all the above');
Insert into ONLINE_PAPERS
   (PAPER_ID, COURSE_ID, QUESTIONS, OPT1, OPT2, 
    OPT3, OPT4)
 Values
   (14, 5, 'Which of the following are ill suited for energy efficient motors application?', 'Punch Presses', 'fans', 
    'pumps', 'all of the above');
Insert into ONLINE_PAPERS
   (PAPER_ID, COURSE_ID, QUESTIONS, OPT1, OPT2, 
    OPT3, OPT4)
 Values
   (15, 5, 'Unbalance in voltages at motor terminals is caused by ____.', 'Supplying single phase loads disproportionately', 'Use of different sizes of cables', 
    'both a and b', 'none');
Insert into ONLINE_PAPERS
   (PAPER_ID, COURSE_ID, QUESTIONS, OPT1, OPT2, 
    OPT3, OPT4)
 Values
   (16, 6, 'The efficiency figures for energy efficient motors  can be generally higher by____%.', '3-7%', '10%', 
    '8-10%', '2%');
Insert into ONLINE_PAPERS
   (PAPER_ID, COURSE_ID, QUESTIONS, OPT1, OPT2, 
    OPT3, OPT4)
 Values
   (17, 6, 'Machine tools are a typical example of', 'Constant power load', 'Constant torque load', 
    ' Variable torque load', 'a and b');
Insert into ONLINE_PAPERS
   (PAPER_ID, COURSE_ID, QUESTIONS, OPT1, OPT2, 
    OPT3, OPT4)
 Values
   (18, 6, 'The speed of an AC motor depends on ____ .', 'Frequency', 'No. of poles', 
    ' both (a) and (b)', 'None of the above');
Insert into ONLINE_PAPERS
   (PAPER_ID, COURSE_ID, QUESTIONS, OPT1, OPT2, 
    OPT3, OPT4)
 Values
   (19, 7, 'What determines the thermal loading on the motor?', 'Duty/Load cycle', 'Temperature of the winding', 
    ' Age of the motor', 'Ambient conditions');
Insert into ONLINE_PAPERS
   (PAPER_ID, COURSE_ID, QUESTIONS, OPT1, OPT2, 
    OPT3, OPT4)
 Values
   (20, 7, 'Which of the following information available on name plate of a motor', 'RPM', 'HP Rating', 
    'Frame Model', 'All the above');
Insert into ONLINE_PAPERS
   (PAPER_ID, COURSE_ID, QUESTIONS, OPT1, OPT2, 
    OPT3, OPT4)
 Values
   (21, 7, 'Output power requirements of constant torque loads vary with ', 'speed', 'voltage', 
    'current', 'power factor');
Insert into ONLINE_PAPERS
   (PAPER_ID, COURSE_ID, QUESTIONS, OPT1, OPT2, 
    OPT3, OPT4)
 Values
   (22, 8, 'Five percent increase in supply frequency will change the synchronous speed by ', '-5%', '-9%', 
    '+5%', '-5.5%');
Insert into ONLINE_PAPERS
   (PAPER_ID, COURSE_ID, QUESTIONS, OPT1, OPT2, 
    OPT3, OPT4)
 Values
   (23, 8, 'Reduction in supply voltage by 10% will change the torque of the motor by ', '20%', '19%', 
    '11%', '19.5%');
Insert into ONLINE_PAPERS
   (PAPER_ID, COURSE_ID, QUESTIONS, OPT1, OPT2, 
    OPT3, OPT4)
 Values
   (24, 8, 'With decrease in speed of the motor, the required capacitive kVAr', 'Increases', 'Decreases', 
    'Does not change', 'None of the above');
Insert into ONLINE_PAPERS
   (PAPER_ID, COURSE_ID, QUESTIONS, OPT1, OPT2, 
    OPT3, OPT4)
 Values
   (25, 9, 'The synchronous speed of a motor with 6 poles and operating at 50 Hz frequency is?', '750 ', '1000', 
    '200', '150');
Insert into ONLINE_PAPERS
   (PAPER_ID, COURSE_ID, QUESTIONS, OPT1, OPT2, 
    OPT3, OPT4)
 Values
   (26, 9, 'The power consumption,in case of centrifugal loads  proportional to', 'speed ', 'square of speed', 
    'cube of speed', 'not applicable');
Insert into ONLINE_PAPERS
   (PAPER_ID, COURSE_ID, QUESTIONS, OPT1, OPT2, 
    OPT3, OPT4)
 Values
   (27, 9, 'Which types of following motors are most efficient?', 'TEFC', 'SPD', 
    ' Both', 'None');
COMMIT;