SIMPLE SQL QUIZ

 CODE:

import java.lang.*;

import java.io.*;

class Questions

{

public String [][]qpa; 

public String[][]qca; 

Questions()throws IOException

{

qpa=new String[10][5];

//questionsandobjectives//

DataInputStream in=new DataInputStream(System.in);

qpa[0][0]="What does SQL stand for?"; 

qpa[0][1]="1.Structure Question Language";

qpa[0][2]="2.Strong Question Language "; 

qpa[0][3]="3.Structured Query Language";

qpa[0][4]="4.None of this";

qpa[1][0]="Which SQL statement is used to extract sata from a database?"; 

qpa[1][1]="1.GET";

qpa[1][2]="2.OPEN"; 

qpa[1][3]="3.EXTRACT";

qpa[1][4]="4.SELECT";

qpa[2][0]="Which SQL stateement is used to update data in a database?"; 

qpa[2][1]="1.SAVE";

qpa[2][2]="2.SAVE AS";

qpa[2][3]="3.MODIFY";

qpa[2][4]="4.UPDATE";

qpa[3][0]="Which SQL statement is used to insert new data in a database?"; 

qpa[3][1]="1.INSERT NEW";

qpa[3][2]="2.ADD NEW";

qpa[3][3]="3.ADD RECORD";

qpa[3][4]="4.INSERT INTO";

qpa[4][0]="Which SQL statementis used to delete data from database?";

qpa[4][1]="1.DELETE";

qpa[4][2]="2.COLLAPSE";

qpa[4][3]="3.REMOVE";

qpa[4][4]="4.CLEAR";

qpa[5][0]=" with SQL , how do you select a column named First Name from a table named Person?";

qpa[5][1]="1.SELECT FirstName From Person";

qpa[5][2]="2.SELECT Person.Firstname";

qpa[5][3]="3.EXTRACT FirstName From Person";

qpa[5][4]="4.EXTRACT Person.FirstName";

qca=new String[10][2];

//questionsandcorrectanswers//

qca[0][0]="What does SQL stand for?"; 

qca[0][1]="3.Structured Query Language";

qca[1][0]="Which SQL statement is used to extract sata from a database?";

qca[1][1]="4.SELECT";

qca[2][0]="Which SQL stateement is used to update data in a database?"; 

qca[2][1]="4.UPDATE";

qca[3][0]="Which SQL statement is used to insert new data in a database ?"; 

qca[3][1]="4.INSERT INTO";

qca[4][0]="Which SQL statementis used to delete data from database?";

qca[4][1]="1.DELETE";

qca[5][0]=" with SQL , how do you select a column named First Name from a table named Person?";

qca[5][1]="1.SELECT FirstName From Person";

}

}

public class ques

{

public static void main(String[]args)throws IOException

{

DataInputStream in=new DataInputStream(System.in);

int x,correct=0,wrong=0,i,j;

String ans[]=new String[10];

Questions q=new Questions(); 

System.out.println("SQL QUIZ"); 

System.out.println(" ");

//forlooptodisplayquestionandreadtheanswerfromtheuser//

for(i=0;i<6;i++)

{

for(j=0;j<5;j++)

{

System.out.println(q.qpa[i][j]);

}

System.out.println("youranswer:");

x=Integer.parseInt(in.readLine()); 

ans[i]=q.qpa[i][x];

}

//calculatecorrectanswers//

for(i=0;i<6;i++)

{

if(q.qca[i][1].equals(ans[i]))

correct++;

else

wrong++;

}

//printingthecorrectanswersanduserselectedanswers// 

System.out.println("CORRECT ANSWERS");

for(i=0;i<6;i++)

{

System.out.println(); 

System.out.println(q.qpa[i][0]); 

System.out.println("correctanswer:"+q.qca[i][1]); 

System.out.println("youranswer:"+ans[i]);

}

System.out.println("Correct="+correct+"\twrong="+wrong);

}

}

OUTPUT: 

SQL QUIZ 

 What does SQL stand for?

1.Structure Question Language

2.Strong Question Language

3.Structured Query Language

4.None of this

youranswer:

3

Which SQL statement is used to extract sata from a database?

1.GET

2.OPEN

3.EXTRACT

4.SELECT

youranswer:

4

Which SQL stateement is used to update data in a database?

1.SAVE

2.SAVE AS

3.MODIFY

4.UPDATE

youranswer:

4

Which SQL statement is used to insert new data in a database?

1.INSERT NEW

2.ADD NEW

3.ADD RECORD

4.INSERT INTO

youranswer:

4

Which SQL statementis used to delete data from database?

1.DELETE

2.COLLAPSE

3.REMOVE

4.CLEAR

youranswer:

1

 with SQL , how do you select a column named First Name from a table named Person?

1.SELECT FirstName From Person

2.SELECT Person.Firstname

3.EXTRACT FirstName From Person

4.EXTRACT Person.FirstName

youranswer:

1

CORRECT ANSWERS

What does SQL stand for?

correctanswer:3.Structured Query Language

youranswer:3.Structured Query Language

Which SQL statement is used to extract sata from a database?

correctanswer:4.SELECT

youranswer:4.SELECT

Which SQL stateement is used to update data in a database?

correctanswer:4.UPDATE

youranswer:4.UPDATE

Which SQL statement is used to insert new data in a database?

correctanswer:4.INSERT INTO

youranswer:4.INSERT INTO

Which SQL statementis used to delete data from database?

correctanswer:1.DELETE

youranswer:1.DELETE

 with SQL , how do you select a column named First Name from a table named Person?

correctanswer:1.SELECT FirstName From Person

youranswer:1.SELECT FirstName From Person

Correct=6 wrong=0