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
S_code / Phone / Fname / Lname / Bill_amt102 / 2649674 / John / Miller / 685.70
118 / 2650477 / Billy / Smith / 540.50
147 / 2984834 / Matthew / Scott / 320.75
206 / 2804051 / Rita / Granger / 405.50
249 / 2631589 / Momin / Mita / 270.50
308 / 2640922 / Catherine / Jones / 428.25
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
Column NameDeptNo / DeptName
Datatype / Number / Varchar
Length / 2 / 20
Constraints / Primary key
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
Q 1 a) / PARAM, PACE / 1Q 1 (b) / Magnetic ink Character Reader
Liquid crystal Display / ½ Mark for each
Q 1(c) / One point of difference / 1
Q 1(d) / Full marks for Difference between both / 2
Q 1 (e) / System Software (O.S and Language Processor)
Application Software / 1
Q 1 (f) / Any two utilities / 1
Q 1 (g) / Full marks for Difference between both / 1
Q 1 (h) / Definition and example of each / 2
Q 2 (a) / (i)Correct
(ii)Incorrect (it’s a keyword) / ½ Mark for each
Q 2 (b) / Explanation of message and event using example
Or
Definition of message and event / 1 Mark
Q 2 (c) / Definition of JVM / 1 Mark for each
Q 2 (d) / No (i) A=51, (ii) A=50 / 1 Mark for each
Q 2 (e) / Any two points of difference and example / 2 Marks
Q 2 (f) / Any two points of difference / 2 Marks
Q 3 (a) / Steps to solve a problem / 2 Marks
Q 3 (b) / Output is 12 / 2 Marks
Q 3 (c) / Big=a>b? a:b; / 2 Marks
Q 3(d) / N4=40 is unreachable statement / 2 Marks
Q 3(e) / Any two differences and / or examples / 2 Marks
Q 4 (a) / double power(double base, double expo)
{
for (int i=1 ; i<=expo ; i++)
{
base*=base;
}
return(base);
} / 2 Marks
Q 4 (b) / Conversion of text to integer
Correct use of else if
Use of setText() to show the output / 1 Mark +
2 Mark +
1 Mark
Q 5 (a) / Definition and Example using Table / 1 Mark for each
Q 5 (b) / Significance of Primary Key
Yes , but it will be a stand alone table without any relation with other tables in database / 1 Mark +
1 Mark
Q 5 (c) / Definition of TCL and DML commands / 1 Mark for each
Q 6(a) / (i)SELECT * FROM SUBSCRIBER ORDER BY FNAME;
(ii)SELECT FNAME+LNAME FROM SUBSCRIBER WHERE BILL_AMT<400;
(iii)SELECT * FROM SUBSCRIBER WHERE S_CODE=147;
(iv)DESC SUBSCRIBER;
(v)S_CODE OR PHONE
(vi)DEGREE=5 AND CARDINALITY = 6 / 1 Mark for each correct query
Q 6 (b) / S_code / Phone / Fname / Lname / Bill_amt
147 / 2984834 / Matthew / Scott / 320.75
249 / 2631589 / Momin / Mita / 270.50
(i)
(ii)
Bill_amt / Phone / Fname
685.70 / 2649674 / John
428.25 / 2640922 / Catherine
/ 1 mark for each correct output
Q 6 (c) / Create table with full description / 3 Marks
Q 6 (d) / use < database name>; / 1 Mark
Q 6 (e) / (i)Current date in yyyy-mm-dd format
(ii)PI
------
3.1429
(iii)15
(iv) 15.8
(v) 16
(vi) INDIA
(vii)20 / 1 Mark +
1 Mark
Q 7 (f) / Any two points of difference / 2 Marks
Q 7 (g) / Usage of the keywords NULL and DISTINCT using examples / 1 Mark for each
Q 7 (h) / Difference between drop and alter / 2 Marks