--------------------------------------------------------
--  File created - Monday-November-07-2022
--------------------------------------------------------
--------------------------------------------------------
--  DDL for Table QUESTIONS
--------------------------------------------------------

  CREATE TABLE "IGLOO"."QUESTIONS"
   (	"ID" NUMBER(*,0),
	"QUESTION" VARCHAR2(255 BYTE)
   ) SEGMENT CREATION IMMEDIATE
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 262144 NEXT 262144 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "IGLOO_TAB" ;
REM INSERTING into IGLOO.QUESTIONS
SET DEFINE OFF;
Insert into IGLOO.QUESTIONS (ID,QUESTION) values (10,'In what town or city was your first job?');
Insert into IGLOO.QUESTIONS (ID,QUESTION) values (20,'What was your favorite place to visit as a child?');
Insert into IGLOO.QUESTIONS (ID,QUESTION) values (30,'What is the first name of your favorite childhood friend?');
Insert into IGLOO.QUESTIONS (ID,QUESTION) values (40,'In what town or city did your parents meet?');
Insert into IGLOO.QUESTIONS (ID,QUESTION) values (50,'What is the middle (or least known) name of your favorite sibling?');
Insert into IGLOO.QUESTIONS (ID,QUESTION) values (60,'What is your grandmother''s (on your mother''s side) maiden name?');
Insert into IGLOO.QUESTIONS (ID,QUESTION) values (70,'What is your grandmother''s (on your father''s side) maiden name?');
Insert into IGLOO.QUESTIONS (ID,QUESTION) values (80,'What musician or group played at the first concert you attended?');
Insert into IGLOO.QUESTIONS (ID,QUESTION) values (90,'What is the last name of your favorite teacher?');
Insert into IGLOO.QUESTIONS (ID,QUESTION) values (100,'What is your spouse''s mother''s maiden name?');
Insert into IGLOO.QUESTIONS (ID,QUESTION) values (110,'In what city or town were you born?');
Insert into IGLOO.QUESTIONS (ID,QUESTION) values (120,'What was the name of your first pet?');
Insert into IGLOO.QUESTIONS (ID,QUESTION) values (130,'What school did you attend in fifth grade?');
--------------------------------------------------------
--  DDL for Index QUESTIONS_INDEX1
--------------------------------------------------------

  CREATE INDEX "IGLOO"."QUESTIONS_INDEX1" ON "IGLOO"."QUESTIONS" ("ID")
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  STORAGE(INITIAL 262144 NEXT 262144 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "IGLOO_TAB" ;
--------------------------------------------------------
--  Constraints for Table QUESTIONS
--------------------------------------------------------

  ALTER TABLE "IGLOO"."QUESTIONS" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "IGLOO"."QUESTIONS" MODIFY ("QUESTION" NOT NULL ENABLE);
  ALTER TABLE "IGLOO"."QUESTIONS" ADD CONSTRAINT "QUESTIONS_PK" PRIMARY KEY ("ID")
  USING INDEX "IGLOO"."QUESTIONS_INDEX1"  ENABLE;
