-
Notifications
You must be signed in to change notification settings - Fork 1
SQL Script
Nickolas Jurczak edited this page Apr 17, 2017
·
1 revision
CREATE SEQUENCE "AES_USER"."AES_ASSESSMENT_AUTH_SEQ" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 60 NOCACHE NOORDER NOCYCLE NOPARTITION ;
CREATE SEQUENCE "AES_USER"."AES_ASSESSMENT_DRAG_DROP_SEQ" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 NOCACHE NOORDER NOCYCLE NOPARTITION ;
CREATE SEQUENCE "AES_USER"."AES_ASSESSMENT_REQUEST_SEQ" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 NOCACHE NOORDER NOCYCLE NOPARTITION ;
CREATE SEQUENCE "AES_USER"."AES_ASSESSMENT_SEQ" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 296 NOCACHE NOORDER NOCYCLE NOPARTITION ;
CREATE SEQUENCE "AES_USER"."AES_CATEGORIES_SEQ" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 NOCACHE NOORDER NOCYCLE NOPARTITION ;
CREATE SEQUENCE "AES_USER"."AES_CATEGORY_REQUEST_SEQ" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 5 NOCACHE NOORDER NOCYCLE NOPARTITION ;
CREATE SEQUENCE "AES_USER"."AES_DRAG_DROP_SEQ" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 3 NOCACHE NOORDER NOCYCLE NOPARTITION ;
CREATE SEQUENCE "AES_USER"."AES_FILE_UPLOAD_SEQ" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 NOCACHE NOORDER NOCYCLE NOPARTITION ;
CREATE SEQUENCE "AES_USER"."AES_FORMATS_SEQ" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 2 NOCACHE NOORDER NOCYCLE NOPARTITION ;
CREATE SEQUENCE "AES_USER"."AES_OPTION_SEQ" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 746 NOCACHE NOORDER NOCYCLE NOPARTITION ;
CREATE SEQUENCE "AES_USER"."AES_QUESTION_SEQ" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 303 NOCACHE NOORDER NOCYCLE NOPARTITION ;
CREATE SEQUENCE "AES_USER"."AES_ROLES_SEQ" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 NOCACHE NOORDER NOCYCLE NOPARTITION ;
CREATE SEQUENCE "AES_USER"."AES_SNIPPET_TEMPLATE_SEQ" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 NOCACHE NOORDER NOCYCLE NOPARTITION ;
CREATE SEQUENCE "AES_USER"."AES_TAGS_SEQ" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 NOCACHE NOORDER NOCYCLE NOPARTITION ;
CREATE SEQUENCE "AES_USER"."AES_TEMPLATES_SEQ" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 286 NOCACHE NOORDER NOCYCLE NOPARTITION ;
CREATE SEQUENCE "AES_USER"."AES_TEMPLATE_QUESTION_SEQ" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 2098 NOCACHE NOORDER NOCYCLE NOPARTITION ;
CREATE SEQUENCE "AES_USER"."AES_USERS_SEQ" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 179 NOCACHE NOORDER NOCYCLE NOPARTITION ;
CREATE TABLE "AES_USER"."AES_API_IP" ( "IP_ID" NUMBER(,0), "IP_ADDRESS" VARCHAR2(255 BYTE), "API_ID" NUMBER(,0) ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ;
CREATE TABLE "AES_USER"."AES_API_TOKEN" ( "API_ID" NUMBER, "TOKEN" VARCHAR2(255 BYTE), "VALID" NUMBER, "DATE_ISSUED" DATE DEFAULT sysdate ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ;
CREATE TABLE "AES_USER"."AES_ASSESSMENT" ( "ASSESSMENT_ID" NUMBER, "USER_ID" NUMBER, "GRADE" NUMBER, "TIME_LIMIT" NUMBER, "CREATED_TIMESTAMP" DATE, "FINISHED_TIMESTAMP" DATE, "TEMPLATE_ID" NUMBER ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ;
CREATE TABLE "AES_USER"."AES_ASSESSMENT_AUTH" ( "ASSESSMENT_AUTH_ID" NUMBER, "USER_ID" NUMBER, "URL_AUTH" VARCHAR2(255 BYTE), "URL_ASSESSMENT" VARCHAR2(255 BYTE) ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ;
CREATE TABLE "AES_USER"."AES_ASSESSMENT_DRAG_DROP" ( "ASSESSMENT_DRAG_DROP_ID" NUMBER, "ASSESSMENT_ID" NUMBER, "DRAG_DROP_ID" NUMBER, "USER_ORDER" NUMBER ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ;
CREATE TABLE "AES_USER"."AES_ASSESSMENT_OPTIONS" ( "ASSESSMENT_ID" NUMBER, "OPTION_ID" NUMBER ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ;
CREATE TABLE "AES_USER"."AES_ASSESSMENT_REQUEST" ( "ASSESSMENT_REQUEST_ID" NUMBER, "TIMELIMIT" NUMBER DEFAULT NULL ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ;
CREATE TABLE "AES_USER"."AES_CATEGORY" ( "CATEGORY_ID" NUMBER, "CATEGORY_NAME" VARCHAR2(255 BYTE) ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ;
CREATE TABLE "AES_USER"."AES_CATEGORY_REQUEST" ( "CATEGORY_REQUEST_ID" NUMBER, "CATEGORY_ID" NUMBER, "MC_QUESTIONS" NUMBER, "MS_QUESTIONS" NUMBER, "DD_QUESTIONS" NUMBER, "CS_QUESTIONS" NUMBER, "ASSESSMENT_REQUEST_ID" NUMBER ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ;
CREATE TABLE "AES_USER"."AES_DRAG_DROP" ( "DRAG_DROP_ID" NUMBER, "QUESTION_ID" NUMBER, "DRAG_DROP_TEXT" VARCHAR2(255 BYTE), "CORRECT_ORDER" NUMBER ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ;
CREATE TABLE "AES_USER"."AES_FILE_UPLOAD" ( "FILE_ID" NUMBER, "FILE_URL" VARCHAR2(255 BYTE), "GRADE" NUMBER, "QUESTION_ID" NUMBER, "ASSESSMENT_ID" NUMBER ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ;
CREATE TABLE "AES_USER"."AES_FORMATS" ( "FORMAT_ID" NUMBER, "FORMAT_NAME" VARCHAR2(255 BYTE) ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ;
CREATE TABLE "AES_USER"."AES_OPTIONS" ( "OPTION_ID" NUMBER, "OPTION_TEXT" VARCHAR2(255 BYTE), "CORRECT" NUMBER, "QUESTION_ID" NUMBER ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ;
CREATE TABLE "AES_USER"."AES_QUESTION" ( "QUESTION_ID" NUMBER, "QUESTION_FORMAT_ID" NUMBER, "QUESTION_TEXT" VARCHAR2(255 BYTE) ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ;
CREATE TABLE "AES_USER"."AES_QUESTION_CATEGORY" ( "QUESTION_ID" NUMBER, "CATEGORY_ID" NUMBER ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ;
CREATE TABLE "AES_USER"."AES_QUESTION_TAG" ( "QUESTION_ID" NUMBER, "TAG_ID" NUMBER ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ;
CREATE TABLE "AES_USER"."AES_ROLES" ( "ROLE_ID" NUMBER, "ROLE_TITLE" VARCHAR2(255 BYTE) ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ;
CREATE TABLE "AES_USER"."AES_SECURITY" ( "USER_ID" NUMBER, "PASS_WORD" VARCHAR2(255 BYTE), "VALID" NUMBER ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ;
CREATE TABLE "AES_USER"."AES_SNIPPET_RESPONSE" ( "SNIPPET_TEMPLATE_ID" NUMBER, "ASSESSMENT_ID" NUMBER ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ;
CREATE TABLE "AES_USER"."AES_SNIPPET_TEMPLATE" ( "SNIPPET_TEMPLATE_ID" NUMBER, "QUESTION_ID" NUMBER, "FILE_TYPE" VARCHAR2(255 BYTE), "SNIPPET_TEMPLATE_URL" VARCHAR2(255 BYTE), "SOLUTION_URL" VARCHAR2(255 BYTE) ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ;
CREATE TABLE "AES_USER"."AES_TAGS" ( "TAG_ID" NUMBER, "TAG_NAME" VARCHAR2(255 BYTE) ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ;
CREATE TABLE "AES_USER"."AES_TEMPLATES" ( "TEMPLATE_ID" NUMBER, "CREATE_TIMESTAMP" TIMESTAMP (6), "CREATOR_ID" NUMBER ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ;
CREATE TABLE "AES_USER"."AES_TEMPLATE_QUESTION" ( "TEMPLATE_QUESTION_ID" NUMBER, "TEMPLATE_ID" NUMBER, "QUESTION_ID" NUMBER, "WEIGHT" NUMBER DEFAULT 1 ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ;
CREATE TABLE "AES_USER"."AES_USERS" ( "USER_ID" NUMBER, "EMAIL" VARCHAR2(255 BYTE), "FIRSTNAME" VARCHAR2(255 BYTE), "LASTNAME" VARCHAR2(255 BYTE), "SALESFORCE" NUMBER, "RECRUITER_ID" NUMBER, "ROLE_ID" NUMBER, "DATE_PASS_ISSUED" DATE ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ;
CREATE TABLE "AES_USER"."AES_USER_TRAINERS" ( "USER_ID" NUMBER, "TRAINER_ID" NUMBER ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ;
CREATE GLOBAL TEMPORARY TABLE "AES_USER"."QUEST_TEMP_EXPLAIN" ( "STATEMENT_ID" VARCHAR2(30 BYTE), "TIMESTAMP" DATE, "REMARKS" VARCHAR2(80 BYTE), "OPERATION" VARCHAR2(30 BYTE), "OPTIONS" VARCHAR2(30 BYTE), "OBJECT_NODE" VARCHAR2(128 BYTE), "OBJECT_OWNER" VARCHAR2(30 BYTE), "OBJECT_NAME" VARCHAR2(30 BYTE), "OBJECT_INSTANCE" NUMBER(,0), "OBJECT_TYPE" VARCHAR2(30 BYTE), "OPTIMIZER" VARCHAR2(255 BYTE), "SEARCH_COLUMNS" NUMBER(,0), "ID" NUMBER(,0), "PARENT_ID" NUMBER(,0), "POSITION" NUMBER(,0), "COST" NUMBER(,0), "CARDINALITY" NUMBER(,0), "BYTES" NUMBER(,0), "OTHER_TAG" VARCHAR2(255 BYTE), "PARTITION_START" VARCHAR2(255 BYTE), "PARTITION_STOP" VARCHAR2(255 BYTE), "PARTITION_ID" NUMBER(,0), "OTHER" LONG, "DISTRIBUTION" VARCHAR2(30 BYTE), "CPU_COST" NUMBER(,0), "IO_COST" NUMBER(,0), "TEMP_SPACE" NUMBER(,0), "ACCESS_PREDICATES" VARCHAR2(4000 BYTE), "FILTER_PREDICATES" VARCHAR2(4000 BYTE) ) ON COMMIT PRESERVE ROWS ;
CREATE OR REPLACE FORCE EDITIONABLE VIEW "AES_USER"."CATEGORIES" ("CATEGORY_ID", "CATEGORY_NAME", "QUESTION_ID", "QUESTION_TEXT") AS select cat.category_id, cat.category_name, q.question_id, q.question_text from aes_question q inner join aes_question_category qc on q.QUESTION_ID = qc.QUESTION_ID inner join aes_category cat on cat.CATEGORY_ID = qc.CATEGORY_ID;
CREATE OR REPLACE FORCE EDITIONABLE VIEW "AES_USER"."MC_QUESTIONS" ("QUESTION_TEXT", "OPTION_TEXT", "CORRECT", "CATEGORY_NAME") AS select q.question_text, o.option_text, o.correct, cat.category_name from aes_question q inner join aes_options o on q.QUESTION_ID = q.QUESTION_ID inner join aes_question_category qc on qc.QUESTION_ID = q.QUESTION_ID inner join aes_category cat on cat.CATEGORY_ID = qc.CATEGORY_ID where q.question_format_id = 1;
CREATE OR REPLACE FORCE EDITIONABLE VIEW "AES_USER"."MS_QUESTIONS" ("QUESTION_TEXT", "OPTION_TEXT", "CORRECT", "CATEGORY_NAME") AS select q.question_text, o.option_text, o.correct, cat.category_name from aes_question q inner join aes_options o on q.QUESTION_ID = q.QUESTION_ID inner join aes_question_category qc on qc.QUESTION_ID = q.QUESTION_ID inner join aes_category cat on cat.CATEGORY_ID = qc.CATEGORY_ID where q.question_format_id = 2;
CREATE OR REPLACE FORCE EDITIONABLE VIEW "AES_USER"."QUESTION_COUNT" ("CATEGORY", "FORMAT_TYPE", "TOTAL") AS Select AES_CATEGORY.CATEGORY_NAME AS CATEGORY, AES_FORMATS.FORMAT_NAME AS FORMAT_TYPE, COUNT(AES_CATEGORY.CATEGORY_NAME) AS TOTAL FROM AES_QUESTION JOIN AES_QUESTION_CATEGORY ON AES_QUESTION.QUESTION_ID = AES_QUESTION_CATEGORY.QUESTION_ID JOIN AES_CATEGORY ON AES_QUESTION_CATEGORY.CATEGORY_ID = AES_CATEGORY.CATEGORY_ID JOIN AES_FORMATS ON AES_QUESTION.QUESTION_FORMAT_ID = AES_FORMATS.FORMAT_ID GROUP BY AES_CATEGORY.CATEGORY_NAME, AES_FORMATS.FORMAT_NAME; REM INSERTING into AES_USER.AES_API_IP SET DEFINE OFF; Insert into AES_USER.AES_API_IP (IP_ID,IP_ADDRESS,API_ID) values (1,'frondalicious',1); REM INSERTING into AES_USER.AES_API_TOKEN SET DEFINE OFF; Insert into AES_USER.AES_API_TOKEN (API_ID,TOKEN,VALID,DATE_ISSUED) values (1,'123qweasd',1,to_date('20-FEB-17','DD-MON-RR')); REM INSERTING into AES_USER.AES_ASSESSMENT SET DEFINE OFF; Insert into AES_USER.AES_ASSESSMENT (ASSESSMENT_ID,USER_ID,GRADE,TIME_LIMIT,CREATED_TIMESTAMP,FINISHED_TIMESTAMP,TEMPLATE_ID) values (257,151,-1,30,null,null,247); Insert into AES_USER.AES_ASSESSMENT (ASSESSMENT_ID,USER_ID,GRADE,TIME_LIMIT,CREATED_TIMESTAMP,FINISHED_TIMESTAMP,TEMPLATE_ID) values (223,96,0,30,to_date('08-MAR-17','DD-MON-RR'),to_date('08-MAR-17','DD-MON-RR'),213); Insert into AES_USER.AES_ASSESSMENT (ASSESSMENT_ID,USER_ID,GRADE,TIME_LIMIT,CREATED_TIMESTAMP,FINISHED_TIMESTAMP,TEMPLATE_ID) values (224,122,-1,30,null,null,214); Insert into AES_USER.AES_ASSESSMENT (ASSESSMENT_ID,USER_ID,GRADE,TIME_LIMIT,CREATED_TIMESTAMP,FINISHED_TIMESTAMP,TEMPLATE_ID) values (261,149,-1,30,null,null,251); Insert into AES_USER.AES_ASSESSMENT (ASSESSMENT_ID,USER_ID,GRADE,TIME_LIMIT,CREATED_TIMESTAMP,FINISHED_TIMESTAMP,TEMPLATE_ID) values (269,159,-1,30,null,null,259); Insert into AES_USER.AES_ASSESSMENT (ASSESSMENT_ID,USER_ID,GRADE,TIME_LIMIT,CREATED_TIMESTAMP,FINISHED_TIMESTAMP,TEMPLATE_ID) values (283,149,68,30,to_date('14-MAR-17','DD-MON-RR'),to_date('14-MAR-17','DD-MON-RR'),273); Insert into AES_USER.AES_ASSESSMENT (ASSESSMENT_ID,USER_ID,GRADE,TIME_LIMIT,CREATED_TIMESTAMP,FINISHED_TIMESTAMP,TEMPLATE_ID) values (252,122,-1,30,null,null,242); Insert into AES_USER.AES_ASSESSMENT (ASSESSMENT_ID,USER_ID,GRADE,TIME_LIMIT,CREATED_TIMESTAMP,FINISHED_TIMESTAMP,TEMPLATE_ID) values (253,122,-1,30,null,null,243); Insert into AES_USER.AES_ASSESSMENT (ASSESSMENT_ID,USER_ID,GRADE,TIME_LIMIT,CREATED_TIMESTAMP,FINISHED_TIMESTAMP,TEMPLATE_ID) values (279,135,-1,30,null,null,269); Insert into AES_USER.AES_ASSESSMENT (ASSESSMENT_ID,USER_ID,GRADE,TIME_LIMIT,CREATED_TIMESTAMP,FINISHED_TIMESTAMP,TEMPLATE_ID) values (280,167,-1,30,null,null,270); Insert into AES_USER.AES_ASSESSMENT (ASSESSMENT_ID,USER_ID,GRADE,TIME_LIMIT,CREATED_TIMESTAMP,FINISHED_TIMESTAMP,TEMPLATE_ID) values (281,168,70,30,to_date('14-MAR-17','DD-MON-RR'),to_date('14-MAR-17','DD-MON-RR'),271); Insert into AES_USER.AES_ASSESSMENT (ASSESSMENT_ID,USER_ID,GRADE,TIME_LIMIT,CREATED_TIMESTAMP,FINISHED_TIMESTAMP,TEMPLATE_ID) values (282,149,600,30,to_date('14-MAR-17','DD-MON-RR'),to_date('14-MAR-17','DD-MON-RR'),272); Insert into AES_USER.AES_ASSESSMENT (ASSESSMENT_ID,USER_ID,GRADE,TIME_LIMIT,CREATED_TIMESTAMP,FINISHED_TIMESTAMP,TEMPLATE_ID) values (242,134,-1,30,null,null,232); Insert into AES_USER.AES_ASSESSMENT (ASSESSMENT_ID,USER_ID,GRADE,TIME_LIMIT,CREATED_TIMESTAMP,FINISHED_TIMESTAMP,TEMPLATE_ID) values (270,149,0,30,to_date('13-MAR-17','DD-MON-RR'),to_date('13-MAR-17','DD-MON-RR'),260); Insert into AES_USER.AES_ASSESSMENT (ASSESSMENT_ID,USER_ID,GRADE,TIME_LIMIT,CREATED_TIMESTAMP,FINISHED_TIMESTAMP,TEMPLATE_ID) values (290,172,-1,30,null,null,280); Insert into AES_USER.AES_ASSESSMENT (ASSESSMENT_ID,USER_ID,GRADE,TIME_LIMIT,CREATED_TIMESTAMP,FINISHED_TIMESTAMP,TEMPLATE_ID) values (284,149,79,30,to_date('14-MAR-17','DD-MON-RR'),to_date('14-MAR-17','DD-MON-RR'),274); Insert into AES_USER.AES_ASSESSMENT (ASSESSMENT_ID,USER_ID,GRADE,TIME_LIMIT,CREATED_TIMESTAMP,FINISHED_TIMESTAMP,TEMPLATE_ID) values (244,136,25,30,to_date('09-MAR-17','DD-MON-RR'),to_date('09-MAR-17','DD-MON-RR'),234); Insert into AES_USER.AES_ASSESSMENT (ASSESSMENT_ID,USER_ID,GRADE,TIME_LIMIT,CREATED_TIMESTAMP,FINISHED_TIMESTAMP,TEMPLATE_ID) values (289,149,22,30,to_date('14-MAR-17','DD-MON-RR'),to_date('14-MAR-17','DD-MON-RR'),279); Insert into AES_USER.AES_ASSESSMENT (ASSESSMENT_ID,USER_ID,GRADE,TIME_LIMIT,CREATED_TIMESTAMP,FINISHED_TIMESTAMP,TEMPLATE_ID) values (246,135,39,30,to_date('09-MAR-17','DD-MON-RR'),to_date('09-MAR-17','DD-MON-RR'),236); Insert into AES_USER.AES_ASSESSMENT (ASSESSMENT_ID,USER_ID,GRADE,TIME_LIMIT,CREATED_TIMESTAMP,FINISHED_TIMESTAMP,TEMPLATE_ID) values (251,135,0,30,to_date('10-MAR-17','DD-MON-RR'),to_date('10-MAR-17','DD-MON-RR'),241); Insert into AES_USER.AES_ASSESSMENT (ASSESSMENT_ID,USER_ID,GRADE,TIME_LIMIT,CREATED_TIMESTAMP,FINISHED_TIMESTAMP,TEMPLATE_ID) values (255,149,-1,30,to_date('10-MAR-17','DD-MON-RR'),null,245); Insert into AES_USER.AES_ASSESSMENT (ASSESSMENT_ID,USER_ID,GRADE,TIME_LIMIT,CREATED_TIMESTAMP,FINISHED_TIMESTAMP,TEMPLATE_ID) values (256,150,-1,30,null,null,246); Insert into AES_USER.AES_ASSESSMENT (ASSESSMENT_ID,USER_ID,GRADE,TIME_LIMIT,CREATED_TIMESTAMP,FINISHED_TIMESTAMP,TEMPLATE_ID) values (267,157,-1,30,null,null,257); Insert into AES_USER.AES_ASSESSMENT (ASSESSMENT_ID,USER_ID,GRADE,TIME_LIMIT,CREATED_TIMESTAMP,FINISHED_TIMESTAMP,TEMPLATE_ID) values (268,158,18,30,to_date('13-MAR-17','DD-MON-RR'),to_date('13-MAR-17','DD-MON-RR'),258); Insert into AES_USER.AES_ASSESSMENT (ASSESSMENT_ID,USER_ID,GRADE,TIME_LIMIT,CREATED_TIMESTAMP,FINISHED_TIMESTAMP,TEMPLATE_ID) values (288,149,0,30,to_date('14-MAR-17','DD-MON-RR'),to_date('14-MAR-17','DD-MON-RR'),278); Insert into AES_USER.AES_ASSESSMENT (ASSESSMENT_ID,USER_ID,GRADE,TIME_LIMIT,CREATED_TIMESTAMP,FINISHED_TIMESTAMP,TEMPLATE_ID) values (272,161,33,30,to_date('13-MAR-17','DD-MON-RR'),to_date('13-MAR-17','DD-MON-RR'),262); Insert into AES_USER.AES_ASSESSMENT (ASSESSMENT_ID,USER_ID,GRADE,TIME_LIMIT,CREATED_TIMESTAMP,FINISHED_TIMESTAMP,TEMPLATE_ID) values (273,162,40,30,to_date('13-MAR-17','DD-MON-RR'),to_date('13-MAR-17','DD-MON-RR'),263); Insert into AES_USER.AES_ASSESSMENT (ASSESSMENT_ID,USER_ID,GRADE,TIME_LIMIT,CREATED_TIMESTAMP,FINISHED_TIMESTAMP,TEMPLATE_ID) values (259,149,1020,30,to_date('10-MAR-17','DD-MON-RR'),to_date('10-MAR-17','DD-MON-RR'),249); Insert into AES_USER.AES_ASSESSMENT (ASSESSMENT_ID,USER_ID,GRADE,TIME_LIMIT,CREATED_TIMESTAMP,FINISHED_TIMESTAMP,TEMPLATE_ID) values (274,163,1020,30,to_date('13-MAR-17','DD-MON-RR'),to_date('13-MAR-17','DD-MON-RR'),264); Insert into AES_USER.AES_ASSESSMENT (ASSESSMENT_ID,USER_ID,GRADE,TIME_LIMIT,CREATED_TIMESTAMP,FINISHED_TIMESTAMP,TEMPLATE_ID) values (275,164,-1,30,null,null,265); Insert into AES_USER.AES_ASSESSMENT (ASSESSMENT_ID,USER_ID,GRADE,TIME_LIMIT,CREATED_TIMESTAMP,FINISHED_TIMESTAMP,TEMPLATE_ID) values (258,149,1060,30,to_date('10-MAR-17','DD-MON-RR'),to_date('10-MAR-17','DD-MON-RR'),248); Insert into AES_USER.AES_ASSESSMENT (ASSESSMENT_ID,USER_ID,GRADE,TIME_LIMIT,CREATED_TIMESTAMP,FINISHED_TIMESTAMP,TEMPLATE_ID) values (243,135,0,30,to_date('09-MAR-17','DD-MON-RR'),to_date('09-MAR-17','DD-MON-RR'),233); Insert into AES_USER.AES_ASSESSMENT (ASSESSMENT_ID,USER_ID,GRADE,TIME_LIMIT,CREATED_TIMESTAMP,FINISHED_TIMESTAMP,TEMPLATE_ID) values (213,95,-1,30,null,null,203); Insert into AES_USER.AES_ASSESSMENT (ASSESSMENT_ID,USER_ID,GRADE,TIME_LIMIT,CREATED_TIMESTAMP,FINISHED_TIMESTAMP,TEMPLATE_ID) values (249,141,-1,30,null,null,239); Insert into AES_USER.AES_ASSESSMENT (ASSESSMENT_ID,USER_ID,GRADE,TIME_LIMIT,CREATED_TIMESTAMP,FINISHED_TIMESTAMP,TEMPLATE_ID) values (277,149,1000,30,to_date('13-MAR-17','DD-MON-RR'),to_date('13-MAR-17','DD-MON-RR'),267); Insert into AES_USER.AES_ASSESSMENT (ASSESSMENT_ID,USER_ID,GRADE,TIME_LIMIT,CREATED_TIMESTAMP,FINISHED_TIMESTAMP,TEMPLATE_ID) values (278,149,1000,30,to_date('13-MAR-17','DD-MON-RR'),to_date('13-MAR-17','DD-MON-RR'),268); Insert into AES_USER.AES_ASSESSMENT (ASSESSMENT_ID,USER_ID,GRADE,TIME_LIMIT,CREATED_TIMESTAMP,FINISHED_TIMESTAMP,TEMPLATE_ID) values (287,149,6,30,to_date('14-MAR-17','DD-MON-RR'),to_date('14-MAR-17','DD-MON-RR'),277); REM INSERTING into AES_USER.AES_ASSESSMENT_AUTH SET DEFINE OFF; Insert into AES_USER.AES_ASSESSMENT_AUTH (ASSESSMENT_AUTH_ID,USER_ID,URL_AUTH,URL_ASSESSMENT) values (2152,136,'http://192.168.60.191:8090/aes','http://192.168.60.191:8090/aes/quiz?asmt=244'); Insert into AES_USER.AES_ASSESSMENT_AUTH (ASSESSMENT_AUTH_ID,USER_ID,URL_AUTH,URL_ASSESSMENT) values (2200,141,'http://192.168.56.1:8090/aes','http://192.168.56.1:8090/aes/quiz?asmt=249'); Insert into AES_USER.AES_ASSESSMENT_AUTH (ASSESSMENT_AUTH_ID,USER_ID,URL_AUTH,URL_ASSESSMENT) values (2750,164,'http://192.168.60.46:8090/aes','http://192.168.60.46:8090/aes/quiz?asmt=275'); Insert into AES_USER.AES_ASSESSMENT_AUTH (ASSESSMENT_AUTH_ID,USER_ID,URL_AUTH,URL_ASSESSMENT) values (1750,95,'http://192.168.60.64:8090/aes','http://192.168.60.64:8090/aes/quiz?asmt=213'); Insert into AES_USER.AES_ASSESSMENT_AUTH (ASSESSMENT_AUTH_ID,USER_ID,URL_AUTH,URL_ASSESSMENT) values (2151,135,'http://192.168.60.191:8090/aes','http://null/aes/quiz?asmt=279'); Insert into AES_USER.AES_ASSESSMENT_AUTH (ASSESSMENT_AUTH_ID,USER_ID,URL_AUTH,URL_ASSESSMENT) values (2350,150,'http://192.168.60.85:8090/aes','http://192.168.60.85:8090/aes/quiz?asmt=256'); Insert into AES_USER.AES_ASSESSMENT_AUTH (ASSESSMENT_AUTH_ID,USER_ID,URL_AUTH,URL_ASSESSMENT) values (2500,159,'http://ec2-35-162-177-133.us-west-2.compute.amazonaws.com:8090/aes','http://ec2-35-162-177-133.us-west-2.compute.amazonaws.com:8090/aes/quiz?asmt=269'); Insert into AES_USER.AES_ASSESSMENT_AUTH (ASSESSMENT_AUTH_ID,USER_ID,URL_AUTH,URL_ASSESSMENT) values (2150,134,'http://192.168.60.191:8090/aes','http://192.168.60.191:8090/aes/quiz?asmt=242'); Insert into AES_USER.AES_ASSESSMENT_AUTH (ASSESSMENT_AUTH_ID,USER_ID,URL_AUTH,URL_ASSESSMENT) values (2850,168,'http://ec2-35-162-177-133.us-west-2.compute.amazonaws.com:8090/aes','http://ec2-35-162-177-133.us-west-2.compute.amazonaws.com:8090/aes/quiz?asmt=281'); Insert into AES_USER.AES_ASSESSMENT_AUTH (ASSESSMENT_AUTH_ID,USER_ID,URL_AUTH,URL_ASSESSMENT) values (2800,167,'http://10.0.0.149:8090/aes','http://10.0.0.149:8090/aes/quiz?asmt=280'); Insert into AES_USER.AES_ASSESSMENT_AUTH (ASSESSMENT_AUTH_ID,USER_ID,URL_AUTH,URL_ASSESSMENT) values (2950,172,'http://192.168.60.64:8090/aes','http://192.168.60.64:8090/aes/quiz?asmt=290'); Insert into AES_USER.AES_ASSESSMENT_AUTH (ASSESSMENT_AUTH_ID,USER_ID,URL_AUTH,URL_ASSESSMENT) values (2300,149,'http://null/aes','http://ec2-35-162-177-133.us-west-2.compute.amazonaws.com:8090/aes/quiz?asmt=289'); Insert into AES_USER.AES_ASSESSMENT_AUTH (ASSESSMENT_AUTH_ID,USER_ID,URL_AUTH,URL_ASSESSMENT) values (1654,94,'http://ec2-35-162-177-133.us-west-2.compute.amazonaws.com:8090/aes','http://ec2-35-162-177-133.us-west-2.compute.amazonaws.com:8090/aes/quiz?asmt=211'); Insert into AES_USER.AES_ASSESSMENT_AUTH (ASSESSMENT_AUTH_ID,USER_ID,URL_AUTH,URL_ASSESSMENT) values (1655,96,'http://ec2-35-162-177-133.us-west-2.compute.amazonaws.com:8090/aes','http://ec2-35-162-177-133.us-west-2.compute.amazonaws.com:8090/aes/quiz?asmt=223'); Insert into AES_USER.AES_ASSESSMENT_AUTH (ASSESSMENT_AUTH_ID,USER_ID,URL_AUTH,URL_ASSESSMENT) values (2450,157,'http://192.168.60.210:8090/aes','http://192.168.60.210:8090/aes/quiz?asmt=267'); Insert into AES_USER.AES_ASSESSMENT_AUTH (ASSESSMENT_AUTH_ID,USER_ID,URL_AUTH,URL_ASSESSMENT) values (2451,158,'http://192.168.60.210:8090/aes','http://192.168.60.210:8090/aes/quiz?asmt=268'); Insert into AES_USER.AES_ASSESSMENT_AUTH (ASSESSMENT_AUTH_ID,USER_ID,URL_AUTH,URL_ASSESSMENT) values (2000,122,'http://ec2-35-162-177-133.us-west-2.compute.amazonaws.com:8090/aes','http://ec2-35-162-177-133.us-west-2.compute.amazonaws.com:8090/aes/quiz?asmt=259'); Insert into AES_USER.AES_ASSESSMENT_AUTH (ASSESSMENT_AUTH_ID,USER_ID,URL_AUTH,URL_ASSESSMENT) values (2650,162,'http://192.168.60.210:8090/aes','http://192.168.60.210:8090/aes/quiz?asmt=273'); Insert into AES_USER.AES_ASSESSMENT_AUTH (ASSESSMENT_AUTH_ID,USER_ID,URL_AUTH,URL_ASSESSMENT) values (2700,163,'http://192.168.60.210:8090/aes','http://192.168.60.210:8090/aes/quiz?asmt=274'); Insert into AES_USER.AES_ASSESSMENT_AUTH (ASSESSMENT_AUTH_ID,USER_ID,URL_AUTH,URL_ASSESSMENT) values (2400,151,'http://192.168.60.85:8090/aes','http://192.168.60.85:8090/aes/quiz?asmt=257'); Insert into AES_USER.AES_ASSESSMENT_AUTH (ASSESSMENT_AUTH_ID,USER_ID,URL_AUTH,URL_ASSESSMENT) values (2600,161,'http://192.168.60.210:8090/aes','http://192.168.60.210:8090/aes/quiz?asmt=272'); REM INSERTING into AES_USER.AES_ASSESSMENT_DRAG_DROP SET DEFINE OFF; REM INSERTING into AES_USER.AES_ASSESSMENT_OPTIONS SET DEFINE OFF; Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (244,210); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (244,211); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (244,212); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (244,213); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (244,264); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (244,270); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (244,394); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (244,584); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (244,587); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (244,596); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (246,165); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (246,168); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (246,197); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (246,226); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (246,227); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (246,259); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (246,262); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (246,264); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (246,276); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (246,366); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (246,440); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (246,585); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (258,192); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (258,208); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (258,225); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (258,226); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (258,227); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (258,275); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (258,279); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (258,298); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (258,301); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (258,307); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (259,207); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (259,274); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (268,161); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (268,169); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (268,191); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (268,198); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (268,240); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (268,241); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (268,301); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (268,522); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (268,561); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (268,622); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (270,162); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (270,170); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (270,191); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (270,520); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (270,554); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (270,623); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (270,626); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (272,191); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (272,228); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (272,275); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (272,301); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (272,399); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (272,523); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (272,586); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (272,622); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (273,162); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (273,191); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (273,206); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (273,232); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (273,233); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (273,284); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (273,301); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (273,544); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (273,622); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (274,169); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (274,263); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (274,301); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (274,511); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (274,520); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (274,523); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (274,561); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (274,622); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (281,193); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (281,206); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (281,208); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (281,232); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (281,233); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (281,273); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (281,284); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (281,301); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (281,622); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (282,188); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (282,207); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (282,210); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (282,211); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (282,212); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (282,213); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (282,225); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (282,226); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (282,227); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (282,236); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (282,237); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (282,238); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (282,239); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (282,264); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (282,265); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (282,266); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (282,267); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (282,268); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (282,273); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (282,279); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (282,386); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (282,391); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (282,445); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (282,525); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (282,601); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (282,602); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (282,603); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (283,190); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (283,206); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (283,219); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (283,228); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (283,229); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (283,230); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (283,231); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (283,237); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (283,238); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (283,239); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (283,240); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (283,241); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (283,262); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (283,264); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (283,265); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (283,266); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (283,267); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (283,268); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (283,277); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (283,278); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (283,280); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (283,307); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (283,340); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (283,347); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (283,480); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (284,8); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (284,190); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (284,207); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (284,209); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (284,210); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (284,211); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (284,212); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (284,213); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (284,221); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (284,225); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (284,226); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (284,227); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (284,237); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (284,238); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (284,239); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (284,259); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (284,260); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (284,265); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (284,266); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (284,267); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (284,268); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (284,273); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (284,281); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (284,282); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (284,368); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (284,459); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (289,237); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (289,238); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (289,239); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (289,265); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (289,266); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (289,267); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (289,268); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (289,368); Insert into AES_USER.AES_ASSESSMENT_OPTIONS (ASSESSMENT_ID,OPTION_ID) values (289,484); REM INSERTING into AES_USER.AES_ASSESSMENT_REQUEST SET DEFINE OFF; Insert into AES_USER.AES_ASSESSMENT_REQUEST (ASSESSMENT_REQUEST_ID,TIMELIMIT) values (1,30); REM INSERTING into AES_USER.AES_CATEGORY SET DEFINE OFF; Insert into AES_USER.AES_CATEGORY (CATEGORY_ID,CATEGORY_NAME) values (9,'C#'); Insert into AES_USER.AES_CATEGORY (CATEGORY_ID,CATEGORY_NAME) values (11,'CSS'); Insert into AES_USER.AES_CATEGORY (CATEGORY_ID,CATEGORY_NAME) values (5,'Critical Thinking'); Insert into AES_USER.AES_CATEGORY (CATEGORY_ID,CATEGORY_NAME) values (3,'Data Structures'); Insert into AES_USER.AES_CATEGORY (CATEGORY_ID,CATEGORY_NAME) values (10,'HTML'); Insert into AES_USER.AES_CATEGORY (CATEGORY_ID,CATEGORY_NAME) values (1,'Java'); Insert into AES_USER.AES_CATEGORY (CATEGORY_ID,CATEGORY_NAME) values (12,'JavaScript'); Insert into AES_USER.AES_CATEGORY (CATEGORY_ID,CATEGORY_NAME) values (2,'OOP'); Insert into AES_USER.AES_CATEGORY (CATEGORY_ID,CATEGORY_NAME) values (4,'SQL'); Insert into AES_USER.AES_CATEGORY (CATEGORY_ID,CATEGORY_NAME) values (6,'core language'); REM INSERTING into AES_USER.AES_CATEGORY_REQUEST SET DEFINE OFF; Insert into AES_USER.AES_CATEGORY_REQUEST (CATEGORY_REQUEST_ID,CATEGORY_ID,MC_QUESTIONS,MS_QUESTIONS,DD_QUESTIONS,CS_QUESTIONS,ASSESSMENT_REQUEST_ID) values (1,1,5,2,0,1,1); Insert into AES_USER.AES_CATEGORY_REQUEST (CATEGORY_REQUEST_ID,CATEGORY_ID,MC_QUESTIONS,MS_QUESTIONS,DD_QUESTIONS,CS_QUESTIONS,ASSESSMENT_REQUEST_ID) values (2,4,3,2,1,0,1); Insert into AES_USER.AES_CATEGORY_REQUEST (CATEGORY_REQUEST_ID,CATEGORY_ID,MC_QUESTIONS,MS_QUESTIONS,DD_QUESTIONS,CS_QUESTIONS,ASSESSMENT_REQUEST_ID) values (3,2,2,0,0,0,1); Insert into AES_USER.AES_CATEGORY_REQUEST (CATEGORY_REQUEST_ID,CATEGORY_ID,MC_QUESTIONS,MS_QUESTIONS,DD_QUESTIONS,CS_QUESTIONS,ASSESSMENT_REQUEST_ID) values (4,3,1,1,0,0,1); REM INSERTING into AES_USER.AES_DRAG_DROP SET DEFINE OFF; Insert into AES_USER.AES_DRAG_DROP (DRAG_DROP_ID,QUESTION_ID,DRAG_DROP_TEXT,CORRECT_ORDER) values (9,3,'100^(1/3)',2); Insert into AES_USER.AES_DRAG_DROP (DRAG_DROP_ID,QUESTION_ID,DRAG_DROP_TEXT,CORRECT_ORDER) values (10,3,'pi',4); Insert into AES_USER.AES_DRAG_DROP (DRAG_DROP_ID,QUESTION_ID,DRAG_DROP_TEXT,CORRECT_ORDER) values (11,3,'275^(1/4)',3); Insert into AES_USER.AES_DRAG_DROP (DRAG_DROP_ID,QUESTION_ID,DRAG_DROP_TEXT,CORRECT_ORDER) values (12,3,'5sin(pi/2)',1); Insert into AES_USER.AES_DRAG_DROP (DRAG_DROP_ID,QUESTION_ID,DRAG_DROP_TEXT,CORRECT_ORDER) values (5,204,'Turtle',1); Insert into AES_USER.AES_DRAG_DROP (DRAG_DROP_ID,QUESTION_ID,DRAG_DROP_TEXT,CORRECT_ORDER) values (6,204,'or',2); Insert into AES_USER.AES_DRAG_DROP (DRAG_DROP_ID,QUESTION_ID,DRAG_DROP_TEXT,CORRECT_ORDER) values (7,204,'Giraffe',3); Insert into AES_USER.AES_DRAG_DROP (DRAG_DROP_ID,QUESTION_ID,DRAG_DROP_TEXT,CORRECT_ORDER) values (8,204,'?',4); REM INSERTING into AES_USER.AES_FILE_UPLOAD SET DEFINE OFF; REM INSERTING into AES_USER.AES_FORMATS SET DEFINE OFF; Insert into AES_USER.AES_FORMATS (FORMAT_ID,FORMAT_NAME) values (4,'Code Snippet'); Insert into AES_USER.AES_FORMATS (FORMAT_ID,FORMAT_NAME) values (3,'Drag and Drop'); Insert into AES_USER.AES_FORMATS (FORMAT_ID,FORMAT_NAME) values (1,'Multiple Choice'); Insert into AES_USER.AES_FORMATS (FORMAT_ID,FORMAT_NAME) values (2,'Multiple Select'); REM INSERTING into AES_USER.AES_OPTIONS SET DEFINE OFF; Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (190,'The ability for one class to pass on select properties and behaviors to a subclass which extends it.',1,45); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (740,'StringBuffer produces mutable string objects while StringBuilder does not.',0,299); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (335,'"I don''t know what this is"',1,131); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (336,'"This is a Bird!"',0,131); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (358,'True',0,139); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (359,'False',0,139); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (360,'...Is checked for by the compiler',1,140); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (361,'...must be checked for by the programmer',0,140); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (362,'All exceptions and all errors',1,141); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (363,'All exceptions, but no errors',0,141); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (364,'All errors, but no exceptions',0,141); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (365,'Nothing',0,141); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (366,'TRUE',0,142); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (367,'FALSE',1,142); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (368,'TRUE',1,143); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (369,'FALSE',0,143); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (370,'TRUE',1,144); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (371,'FALSE',0,144); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (372,'System.out.println(“Hello”);',0,145); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (373,'System.out.println(new String(“Hello”));',0,145); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (374,'Int value = 3 System.out.println(value);',1,145); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (375,'TRUE',1,146); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (376,'FALSE',0,146); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (377,'An Array List',0,147); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (378,'An Hash Set ',0,147); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (379,'An Hash Map String, Agent',1,147); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (380,'TRUE',1,148); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (381,'FALSE',0,148); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (520,'A collection which can only hold unique objects, no duplicates.',0,50); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (521,'When a subclass implements a method which shares the same name and passed-in parameters as a method in the parent class.',0,50); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (522,'When a subclass implements a method which shares the same name and passed-in parameters as a method in the parent class.',0,51); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (523,'Taking an object of one particular type and “turning it into” another object type',0,51); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (524,'When a primitive is implicitly wrapped in its corresponding Wrapper class.',0,52); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (525,'When a subclass implements a method which has different name and passed-in parameters as a method in the parent class.',0,52); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (526,'Start',0,53); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (527,'Init',0,53); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (528,'Fork',0,53); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (529,'Internal',0,54); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (530,'Creates multiple instances of the static member, usable by all instances of the containing class.',0,55); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (531,'Creates a factory service',0,55); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (532,'Creates a singleton service',0,55); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (533,'A collection which can only hold many of the same objects.',0,56); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (534,'A keyword used to assign a value to a variable.',0,56); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (535,'A comprehensive list of properties in a class.',0,56); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (541,'A non-collection of objects stored in an indexed fashion.',0,60); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (542,'A collection that can not be resized.',0,60); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (543,'Yes',0,61); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (586,'A join that returns some results on the left side of the join and either a match from the right or null values.',0,89); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (587,'A join that returns all results on the right side of the join and either a match from the left or null values.',0,89); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (588,'A join that returns all results on the left side of the join and either a match from the right or null values.',0,90); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (589,'A join that returns some results on the left side of the join and either a match from the right or null values.',0,90); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (590,'A join that returns all results on the right side of the join and either a match from the left or null values.',0,91); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (591,'A join that returns all results on the left side of the join and either a match from the right or null values.',0,91); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (592,'PL/SQL (Procedural Language SQL)',0,92); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (593,'A column that references another table. Usually the surrogate key of the referenced table.',0,100); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (594,'The first column in a table',0,101); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (595,'A technique of database design whch reduces data redundancy and preserves referential integrity.',0,102); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (596,'A column that references another table. Usually the primary key of the referenced table.',0,102); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (597,'Preventing foreign keys from referencing nonexistent rows.',0,103); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (598,'Programs which execute automatically or in response to an event.',0,103); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (599,'A procedure has no out params but returns a single value.',0,104); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (600,'A function can have multiple OUT parameters and does not return a value.',0,104); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (601,'All fields are atomic (single value)',1,105); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (602,'No partial key dependencies',1,105); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (603,'No transitive dependencies',1,105); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (604,'Columns can not be null',0,105); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (605,'Has no out params but returns a single value.',0,106); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (606,'A SQL statement stored in a java class, and given a proper name by which it can be remotely called, like a method.',0,106); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (607,'Tag which tells the browser when to load the page.',0,107); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (608,'Tag which tells the document''s type.',0,107); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (609,'At the very bottom of an HTML document.',0,108); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (610,'After the Head.',0,108); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (611,'Anywhere',0,109); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (612,'
Class.forName only return the Class object, not an instance. Class.newInstance(), will return an instance of the Class',0,296);
Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (720,'Can be overloaded',1,292); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (721,'Has a return type',0,292); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (722,'Doesnt have same name as class',0,292); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (726,'Can be overloaded',1,295); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (730,'false',1,296); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (731,'true
Class.forName only return the Class object, not an instance. Class.newInstance(), will return an instance of the Class',0,297);
Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (732,'false',1,297); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (733,'Table per heirarchy',0,12); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (734,'Table per concrete class',0,12); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (735,'Table per subclass',0,12); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (736,'String pool is a dynamic memory area used to allocate String objects.',0,298); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (737,'When Java program creates a new String, JVM checks for that String in the String pool.',0,298); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (738,'None of these.',0,298); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (739,'String pool is a special storage area in Java heap placed on to PermGen space, to store String literals.',1,298); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (741,'None of these.',0,299); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (742,'StringBuffer class is thread safe whereas StringBuilder class is not thread safe.',1,299); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (743,'StringBuffer and StringBuilder class both produces mutable string objects.',0,299); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (744,'true',1,302); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (745,'false',0,302); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (191,'When two methods in the same class have the same name, but are differentiated by the parameters which are passed in.',0,45); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (192,'When a subclass implements a method which shares the same name and passed-in parameters as a method in the parent class.',0,45); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (204,'"Data Hiding" - the practice of preventing propreties or data in one object from being directly manipulable outside of it.',1,49); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (205,'The principle of designing an application in such a way that each class is only responsible for certain tasks. E.g. a Car object should not be responsible for code pertaining to the Driver.',1,49); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (206,'The ability of an object to be of different related data types simultaneously. E.g. a String is an Object. Behaviors of an Object can be called for a String.',1,50); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (207,'When two methods in the same class have the same name, but are differentiated by the parameters which are passed in.',1,51); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (208,'When a subclass implements a method which shares the same name and passed-in parameters as a method in the parent class.',1,52); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (209,'new',1,53); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (210,'Public',1,54); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (211,'Private',1,54); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (212,'Protected',1,54); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (213,'Default/Packge/Package-Private',1,54); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (214,'Only one instance ever of the static member, shared between all instances of the containing class.',1,55); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (215,'A collection which can only hold unique objects, no duplicates.',1,56); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (216,'A collection where key objects are linked to value objects, like a dictionary.',1,57); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (217,'continue will skip the current iteration and continue with the next iteration break will exit the current block or looping structure',1,58); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (218,'During a Do While loop, the statement will execute at least once, if the condition fails',1,59); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (219,'A collection of objects stored in an indexed fashion.',1,60); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (220,'No, you can only extend them.',1,61); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (221,'Taking an object of one particular type and “turning it into” another object type',1,62); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (222,' == compares an object''s reference value, .equals() should compare object contents.',1,63); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (223,'A section of memory where immutable literals (like strings) are kept. All instances of objects referring to the value of a constant will point toward the same object in this pool.',1,64); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (224,'When a primitive is implicitly wrapped in its corresponding Wrapper class.',1,65); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (225,'Final makes a variable a local constant, it cannot be changed once it''s initialized to a value.',1,66); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (226,'A final method cannot be overridden in a subclass.',1,66); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (227,'A final class cannot be subclassed.',1,66); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (228,'Interfaces are implemented, Abstract classes are extended.',1,67); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (229,'A class may implement multiple interfaces, but may only extend one abstract class.',1,67); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (230,'Interfaces MUST NOT have any concrete methods, abstract classes MAY have concrete methods.',1,67); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (231,'Interface methods are implicitly Public, Static, Final, and Abstract.',1,67); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (232,'Finally is a code block that is always excuted after a corresponding try block.',1,68); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (233,'Finalize is a method executed just before garbage collection destroys the object.',1,68); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (234,'Strings are immutable constants, so two String objects with the same literal value are actually referring to the same String object in memory.',1,69); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (235,'Garbage collection can only be requested.',1,70); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (236,'No. After Java 6, you can no longer even request Garbage Collection System.gc();',1,71); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (237,'Hashtable is synchronized (thread-safe) HashMap is not.',1,72); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (238,'Hashtable doesn''t allow null values. HashMap can have 1 null key and any values can be null.',1,72); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (239,'HashMap has better performance',1,72); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (240,'FileNotFoundException is a subclass of IOException.',1,73); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (241,'FileNotFoundException must be caught first if both are included in a try-catch statement.',1,73); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (242,'LinkedList has faster inserts/deletes before the end (when using an iterator at that location).',1,74); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (243,'ArrayList has faster random access.',1,74); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (244,'new',1,75); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (245,'Public',1,76); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (246,'Private',1,76); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (247,'Protected',1,76); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (248,'Internal/Protected Internal',1,76); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (249,'No, but we can emulate this with interfaces since C# allows implementing multiple interfaces.',1,77); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (250,'Yes, unlike Java, you can force an immediate garbage collection in .NET although it is not recommended. GC.Collect()',1,78); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (251,'Any .NET language compiler outputs Microsoft Intermediate Language which then has to be JIT compiled to machine code at execution time',1,79); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (252,'A virtual method is a method that has it''s own implementation but may be overridden in child classes.',1,80); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (253,'An abtract method has no implementation and has to be overridden and implemented in a child class.',1,80); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (254,'Try-Catch-Finally',1,81); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (256,'IEnumberable',1,83); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (258,'var keyword was introduced in C# 3.0 in order to support for anonymous types used mostly in LINQ queries. It is known as an inference type and is strongly typed to the typeof the value that is assigned to it.',1,85); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (257,'The using block is a block in C# that compiles to a try-finally and in the finally block, unmanaged resources are disposed by calling the dispose() method. The objects that can be used in a using block have to implement the IDisposable interface',1,84); Insert into AES_USER.AES_OPTIONS (OPTION_ID,OPTION_TEXT,CORRECT,QUESTION_ID) values (259,'SELECT * FROM
CREATE UNIQUE INDEX "AES_USER"."PK_AES_API_TOKEN" ON "AES_USER"."AES_API_TOKEN" ("API_ID") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ;
CREATE UNIQUE INDEX "AES_USER"."PK_AES_ASSESSMENT" ON "AES_USER"."AES_ASSESSMENT" ("ASSESSMENT_ID") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ;
CREATE UNIQUE INDEX "AES_USER"."PK_AES_ASSESSMENT_DRAG_DROP" ON "AES_USER"."AES_ASSESSMENT_DRAG_DROP" ("ASSESSMENT_DRAG_DROP_ID") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ;
CREATE UNIQUE INDEX "AES_USER"."PK_AES_CATEGORY" ON "AES_USER"."AES_CATEGORY" ("CATEGORY_ID") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ;
CREATE UNIQUE INDEX "AES_USER"."PK_AES_CAT_REQUEST_ID" ON "AES_USER"."AES_CATEGORY_REQUEST" ("CATEGORY_REQUEST_ID") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ;
CREATE UNIQUE INDEX "AES_USER"."PK_AES_DRAG_DROP" ON "AES_USER"."AES_DRAG_DROP" ("DRAG_DROP_ID") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ;
CREATE UNIQUE INDEX "AES_USER"."PK_AES_FILE_UPLOAD" ON "AES_USER"."AES_FILE_UPLOAD" ("FILE_ID") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ;
CREATE UNIQUE INDEX "AES_USER"."PK_AES_FORMAT" ON "AES_USER"."AES_FORMATS" ("FORMAT_ID") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ;
CREATE UNIQUE INDEX "AES_USER"."PK_AES_OPTION" ON "AES_USER"."AES_OPTIONS" ("OPTION_ID") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ;
CREATE UNIQUE INDEX "AES_USER"."PK_AES_QUESTION" ON "AES_USER"."AES_QUESTION" ("QUESTION_ID") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ;
CREATE UNIQUE INDEX "AES_USER"."PK_AES_REQUEST_ID" ON "AES_USER"."AES_ASSESSMENT_REQUEST" ("ASSESSMENT_REQUEST_ID") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ;
CREATE UNIQUE INDEX "AES_USER"."PK_AES_ROLES" ON "AES_USER"."AES_ROLES" ("ROLE_ID") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ;
CREATE UNIQUE INDEX "AES_USER"."PK_AES_SECURITY" ON "AES_USER"."AES_SECURITY" ("USER_ID") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ;
CREATE UNIQUE INDEX "AES_USER"."PK_AES_SNIPPET_TEMPLATE" ON "AES_USER"."AES_SNIPPET_TEMPLATE" ("SNIPPET_TEMPLATE_ID") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ;
CREATE UNIQUE INDEX "AES_USER"."PK_AES_TAG" ON "AES_USER"."AES_TAGS" ("TAG_ID") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ;
CREATE UNIQUE INDEX "AES_USER"."PK_AES_TEMPLATES" ON "AES_USER"."AES_TEMPLATES" ("TEMPLATE_ID") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ;
CREATE UNIQUE INDEX "AES_USER"."PK_AES_TEMPLATE_QUESTION" ON "AES_USER"."AES_TEMPLATE_QUESTION" ("TEMPLATE_QUESTION_ID") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ;
CREATE UNIQUE INDEX "AES_USER"."PK_AES_USERS" ON "AES_USER"."AES_USERS" ("USER_ID") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ;
CREATE UNIQUE INDEX "AES_USER"."PK_ASSESSMENT_AUTH" ON "AES_USER"."AES_ASSESSMENT_AUTH" ("ASSESSMENT_AUTH_ID") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ;
CREATE UNIQUE INDEX "AES_USER"."SYS_C005708" ON "AES_USER"."AES_FORMATS" ("FORMAT_NAME") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ;
CREATE UNIQUE INDEX "AES_USER"."SYS_C005711" ON "AES_USER"."AES_TAGS" ("TAG_NAME") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ;
CREATE UNIQUE INDEX "AES_USER"."SYS_C005714" ON "AES_USER"."AES_CATEGORY" ("CATEGORY_NAME") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ;
CREATE UNIQUE INDEX "AES_USER"."SYS_C005730" ON "AES_USER"."AES_USERS" ("EMAIL") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ;
CREATE UNIQUE INDEX "AES_USER"."SYS_C005735" ON "AES_USER"."AES_ROLES" ("ROLE_TITLE") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ;
CREATE UNIQUE INDEX "AES_USER"."SYS_C005740" ON "AES_USER"."AES_FILE_UPLOAD" ("FILE_URL") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ;
CREATE UNIQUE INDEX "AES_USER"."SYS_C006103" ON "AES_USER"."AES_API_IP" ("IP_ID") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ;
CREATE UNIQUE INDEX "AES_USER"."UNIQUE_QC" ON "AES_USER"."AES_QUESTION_CATEGORY" ("QUESTION_ID", "CATEGORY_ID") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ;
CREATE UNIQUE INDEX "AES_USER"."UN_A_DD" ON "AES_USER"."AES_ASSESSMENT_DRAG_DROP" ("ASSESSMENT_ID", "DRAG_DROP_ID") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ;
CREATE UNIQUE INDEX "AES_USER"."UN_A_O" ON "AES_USER"."AES_ASSESSMENT_OPTIONS" ("ASSESSMENT_ID", "OPTION_ID") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ;
CREATE UNIQUE INDEX "AES_USER"."UN_Q_T" ON "AES_USER"."AES_QUESTION_TAG" ("QUESTION_ID", "TAG_ID") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ;
CREATE UNIQUE INDEX "AES_USER"."UN_ST_A" ON "AES_USER"."AES_SNIPPET_RESPONSE" ("SNIPPET_TEMPLATE_ID", "ASSESSMENT_ID") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ;
CREATE UNIQUE INDEX "AES_USER"."UN_T_Q" ON "AES_USER"."AES_TEMPLATE_QUESTION" ("TEMPLATE_ID", "QUESTION_ID") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ;
CREATE UNIQUE INDEX "AES_USER"."UN_U_T" ON "AES_USER"."AES_USER_TRAINERS" ("USER_ID", "TRAINER_ID") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ;
ALTER TABLE "AES_USER"."AES_API_IP" ADD PRIMARY KEY ("IP_ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ENABLE; ALTER TABLE "AES_USER"."AES_API_IP" MODIFY ("API_ID" NOT NULL ENABLE); ALTER TABLE "AES_USER"."AES_API_IP" MODIFY ("IP_ADDRESS" NOT NULL ENABLE);
ALTER TABLE "AES_USER"."AES_API_TOKEN" MODIFY ("DATE_ISSUED" NOT NULL ENABLE); ALTER TABLE "AES_USER"."AES_API_TOKEN" ADD CONSTRAINT "PK_AES_API_TOKEN" PRIMARY KEY ("API_ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ENABLE;
ALTER TABLE "AES_USER"."AES_ASSESSMENT" ADD CONSTRAINT "PK_AES_ASSESSMENT" PRIMARY KEY ("ASSESSMENT_ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ENABLE; ALTER TABLE "AES_USER"."AES_ASSESSMENT" MODIFY ("TIME_LIMIT" NOT NULL ENABLE); ALTER TABLE "AES_USER"."AES_ASSESSMENT" MODIFY ("USER_ID" NOT NULL ENABLE);
ALTER TABLE "AES_USER"."AES_ASSESSMENT_AUTH" ADD CONSTRAINT "PK_ASSESSMENT_AUTH" PRIMARY KEY ("ASSESSMENT_AUTH_ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ENABLE; ALTER TABLE "AES_USER"."AES_ASSESSMENT_AUTH" MODIFY ("URL_ASSESSMENT" NOT NULL ENABLE); ALTER TABLE "AES_USER"."AES_ASSESSMENT_AUTH" MODIFY ("URL_AUTH" NOT NULL ENABLE); ALTER TABLE "AES_USER"."AES_ASSESSMENT_AUTH" MODIFY ("USER_ID" NOT NULL ENABLE);
ALTER TABLE "AES_USER"."AES_ASSESSMENT_DRAG_DROP" ADD CONSTRAINT "UN_A_DD" UNIQUE ("ASSESSMENT_ID", "DRAG_DROP_ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ENABLE; ALTER TABLE "AES_USER"."AES_ASSESSMENT_DRAG_DROP" ADD CONSTRAINT "PK_AES_ASSESSMENT_DRAG_DROP" PRIMARY KEY ("ASSESSMENT_DRAG_DROP_ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ENABLE; ALTER TABLE "AES_USER"."AES_ASSESSMENT_DRAG_DROP" MODIFY ("DRAG_DROP_ID" NOT NULL ENABLE); ALTER TABLE "AES_USER"."AES_ASSESSMENT_DRAG_DROP" MODIFY ("ASSESSMENT_ID" NOT NULL ENABLE);
ALTER TABLE "AES_USER"."AES_ASSESSMENT_OPTIONS" ADD CONSTRAINT "UN_A_O" UNIQUE ("ASSESSMENT_ID", "OPTION_ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ENABLE; ALTER TABLE "AES_USER"."AES_ASSESSMENT_OPTIONS" MODIFY ("OPTION_ID" NOT NULL ENABLE); ALTER TABLE "AES_USER"."AES_ASSESSMENT_OPTIONS" MODIFY ("ASSESSMENT_ID" NOT NULL ENABLE);
ALTER TABLE "AES_USER"."AES_ASSESSMENT_REQUEST" ADD CONSTRAINT "PK_AES_REQUEST_ID" PRIMARY KEY ("ASSESSMENT_REQUEST_ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ENABLE; ALTER TABLE "AES_USER"."AES_ASSESSMENT_REQUEST" MODIFY ("TIMELIMIT" NOT NULL ENABLE);
ALTER TABLE "AES_USER"."AES_CATEGORY" ADD UNIQUE ("CATEGORY_NAME") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ENABLE; ALTER TABLE "AES_USER"."AES_CATEGORY" ADD CONSTRAINT "PK_AES_CATEGORY" PRIMARY KEY ("CATEGORY_ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ENABLE; ALTER TABLE "AES_USER"."AES_CATEGORY" MODIFY ("CATEGORY_NAME" NOT NULL ENABLE);
ALTER TABLE "AES_USER"."AES_CATEGORY_REQUEST" ADD CONSTRAINT "PK_AES_CAT_REQUEST_ID" PRIMARY KEY ("CATEGORY_REQUEST_ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ENABLE; ALTER TABLE "AES_USER"."AES_CATEGORY_REQUEST" MODIFY ("CS_QUESTIONS" NOT NULL ENABLE); ALTER TABLE "AES_USER"."AES_CATEGORY_REQUEST" MODIFY ("DD_QUESTIONS" NOT NULL ENABLE); ALTER TABLE "AES_USER"."AES_CATEGORY_REQUEST" MODIFY ("MS_QUESTIONS" NOT NULL ENABLE); ALTER TABLE "AES_USER"."AES_CATEGORY_REQUEST" MODIFY ("MC_QUESTIONS" NOT NULL ENABLE); ALTER TABLE "AES_USER"."AES_CATEGORY_REQUEST" MODIFY ("CATEGORY_ID" NOT NULL ENABLE);
ALTER TABLE "AES_USER"."AES_DRAG_DROP" ADD CONSTRAINT "PK_AES_DRAG_DROP" PRIMARY KEY ("DRAG_DROP_ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ENABLE; ALTER TABLE "AES_USER"."AES_DRAG_DROP" MODIFY ("CORRECT_ORDER" NOT NULL ENABLE); ALTER TABLE "AES_USER"."AES_DRAG_DROP" MODIFY ("DRAG_DROP_TEXT" NOT NULL ENABLE); ALTER TABLE "AES_USER"."AES_DRAG_DROP" MODIFY ("QUESTION_ID" NOT NULL ENABLE); ALTER TABLE "AES_USER"."AES_DRAG_DROP" MODIFY ("DRAG_DROP_ID" NOT NULL ENABLE);
ALTER TABLE "AES_USER"."AES_FILE_UPLOAD" ADD UNIQUE ("FILE_URL") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ENABLE; ALTER TABLE "AES_USER"."AES_FILE_UPLOAD" ADD CONSTRAINT "PK_AES_FILE_UPLOAD" PRIMARY KEY ("FILE_ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ENABLE; ALTER TABLE "AES_USER"."AES_FILE_UPLOAD" MODIFY ("ASSESSMENT_ID" NOT NULL ENABLE); ALTER TABLE "AES_USER"."AES_FILE_UPLOAD" MODIFY ("QUESTION_ID" NOT NULL ENABLE); ALTER TABLE "AES_USER"."AES_FILE_UPLOAD" MODIFY ("FILE_URL" NOT NULL ENABLE);
ALTER TABLE "AES_USER"."AES_FORMATS" ADD UNIQUE ("FORMAT_NAME") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ENABLE; ALTER TABLE "AES_USER"."AES_FORMATS" ADD CONSTRAINT "PK_AES_FORMAT" PRIMARY KEY ("FORMAT_ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ENABLE; ALTER TABLE "AES_USER"."AES_FORMATS" MODIFY ("FORMAT_NAME" NOT NULL ENABLE);
ALTER TABLE "AES_USER"."AES_OPTIONS" ADD CONSTRAINT "PK_AES_OPTION" PRIMARY KEY ("OPTION_ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ENABLE; ALTER TABLE "AES_USER"."AES_OPTIONS" ADD CONSTRAINT "CHECK_CORRECT" CHECK ( correct IN ( 0, 1 ) ) ENABLE; ALTER TABLE "AES_USER"."AES_OPTIONS" MODIFY ("CORRECT" NOT NULL ENABLE); ALTER TABLE "AES_USER"."AES_OPTIONS" MODIFY ("OPTION_TEXT" NOT NULL ENABLE);
ALTER TABLE "AES_USER"."AES_QUESTION" ADD CONSTRAINT "PK_AES_QUESTION" PRIMARY KEY ("QUESTION_ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ENABLE; ALTER TABLE "AES_USER"."AES_QUESTION" MODIFY ("QUESTION_TEXT" NOT NULL ENABLE); ALTER TABLE "AES_USER"."AES_QUESTION" MODIFY ("QUESTION_FORMAT_ID" NOT NULL ENABLE);
ALTER TABLE "AES_USER"."AES_QUESTION_CATEGORY" ADD CONSTRAINT "UNIQUE_QC" UNIQUE ("QUESTION_ID", "CATEGORY_ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ENABLE; ALTER TABLE "AES_USER"."AES_QUESTION_CATEGORY" MODIFY ("CATEGORY_ID" NOT NULL ENABLE); ALTER TABLE "AES_USER"."AES_QUESTION_CATEGORY" MODIFY ("QUESTION_ID" NOT NULL ENABLE);
ALTER TABLE "AES_USER"."AES_QUESTION_TAG" ADD CONSTRAINT "UN_Q_T" UNIQUE ("QUESTION_ID", "TAG_ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ENABLE; ALTER TABLE "AES_USER"."AES_QUESTION_TAG" MODIFY ("TAG_ID" NOT NULL ENABLE); ALTER TABLE "AES_USER"."AES_QUESTION_TAG" MODIFY ("QUESTION_ID" NOT NULL ENABLE);
ALTER TABLE "AES_USER"."AES_ROLES" ADD UNIQUE ("ROLE_TITLE") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ENABLE; ALTER TABLE "AES_USER"."AES_ROLES" ADD CONSTRAINT "PK_AES_ROLES" PRIMARY KEY ("ROLE_ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ENABLE; ALTER TABLE "AES_USER"."AES_ROLES" MODIFY ("ROLE_TITLE" NOT NULL ENABLE);
ALTER TABLE "AES_USER"."AES_SECURITY" ADD CONSTRAINT "PK_AES_SECURITY" PRIMARY KEY ("USER_ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ENABLE; ALTER TABLE "AES_USER"."AES_SECURITY" ADD CONSTRAINT "CHECK_VALID" CHECK ( valid IN ( 0, 1 ) ) ENABLE; ALTER TABLE "AES_USER"."AES_SECURITY" MODIFY ("VALID" NOT NULL ENABLE); ALTER TABLE "AES_USER"."AES_SECURITY" MODIFY ("PASS_WORD" NOT NULL ENABLE);
ALTER TABLE "AES_USER"."AES_SNIPPET_RESPONSE" ADD CONSTRAINT "UN_ST_A" UNIQUE ("SNIPPET_TEMPLATE_ID", "ASSESSMENT_ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ENABLE; ALTER TABLE "AES_USER"."AES_SNIPPET_RESPONSE" MODIFY ("ASSESSMENT_ID" NOT NULL ENABLE); ALTER TABLE "AES_USER"."AES_SNIPPET_RESPONSE" MODIFY ("SNIPPET_TEMPLATE_ID" NOT NULL ENABLE);
ALTER TABLE "AES_USER"."AES_SNIPPET_TEMPLATE" ADD CONSTRAINT "PK_AES_SNIPPET_TEMPLATE" PRIMARY KEY ("SNIPPET_TEMPLATE_ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ENABLE; ALTER TABLE "AES_USER"."AES_SNIPPET_TEMPLATE" MODIFY ("SOLUTION_URL" NOT NULL ENABLE); ALTER TABLE "AES_USER"."AES_SNIPPET_TEMPLATE" MODIFY ("SNIPPET_TEMPLATE_URL" NOT NULL ENABLE); ALTER TABLE "AES_USER"."AES_SNIPPET_TEMPLATE" MODIFY ("FILE_TYPE" NOT NULL ENABLE); ALTER TABLE "AES_USER"."AES_SNIPPET_TEMPLATE" MODIFY ("QUESTION_ID" NOT NULL ENABLE);
ALTER TABLE "AES_USER"."AES_TAGS" ADD UNIQUE ("TAG_NAME") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ENABLE; ALTER TABLE "AES_USER"."AES_TAGS" ADD CONSTRAINT "PK_AES_TAG" PRIMARY KEY ("TAG_ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ENABLE; ALTER TABLE "AES_USER"."AES_TAGS" MODIFY ("TAG_NAME" NOT NULL ENABLE);
ALTER TABLE "AES_USER"."AES_TEMPLATES" ADD CONSTRAINT "PK_AES_TEMPLATES" PRIMARY KEY ("TEMPLATE_ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ENABLE; ALTER TABLE "AES_USER"."AES_TEMPLATES" MODIFY ("CREATOR_ID" NOT NULL ENABLE); ALTER TABLE "AES_USER"."AES_TEMPLATES" MODIFY ("CREATE_TIMESTAMP" NOT NULL ENABLE);
ALTER TABLE "AES_USER"."AES_TEMPLATE_QUESTION" ADD CONSTRAINT "UN_T_Q" UNIQUE ("TEMPLATE_ID", "QUESTION_ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ENABLE; ALTER TABLE "AES_USER"."AES_TEMPLATE_QUESTION" ADD CONSTRAINT "PK_AES_TEMPLATE_QUESTION" PRIMARY KEY ("TEMPLATE_QUESTION_ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ENABLE; ALTER TABLE "AES_USER"."AES_TEMPLATE_QUESTION" MODIFY ("QUESTION_ID" NOT NULL ENABLE); ALTER TABLE "AES_USER"."AES_TEMPLATE_QUESTION" MODIFY ("TEMPLATE_ID" NOT NULL ENABLE);
ALTER TABLE "AES_USER"."AES_USERS" ADD UNIQUE ("EMAIL") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ENABLE; ALTER TABLE "AES_USER"."AES_USERS" ADD CONSTRAINT "PK_AES_USERS" PRIMARY KEY ("USER_ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ENABLE; ALTER TABLE "AES_USER"."AES_USERS" MODIFY ("DATE_PASS_ISSUED" NOT NULL ENABLE); ALTER TABLE "AES_USER"."AES_USERS" MODIFY ("ROLE_ID" NOT NULL ENABLE); ALTER TABLE "AES_USER"."AES_USERS" MODIFY ("LASTNAME" NOT NULL ENABLE); ALTER TABLE "AES_USER"."AES_USERS" MODIFY ("FIRSTNAME" NOT NULL ENABLE); ALTER TABLE "AES_USER"."AES_USERS" MODIFY ("EMAIL" NOT NULL ENABLE);
ALTER TABLE "AES_USER"."AES_USER_TRAINERS" ADD CONSTRAINT "UN_U_T" UNIQUE ("USER_ID", "TRAINER_ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ENABLE; ALTER TABLE "AES_USER"."AES_USER_TRAINERS" MODIFY ("TRAINER_ID" NOT NULL ENABLE); ALTER TABLE "AES_USER"."AES_USER_TRAINERS" MODIFY ("USER_ID" NOT NULL ENABLE);
ALTER TABLE "AES_USER"."AES_API_IP" ADD CONSTRAINT "IP_ADDRESS_API_TOKEN_API_ID_FK" FOREIGN KEY ("IP_ID") REFERENCES "AES_USER"."AES_API_TOKEN" ("API_ID") ENABLE;
ALTER TABLE "AES_USER"."AES_ASSESSMENT" ADD CONSTRAINT "FK_A_TEMPLATE" FOREIGN KEY ("TEMPLATE_ID") REFERENCES "AES_USER"."AES_TEMPLATES" ("TEMPLATE_ID") ON DELETE CASCADE ENABLE; ALTER TABLE "AES_USER"."AES_ASSESSMENT" ADD CONSTRAINT "FK_A_USER" FOREIGN KEY ("USER_ID") REFERENCES "AES_USER"."AES_USERS" ("USER_ID") ON DELETE CASCADE ENABLE;
ALTER TABLE "AES_USER"."AES_ASSESSMENT_AUTH" ADD CONSTRAINT "FK_ASSESSMENT_AUTH_USER_ID" FOREIGN KEY ("USER_ID") REFERENCES "AES_USER"."AES_USERS" ("USER_ID") ON DELETE CASCADE ENABLE;
ALTER TABLE "AES_USER"."AES_ASSESSMENT_DRAG_DROP" ADD CONSTRAINT "FK_AD_ASSESSMENT_ID" FOREIGN KEY ("ASSESSMENT_ID") REFERENCES "AES_USER"."AES_ASSESSMENT" ("ASSESSMENT_ID") ON DELETE CASCADE ENABLE; ALTER TABLE "AES_USER"."AES_ASSESSMENT_DRAG_DROP" ADD CONSTRAINT "FK_AD_DRAG_DROP_ID" FOREIGN KEY ("DRAG_DROP_ID") REFERENCES "AES_USER"."AES_DRAG_DROP" ("DRAG_DROP_ID") ON DELETE CASCADE ENABLE;
ALTER TABLE "AES_USER"."AES_ASSESSMENT_OPTIONS" ADD CONSTRAINT "FK_AO_ASSESSMENT_ID" FOREIGN KEY ("ASSESSMENT_ID") REFERENCES "AES_USER"."AES_ASSESSMENT" ("ASSESSMENT_ID") ON DELETE CASCADE ENABLE; ALTER TABLE "AES_USER"."AES_ASSESSMENT_OPTIONS" ADD CONSTRAINT "FK_AO_OPTION_ID" FOREIGN KEY ("OPTION_ID") REFERENCES "AES_USER"."AES_OPTIONS" ("OPTION_ID") ON DELETE CASCADE ENABLE;
ALTER TABLE "AES_USER"."AES_CATEGORY_REQUEST" ADD CONSTRAINT "FK_AES_ASSESS_REQ_ID" FOREIGN KEY ("ASSESSMENT_REQUEST_ID") REFERENCES "AES_USER"."AES_ASSESSMENT_REQUEST" ("ASSESSMENT_REQUEST_ID") ON DELETE CASCADE ENABLE; ALTER TABLE "AES_USER"."AES_CATEGORY_REQUEST" ADD CONSTRAINT "FK_AES_CATEGORY" FOREIGN KEY ("CATEGORY_ID") REFERENCES "AES_USER"."AES_CATEGORY" ("CATEGORY_ID") ON DELETE CASCADE ENABLE;
ALTER TABLE "AES_USER"."AES_DRAG_DROP" ADD CONSTRAINT "FK_QUESTION_ID" FOREIGN KEY ("QUESTION_ID") REFERENCES "AES_USER"."AES_QUESTION" ("QUESTION_ID") ON DELETE CASCADE ENABLE;
ALTER TABLE "AES_USER"."AES_FILE_UPLOAD" ADD CONSTRAINT "FK_FU_ASSESSMENT" FOREIGN KEY ("ASSESSMENT_ID") REFERENCES "AES_USER"."AES_ASSESSMENT" ("ASSESSMENT_ID") ON DELETE CASCADE ENABLE; ALTER TABLE "AES_USER"."AES_FILE_UPLOAD" ADD CONSTRAINT "FK_FU_QUESTION" FOREIGN KEY ("QUESTION_ID") REFERENCES "AES_USER"."AES_QUESTION" ("QUESTION_ID") ON DELETE CASCADE ENABLE;
ALTER TABLE "AES_USER"."AES_OPTIONS" ADD CONSTRAINT "FK_O_QUESTION_ID" FOREIGN KEY ("QUESTION_ID") REFERENCES "AES_USER"."AES_QUESTION" ("QUESTION_ID") ON DELETE CASCADE ENABLE;
ALTER TABLE "AES_USER"."AES_QUESTION" ADD CONSTRAINT "FK_QUESTION_FORMAT_ID" FOREIGN KEY ("QUESTION_FORMAT_ID") REFERENCES "AES_USER"."AES_FORMATS" ("FORMAT_ID") ON DELETE CASCADE ENABLE;
ALTER TABLE "AES_USER"."AES_QUESTION_CATEGORY" ADD CONSTRAINT "FK_QC_CATEGORY_ID" FOREIGN KEY ("CATEGORY_ID") REFERENCES "AES_USER"."AES_CATEGORY" ("CATEGORY_ID") ON DELETE CASCADE ENABLE; ALTER TABLE "AES_USER"."AES_QUESTION_CATEGORY" ADD CONSTRAINT "FK_QC_QUESTION_ID" FOREIGN KEY ("QUESTION_ID") REFERENCES "AES_USER"."AES_QUESTION" ("QUESTION_ID") ON DELETE CASCADE ENABLE;
ALTER TABLE "AES_USER"."AES_QUESTION_TAG" ADD CONSTRAINT "FK_QT_QUESTION_ID" FOREIGN KEY ("QUESTION_ID") REFERENCES "AES_USER"."AES_QUESTION" ("QUESTION_ID") ON DELETE CASCADE ENABLE; ALTER TABLE "AES_USER"."AES_QUESTION_TAG" ADD CONSTRAINT "FK_QT_TAG_ID" FOREIGN KEY ("TAG_ID") REFERENCES "AES_USER"."AES_TAGS" ("TAG_ID") ON DELETE CASCADE ENABLE;
ALTER TABLE "AES_USER"."AES_SECURITY" ADD CONSTRAINT "FK_S_USER" FOREIGN KEY ("USER_ID") REFERENCES "AES_USER"."AES_USERS" ("USER_ID") ON DELETE CASCADE ENABLE;
ALTER TABLE "AES_USER"."AES_SNIPPET_RESPONSE" ADD CONSTRAINT "FK_SR_ASSESSMENT_ID" FOREIGN KEY ("ASSESSMENT_ID") REFERENCES "AES_USER"."AES_ASSESSMENT" ("ASSESSMENT_ID") ENABLE; ALTER TABLE "AES_USER"."AES_SNIPPET_RESPONSE" ADD CONSTRAINT "FK_SR_SNIPPET_TEMPLATE_ID" FOREIGN KEY ("SNIPPET_TEMPLATE_ID") REFERENCES "AES_USER"."AES_SNIPPET_TEMPLATE" ("SNIPPET_TEMPLATE_ID") ENABLE;
ALTER TABLE "AES_USER"."AES_SNIPPET_TEMPLATE" ADD CONSTRAINT "FK_ST_QUESTION_ID" FOREIGN KEY ("QUESTION_ID") REFERENCES "AES_USER"."AES_QUESTION" ("QUESTION_ID") ENABLE;
ALTER TABLE "AES_USER"."AES_TEMPLATES" ADD CONSTRAINT "FK_TEMPLATES_CREATOR_ID" FOREIGN KEY ("CREATOR_ID") REFERENCES "AES_USER"."AES_USERS" ("USER_ID") ON DELETE CASCADE ENABLE;
ALTER TABLE "AES_USER"."AES_TEMPLATE_QUESTION" ADD CONSTRAINT "FK_TC_QUESTION_ID" FOREIGN KEY ("QUESTION_ID") REFERENCES "AES_USER"."AES_QUESTION" ("QUESTION_ID") ON DELETE CASCADE ENABLE; ALTER TABLE "AES_USER"."AES_TEMPLATE_QUESTION" ADD CONSTRAINT "FK_TEMPLATE_ID" FOREIGN KEY ("TEMPLATE_ID") REFERENCES "AES_USER"."AES_TEMPLATES" ("TEMPLATE_ID") ON DELETE CASCADE ENABLE;
ALTER TABLE "AES_USER"."AES_USERS" ADD CONSTRAINT "FK_U_USERS_ROLE" FOREIGN KEY ("ROLE_ID") REFERENCES "AES_USER"."AES_ROLES" ("ROLE_ID") ON DELETE CASCADE ENABLE;
ALTER TABLE "AES_USER"."AES_USER_TRAINERS" ADD CONSTRAINT "FK_UT_TRAINER" FOREIGN KEY ("TRAINER_ID") REFERENCES "AES_USER"."AES_USERS" ("USER_ID") ON DELETE CASCADE ENABLE; ALTER TABLE "AES_USER"."AES_USER_TRAINERS" ADD CONSTRAINT "FK_UT_USER" FOREIGN KEY ("USER_ID") REFERENCES "AES_USER"."AES_USERS" ("USER_ID") ON DELETE CASCADE ENABLE; `