Skip to content

Instantly share code, notes, and snippets.

@styliii
Created October 4, 2012 21:54
Show Gist options
  • Save styliii/3836720 to your computer and use it in GitHub Desktop.
Save styliii/3836720 to your computer and use it in GitHub Desktop.
Questions and Answers to Quiz 2
INSERT INTO question (content, quizzes_id)
VALUES
("Who is the father of relational databases?", 2),
("What is referential integrity?", 2),
("In a one to many relationship, which table contains the foreign key?", 2),
("What is a normalized table?", 2),
("How many different type of joins are there?", 2);
INSERT INTO choices (content, correct, questions_id)
VALUES
("A database concept that ensures that relationships between tables remain consistent.", 1, 7),
("Not referencing another person's code and claiming it as you own.", 0, 7),
("Having function calls avoid repeating a calculation to speed up computer programs.", 0, 7),
("Writing efficient SQL queries.", 0, 7),
("Larry Ellison", 0, 6),
("Ted Codd", 1, 6),
("Ada Lovelace", 0, 6),
("Steve Jobs", 0, 6),
("Both tables.", 0, 6),
("The many table in the one to many.", 0, 8),
("The one table in the one to many.", 1, 8),
("I have no idea what you're talking about.", 0, 8),
("A database that doesn't have the inefficiencies of a relational database.", 0, 9),
("A database with a standard deviation of 1 and mean of 0.", 0, 9),
("Minimizing redundacy and depedency, by dividing a database into two more more smaller tables.", 1, 9),
("A database that follows the widely accepted schema template.", 0, 9),
("4", 0, 10),
("8", 0, 10),
("1", 0, 10),
("5", 1, 10);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment