<!DOCTYPE html>
<html lang="en">
<head>
	<meta charset="utf-8">
	<meta http-equiv="X-UA-Compatible" content="IE=edge">
	<meta name="viewport" content="width=device-width, initial-scale=1">
	<title>Basic Quiz Application with login and logout options as well as computation of final scores</title>
	<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" integrity="sha384-1q8mTJOASx8j1Au+a5WDVnPi2lkFfwwEAa8hDDdjZlpLegxhjVME1fgjWPGmkzs7" crossorigin="anonymous">
	<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/js/bootstrap.min.js" integrity="sha384-0mSbJDEHialfmuBBQP6A4Qrprq5OVfW37PRR3j5ELqxss1yVqOtnepnHVP9aJ7xS" crossorigin="anonymous"></script>
	<link rel="stylesheet" type="text/css" href="\css\topicpage_1.css">
	<script>
		function score(){
	    var count=0;
	    if (document.getElementById('correct_1').checked) {
	    	count=count+1;
	    }
	    if (document.getElementById('correct_2').checked) {
			count=count+1;
		}
		if (document.getElementById('correct_3').checked) {
			count=count+1;
		}
		alert("Score obtained = " + count + "\nRedirecting to the home screen");
		window.location.replace('/');
		}
	</script>
</head>
<body>
	<main>
		<form>
			<h2>Q1 Which language used by most of the DBMS enabling their users to access data ?</h2>
			<aside><p>1 point</p></aside>
			<label class="transform"><input type="radio" checked="checked" name="database" value="High level language">High level language <span class="correct"></span></label><br/>
			<label class="transform"><input type="radio" name="database" value="Query language" id="correct_1">Query language <span class="correct"></span></label><br/>
			<label class="transform"><input type="radio" name="database" value="SQL">SQL <span class="correct"></span></label><br/>
			<label class="transform"><input type="radio" name="database" value="4GL">4GL <span class="correct"></span></label><br/>	
			<h2>Q2 In SQL, which command is used to enable/disable a database trigger ?</h2>
			<aside><p>1 point</p></aside>
			<label class="transform"><input type="radio" checked="checked" name="database_1" value="ALTER TRIGGER" id="correct_2">ALTER TRIGGER <span class="correct"></span></label><br/>
			<label class="transform"><input type="radio" name="database_1" value="All of the above">All of the above <span class="correct"></span></label><br/>
			<label class="transform"><input type="radio" name="database_1" value="MODIFY USER">MODIFY USER <span class="correct"></span></label><br/>
			<label class="transform"><input type="radio" name="database_1" value="CHANGE USER">CHANGE USER <span class="correct"></span></label><br/>
			<h2>Q3 Which command is used to remove an index from the database in SQL ?</h2>
			<aside><p>1 point</p></aside>
			<label class="transform"><input type="radio" checked="checked" name="database_2" value="ROLL BACK INDEX">ROLL BACK INDEX <span class="correct"></span></label><br/>
			<label class="transform"><input type="radio" name="database_2" value="DELETE INDEX">DELETE INDEX <span class="correct"></span></label><br/>
			<label class="transform"><input type="radio" name="database_2" value="DROP INDEX" id="correct_3">DROP INDEX <span class="correct"></span></label><br/>
			<label class="transform"><input type="radio" name="database_2" value="REMOVE INDEX">REMOVE INDEX <span class="correct"></span></label><br/>
			<input type="button" value="Submit" name="submission" class="transform_1" onclick="score()">
		</form>	
	</main>
	<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.3/jquery.min.js"></script>
	<script src="js/bootstrap.min.js"></script>
</body>
</html>