Kendriya Vidyalaya, Karnal

KENDRIYA VIDYALAYA SANGATHAN, JAIPUR REGION

SESSION ENDING EXAM 2017

INFORMATICS PRACTICESCLASS – XI

M.MARKS:70TIME : 3 hr.

Answer the following questions:

Q1.Answer the following questions based on computer systems–

a)Name the super computers developed in India.1

b)Expand (i) MICR (ii) LCD1

c)What is the difference between virus and worm?1

d)How is a compiler different from interpreter?2

e)Name the various categories of software.1

f)Write two uses of utility softwares.1

g)Differentiate data and information with example?1

h)What is hardware & software? Give one example of each.2

Q2.Answer these questions based on Java programming –

a)Which of the following are valid identifiers ? Give reason(s).1

(i) _rec(ii)switch

b)What do you understand by a message and an event ?1

c)What is the JVM?1

d)Will the value of Y be the same for the two cases given below ?

(i) A = ++B;(ii) A = B++; (given the value of B is 50)2

e)Is there any difference between ‘=’ and ‘= =’ ? Explain with example2

f)How is a keyword different from and identifier?2

Q3.Answer the following questions –

a)What are the steps to solve a problem ?2

b)What is the output of the following code fragment ?2

int f = 1, i = 1;

while (i < 5)

f *= i;

System.out.println(f);

c)Re-write the following code using conditional operator ( “?” ) or ternary operator without changing the output- 2

if ( a>b)

big=a;

else

big=b;;

d)What is wrong with the following code ? Give Reason(s).2

switch(x)

{

case 1:

N1=10;

N2=20;

case 2:

N3=30;

break;

N4=40;

}

e)What is the difference between compile time error and run-time error?2

Q4.Answer the following –

a)Write the code for creating a method to calculate power of a number without using library method. (The method takes two parameters, base and exponent) 2

b)Write the code for calculating final Grade(as per table given below) of a cricketer. The runs scored by a cricketer are to be entered in the text box & upon clicking at the button, grade should be displayed in the label. 4

Q5.Answer these questions on DBMS –

a)Illustrate tuple and domain using example.2

b)What is the significance of Primary Key in a Database? Can a table exist without Primary Key? 2

c)Define these : (i) TCL(ii) DML Commands2

Q6.Answer the following questions based on the following database–

Table : Subscriber

a)Write the SQL commands for the following for the table given above:(1 x 6 = 6)

i)List the table in ascending order of first name.

ii)Display the names of the subscribers who are paying bill less than $ 400.

iii)Display the complete details of S_code 147.

iv)Print the table structure.

v)Suggest the attribute(s) to compose the primary key of this table.

vi)What is the degree and cardinality of this table?

b)Write the output of the following SQL commands on table Subscriber (1 X 2 = 2)

i)SELECT * FROM SUBSCRIBER WHERE FNAME LIKE “M%” ;

ii)SELECT BILL_AMT, PHONE , FNAME FROM SUBSCRIBER WHERE S_CODE IN(102,189,308);

c)Create a table Department as per following details3

d.)How can you open an existing database in MySQL ?1

e.)What will be the output of this SQL statements – ( 1 x 7 = 7 )

i)SELECT curdate() ;

ii)SELECT 22 / 7 AS PI ;

iii)SELECT TRUNCATE(15.79,0);

iv)SELECT ROUND(15.79,1);

v)SELECT SQRT(4);

vi)SELECT UCASE(‘India’);

vii)SELECT 4*5 from dual;

f.)What is the difference between char and varchar datatypes.2

g.)Explain the usage of NULL and DISTINCT using example.2

h.)Differentiate between DROP and ALTER command.2

Q7.Attempt the following questions –

---xxx---

KENDRIYA VIDYALAYA SANGATHAN, JAIPUR REGION

SESSION ENDING EXAM 2017

INFORMATICS PRACTICES

CLASS – XI

MARKING SCHEME