YouGrade - Asp.NET MVC Multimedia Exam Suite

DELETE dbo.Answer
DELETE dbo.Alternative
DELETE dbo.QuestionDef
DELETE dbo.ExamTake
DELETE dbo.ExamDef
DELETE dbo.[User]
GO
INSERT dbo.[User](Login, Password, Firstname, Lastname)
	SELECT 'code', 'project', 'John', 'Doe'

DECLARE @ExamDefId INT
DECLARE @QuestionDefId INT
INSERT dbo.ExamDef (Name, Description, MinimumOfCorrectAnswers, Duration)
	SELECT 'English Listening Comprehension Test', 'Show your knowledge on the English language using videos from The Big Bang Theory', 7, CONVERT(DATETIME, '01:00:00')
SET @ExamDefId = @@IDENTITY
INSERT dbo.QuestionDef (ExamId, Text, Url, StartSeconds, Explanation, Mark, IsMultiSelect)
	SELECT
	@ExamDefId, 
	'In this episode, Sheldon proposes to Raj a variation for the classic "Jokempo" game: instead of "rock-paper-scissors", the variation is "rock-paper-scissors-lizard-spock". In his explanation for the game rules, Sheldon points out that paper beats Spock. How can Spock be defeated by paper?',
	'iapcKVn7DdY',
	0,
	'',
	'',
	0
SET @QuestionDefId = @@IDENTITY
INSERT dbo.Alternative (QuestionId, Id, Text, Correct)
	SELECT 
	@QuestionDefId,
	'A', 'A large sheet of paper can wrap Spock, in the same way that it covers rock.', 0 UNION
	SELECT 
	@QuestionDefId,
	'B', 'Spock''s fingers are not as sharp as scissors, and paper can cut his finger deep.', 0 UNION
	SELECT 
	@QuestionDefId,
	'C', 'Being Spock a scientist, a paper (academic research) can refute one of his theories.', 1 UNION
	SELECT 
	@QuestionDefId,
	'D', 'Paper doesn''t beat Spock. In fact, Sheldon points out that Spock against paper ends in a tie.', 0

INSERT dbo.QuestionDef (ExamId, Text, Url,StartSeconds, Explanation, Mark, IsMultiSelect)
	SELECT
	@ExamDefId, 
	'In "The Friendship Algorithm", Sheldon is learning about friendship and draws a flowchart in his white board. He then invites Kripke to go out with him in some activity. Sheldon uses the friendship algorithm, but every activity proposed by Kripke is rejected by Sheldon, and at some point he gets stuck in an infinite loop. How Howard managed to help him get out of the loop?',
	'w7j7E7J3f6E',
	0,
	'',
	'',
	0
SET @QuestionDefId = @@IDENTITY
INSERT dbo.Alternative (QuestionId, Id, Text, Correct)
	SELECT 
	@QuestionDefId,
	'A', 'Howard convinced Sheldon to practice rock climbing with Kripke.', 0 UNION
	SELECT 
	@QuestionDefId,
	'B', 'By drawing a loop counter and an escape to the least objectionable activity.', 1 UNION
	SELECT 
	@QuestionDefId,
	'C', 'In fact, Howard doesn''t help Sheldon at all. Sheldon decides to go rock climbinbg by itself.', 0 UNION
	SELECT 
	@QuestionDefId,
	'D', 'Sheldon doesn''t get out of the infinite loop. He just get a break to do some internet search before finishing the friendship algorithm path.', 0
INSERT dbo.QuestionDef (ExamId, Text, Url, StartSeconds,Explanation, Mark, IsMultiSelect)
	SELECT
	@ExamDefId, 
	'In this video, somebody is auctioning a time machine replica from the "Time Machine" movie. Leonard bid $800, and when the auction ends, Sheldon is surprised that no one else bid, since it''s a piece of sci-fi movie memorabilia. In the end of the video, Sheldon says he understood why no-one else bid. Why he said so?',
	'fRaUVp5DfRk',
	34,
	'',
	'',
	0
SET @QuestionDefId = @@IDENTITY
INSERT dbo.Alternative (QuestionId, Id, Text, Correct)
	SELECT 
	@QuestionDefId,
	'A', 'Because instead of a miniature, Sheldon found the time machine replica to be in fact full-sized and extravagant.', 1 UNION
	SELECT 
	@QuestionDefId,
	'B', 'Because Sheldon saw it wasn''t a real time machine.', 0 UNION
	SELECT 
	@QuestionDefId,
	'C', 'Because it was nothing like the time machine in the movie.', 0 UNION
	SELECT 
	@QuestionDefId,
	'D', 'Because the time machine was damaged.', 0
INSERT dbo.QuestionDef (ExamId, Text, Url, StartSeconds,Explanation, Mark, IsMultiSelect)
	SELECT
	@ExamDefId, 
	'At the University cafeteria, Sheldon is discussing with his friend Leonard the problem with teleportation. At the end, Leonard seems to agree with Sheldon that there is a problem. What problem they are talking about?',
	'PQZzSrAIp-E',
	0,
	'',
	'',
	0
SET @QuestionDefId = @@IDENTITY
INSERT dbo.Alternative (QuestionId, Id, Text, Correct)
	SELECT 
	@QuestionDefId,
	'A', 'Both agreed that it would be a problem if the teletransporter had to disintegrate the original Sheldon in order to create the new Sheldon', 0 UNION
	SELECT 
	@QuestionDefId,
	'B', 'Both agreed that it would be a problem if the new Sheldon created by the teletransporter had no new improvements compared to the old Sheldon.', 0 UNION
	SELECT 
	@QuestionDefId,
	'C', 'Sheldon said it would be a problem if the teletransporter had to disintegrate the original Sheldon in order to create the new Sheldon, and Leonard just pretended to care about it.', 0 UNION
	SELECT 
	@QuestionDefId,
	'D', 'Sheldon said he would never use a teletransporter, because this would disintegrate the original Sheldon in order to create the new Sheldon. Leonard, on the other hand, thought it was a problem if the new Sheldon was exactly the same as the old Sheldon (without improvements), but Sheldon didn''t understand Leonard''s sarcasm.', 1
GO