Sample Paper for Session Ending Examination 2016

KENDRIYA VIDYALAYA SANGATHAN,

SAMPLE PAPER FOR SESSION ENDING EXAMINATION 2016

Class XI INFORMATICS PRACTICES

Max. Time: 3 Hrs.Max. Marks: 70

Note:

(i) This question paper is divided into 3 sections:

(ii) Section A consists of 30 marks.

(iii) Section B and Section C are of 20 marks each.

(iv) Answer the questions after carefully reading the text.

SECTION-A
Q.1 / (a) / Define any two weaknesses of computer? / (1)
(b) / Define the different types of operating system. / (2)
(c) / How has e-governance benefited to the common man? Explain in brief. / (2)
(d) / Predict the output produced by following SQL queries after execution.
(i) SELECT INSTR(‘INDOOR OUTDOOR’,’OR’) FROM DUAL;
(ii) SELECT TRUNCATE(45.93,1) FROM DUAL; / (2)
(e) / What are types of Computers? Explain in brief. / (3)
Q.2 / (a) / Write the full form of VDU and LCD. / (1)
(b) / What are Cookies? / (1)
(c) / Differentiate between Interpreter and Compiler. / (2)
(d) / Consider the following table structure and write the SQL queries:
Table: Teacher
Field name / Field Type / Description
No / Int / Teacher No.
Name / Varchar / Teacher Name
Age / Int
Department / Varchar
DateofJoin / Date / Date of Joining of Teacher
Salary / Int / Per month
Sex / Char / ‘M’ or ‘F’
(i)To show all the information about the teachers of ‘history’ department.
(ii)To list teacher’s name with their date of joining in ascending order to name.
(iii) To display name,salary of Teachers who are earning more than 10000 per month. / (3)
(e) / Predict the output of the following SQL queries:
(i)SELECT ROUND(29.21), ROUND(32.76);
(ii)SELECT 9 mod 2;
(iii) SELECT CONCAT( "Catch", "a", "failing", "star" ); / (3)
Q.3 / (a) / Name any two e-Business portals of India. / (1)
(b) / What do you mean by e-Governance? / (1)
(c) / How is FOREIGN KEY command different from PRIMARY KEY command? / (2)
(d) / Consider the following tables EMPLOYEE and write the SQL query:
Eid / Name / Deptid / Qualifi
cation / Sex / Points / Basic / DA / HRA / Bonus
1 / Karan / 101 / MCA / F / 20 / 6000 / 2000 / 2300 / 200
2 / Rajat / 101 / BCA / M / 15 / 2000 / 300 / 300 / 30
3 / Hari / 102 / B.A. / M / 15 / 1000 / 300 / 300 / 40
4 / Harry / 102 / M.A. / M / 40 / 1500 / 390 / 490 / 30
5 / Sumit / 103 / B.Tech. / M / 32 / 8000 / 900 / 900 / 80
6 / Jyoti / 101 / M.Tech / F / 12 / 9000 / 300 / 490 / 89
(i)Display the Name, Deptid, Basic whose Bonus is greater than 50.
(ii) Display the records in descending order to their Names.
(iii) Add one more field “DateOfJoining” of type DATE into EMPLOYEE. / (3)
(e) / Consider the following form for input day, month and year.

Write code for “Date Calc” button to display the date(as shown in the form above)without using library function. / (3)
SECTION-B
Q.4 / (a) / What is JVM? / (1)
(b) / What output will the following code fragment produce? Explain.
int n = 20 ;
System.out.println( n +" , " + ++ n + " , " + n + " , " + n  ) ; / (2)
(c) / Rewrite the following code segment using switch – case without affecting its output.
if ( ch = = ‘N’ )
System . out . println ( “North” ) ;
if ( ch = = ‘E’ )
System . out . println ( “East” ) ;
if ( ch = = ‘W’ )
System . out . println ( “West” ) ;
else
System . out . println ( “South” ) ; / (2)
(d) / What are major events of Swing? Explain in brief with suitable example. / (5)
Q.5 / (a) / Write a SQL query to display 4 characters extracted from 3rd characteronwards from string
e.g. if string is ‘ABCDEFG’ then
Output should be: CDEF / (1)
(b) / Define the stages of program development process. / (2)
(c) / Differentiate between TextField and TextArea. / (2)
(d) / Find the error from the following code segment and rewrite the corrected code underlining the correction made.
int i
while ( i < = 10 )
{
if ( i % 2 == 0 )
System.out.println( i )
}
else
System.out.println ( i + 1);
} ;
i ++ ;
} / (2)
(e) / Rewrite following code using for loop without affecting its output. int num = -10;
while ( num < 55 )
{
System.out.println (num);
num ++ ;
} / (3)
SECTION-C
Q.6 / (a) / Name any two major websites of e-Learning. / (1)
(b) / Write SQL command to create the following table EMPLOYEE:
Column Name => / EmpID / EmpName / Salary / Dept
Data Type => / int / Varchar / int / Varchar
Length => / 5 / 20 / 6 / 10
Key Type => / Primary Key / Not Null
/ (2)
(c) / Predict the output for the following:
(i)SELECT INSTR(“WELCOME 2011”,”E”);
(ii)SELECT SUBSTR(“HOUSE,2,3); / (2)
(d) / What do you mean by Degree and Cardinality? / (2)
(e) / Write a program in JAVA to calculate and display “factorial” of a number. / (3)
Q.7 / (a) / Name any two popular DBMS software. / (1)
(b) / What is MySQL Server? / (1)
(c) / Explain the following SQL functions with suitable example.
(i)MOD()
(ii)CONCAT()
(iii)CURDATE() / (3)
(d) / Consider the following table EMPLOYEE and write the SQL queries:
EMPID / FIRSTNAME / LASTNAME / ADDRESS / CITY
100 / George / Smith / 83 First Street / Howard
105 / Mary / Jones / 842 Vine Ave. / Paris
152 / Sam / Tones / 33 Elm St. / Paris
215 / Sarah / Ackerman / 440 U.S. 110 / Upton
244 / Manila / Sengupta / 24 Friends Street / New Delhi
(i) To display Firstname, Lastname, Address and City of all employees living in city Paris.
(ii) To display the content of EMPLOYEES table in descending order to FIRSTNAME.
(iii)To insert a record with following data:
264, John, Clark, 29 Town road, New York
(iv)To change the city for empid 152 as “Durban”.
(v)To display FIRSTNAME whose empid is less than 200. / (5)

ANSWER KEY

SECTION-A
Q.1 / (a) / Define any two weaknesses of computer.
Ans: IQ Zero, Lack of Decision Making Power.
( ½ marks for each correct answer(any two) ) / (1)
(b) / Define the different types of operating system.
Ans: The operating systems are of mainly following types:
(i)Single Program OS: This is a single user operating system, so only one user program can supported and executed at a time.
(ii) Multi-program OS: It supports multiprogramming i.e. more than one user can be supported by it, therefore more than one user program are loaded and active at the same time.
(iii) Time Sharing OS: This OS uses time sharing technique. Each active user program is given a fair share time.
(iv) Real Time OS: In real time OS, the jobs have fixed deadlines and the jobs have to be completed within their deadlines.
( ½ marks for each correct answer(any four)) / (2)
(c) / How has e-governance benefited to the common man? Explain in brief.
Ans: The E-governance have helped citizens in the following ways:

• The number of trips to government offices reduced.
• Waiting time reduced
• Bribes reduced
• All the factor are reduced so the cost of the availing the service is reduced.

( ½ marks for each correct answer) / (2)
(d) / Predict the output produced by following SQL queries after execution.
(i) SELECT INSTR(‘INDOOR OUTDOOR’,’OR’) FROM DUAL;
Ans: 5 ( 1 mark)
(ii) SELECT TRUNCATE(45.93,1) FROM DUAL;
Ans: 45.9
( 1 mark) / (2)
(e) / What are types of Computers? Explain in brief.
Ans: The computer have been classified into three categories:
(i)Digital Computers: The digital computer works upon discontinuous data. They convert the data into digits (0 and 1) and all operations are carried out on these digits at extremely fast rate. Digital computer used for business and scientific applications. The digital computer can further be classified in two ways :
(a) Purpose wise (b) Size and performance wise.
( 1 mark)
(ii) Analog Computers: Computer in which continuously variable physical quantities, such as electrical potential, fluid pressure, or mechanical motion, are used to represent (analogously) the quantities in the problem to be solved. The analog system is set up according to initial conditions and then allowed to change freely. Analog computers are especially well suited to simulating dynamic systems; such simulations may be conducted in real time or at greatly accelerated rates, allowing experimentation by performing many runs with different variables. ( 1 mark)
(iii) Hybrid Computers:computers that exhibit features of analog computers and digitalcomputers. In these computers some calculation take place in analog manner and rest of them take place in digital manner. The digital component normally serves as the controller and provides logical operations, while the analog component normally serves as a solver of differential equations.
( 1 mark) / (3)
Q.2 / (a) / Write the full form of VDU and LCD.
Ans: Video Display Unit,
liquid crystal display
( ½ marks for each correct answer) / (1)
(b) / What are Cookies?
Ans: Acookie, also known as aweb cookie,browser cookie, andHTTP cookie, is a piece oftext stored on auser's computer by theirweb browser.
(1 mark for correct answer, ½ marks for partially correct answer.) / (1)
(c) / Differentiate between Interpreter and Compiler.
Compiler / Interpreter
Executes the whole program in one go / Executer the program line by line.
It execute the program only when the whole program is error free / It executes the program even if there is an error at later in program.
Compiler does not remains in the memory all the time. / Remains in the memory until whole program is not completed.
e.g. C++ / e.g.Visual Basic
( ½ marks for each correct difference) / (2)
(d) / Consider the following table structure and write the SQL queries:
Table: Teacher
Field name / Field Type / Description
No / Int / Teacher No.
Name / Varchar / Teacher Name
Age / Int
Department / Varchar
DateofJoin / Date / Date of Joining of Teacher
Salary / Int / Per month
Sex / Char / ‘M’ or ‘F’
(i)To show all the information about the teachers of ‘history’ department.
Ans: SELECT * FROM TEACHER WHERE DEPARTMENT= “history”; ( 1 mark)
(ii)To list teacher’s name with their date of joining in ascending order to name.
Ans: SELECT NAME,DATEOFJOIN FROM TEACHER ORDER BY NAME;
( 1 mark)
(iii) To display name, salary of Teachers who are earning more than 10000 per month.
Ans: SELECT NAME,SALARY FROM TEACHER WHERE SALARY>10000;
( 1 mark) / (3)
(e) / Predict the output of the following SQL queries:
(i)SELECT ROUND(29.21), ROUND(32.76);
Ans: 29 33
(ii)SELECT 9 mod 2;
Ans: 1
(iii) SELECT CONCAT( "Catch", "a", "failing", "star" );
Ans: Catchafailingstar
(1 mark for each correct answer) / (3)
Q.3 / (a) / Name any two e-Business portals of India.
Ans: , OR any other correct answer
( ½ mark for each correct answer(any two)) / (1)
(b) / What do you mean by e-Governance?
Ans: e-Government (short for electronic government, also known as e-gov, digital government online government or transformational government) is a diffused neologism used to refer to the use of information and communication technology to provide and improve government services, transactions and interactions with citizens, businesses, and other arms of government.
(1 mark for correct answer ½ mark for partially correct answer) / (1)
(c) / How is FOREIGN KEY command different from PRIMARY KEY command?
Ans: A primary key is an attribute (or combination of attributes) that uniquely identifies each row in a relation. The primary key of an entity set allows us to distinguish among the various entities of the set.
A foreign key is an attribute in a relation of database that serves as the primary key of another relation in the same database.
FOREIGN KEY command is used to make column as foreign key and also PRIMARY KEY command is used to make a field as primary key. These commands are used while creating the table.
(2 mark for correct answer 1 mark for partially correct answer) / (2)
(d) / Consider the following tables EMPLOYEE and write the SQL query:
Eid / Name / Deptid / Qualifi
cation / Sex / Points / Basic / DA / HRA / Bonus
1 / Karan / 101 / MCA / F / 20 / 6000 / 2000 / 2300 / 200
2 / Rajat / 101 / BCA / M / 15 / 2000 / 300 / 300 / 30
3 / Hari / 102 / B.A. / M / 15 / 1000 / 300 / 300 / 40
4 / Harry / 102 / M.A. / M / 40 / 1500 / 390 / 490 / 30
5 / Sumit / 103 / B.Tech. / M / 32 / 8000 / 900 / 900 / 80
6 / Jyoti / 101 / M.Tech / F / 12 / 9000 / 300 / 490 / 89
(i)Display the Name, Deptid, Basic whose Bonus is greater than 50.
Ans: SELECT Name, Deptid, Basic FROM EMPLOYEE WHERE Bonus >50;
(1 mark)
(ii) Display the records in descending order to their Names.
Ans: SELECT * FROM EMPLOYEE ORDER BY Name DESC;
(1 mark)
(iii) Add one more field “DateOfJoining” of type DATE into EMPLOYEE.
Ans: ALTER TABLE EMPLOYEE ADD (DateOfJoining DATE);
(1 mark) / (3)
(e) / Consider the following form for input day, month and year.

Write code for “Date Calc” button to display the date (as shown in the form above) without using library function.
Ans:
int d= Integer.parseInt(DayTextField.getText());
int m= Integer.parseInt(MonthTextField.getText());
int y= Integer.parseInt(YearTextField.getText());
switch(m)
{
case 1:
DisplayLabel.setText(d+"-"+"Jan"+"-"+y);
break;
case 2:
DisplayLabel.setText(d+"-"+"Feb"+"-"+y);
break;
case 3:
DisplayLabel.setText(d+"-"+"Mar"+"-"+y);
break;
case 4:
DisplayLabel.setText(d+"-"+"Apr"+"-"+y);
break;
case 5:
DisplayLabel.setText(d+"-"+"May"+"-"+y);
break;
case 6:
DisplayLabel.setText(d+"-"+"Jun"+"-"+y);
break;
case 7:
DisplayLabel.setText(d+"-"+"Jul"+"-"+y);
break;
case 8:
DisplayLabel.setText(d+"-"+"Aug"+"-"+y);
break;
case 9:
DisplayLabel.setText(d+"-"+"Sep"+"-"+y);
break;
case 10:
DisplayLabel.setText(d+"-"+"Oct"+"-"+y);
break;
case 11:
DisplayLabel.setText(d+"-"+"Nov"+"-"+y);
break;
case 12:
DisplayLabel.setText(d+"-"+"Dec"+"-"+y);
break;
default:
DisplayLabel.setText("You enter wrong month");
}
(1 mark for correct reading method from text boxes, 1 mark for correct switch case definition and 1 marks for correct display method in label.) / (3)
SECTION-B
Q.4 / (a) / What is JVM?
Ans: JVM stand for Java Virtual Machine. An abstract computing machine, or virtual machine, JVM is a platform-independent execution environment that converts Java byte code into machine language and executes it.
(1 mark for correct answer, ½ mark for partially correct answer) / (1)
(b) / What output will the following code fragment produce? Explain.
int n = 20 ;
System.out.println( n + " , " + ++ n + " , " + n + " , " + n  ) ;
Ans: 20,21,21,21
( ½ marks for each correct answer) / (2)
(c) / Rewrite the following code segment using switch – case without affecting its output.
if ( ch = = ‘N’ )
System . out . println ( “North” ) ;
if ( ch = = ‘E’ )
System . out . println ( “East” ) ;
if ( ch = = ‘W’ )
System . out . println ( “West” ) ;
else
System . out . println ( “South” ) ;
Ans:
switch(ch)
{
case ‘N’:
System.out.println ( “North” ) ;
break;
case ‘E’:
System.out.println ( “East” ) ;
break;
case ‘W’:
System.out.println ( “West” ) ;
break;
default:
System.out.println ( “South” ) ;
break;
}
( ½ mark for defining switch statement and 1½ mark for defining case statements) / (2)
(d) / What are major events of Swing? Explain in brief with suitable example.
Ans : Swing has the following types of commonly handled events:

1. Action Events : definition with components
2. Focus Events : definition with components
3. Item Events : definition with components
4. Key Events : definition with components
5. Mouse Events: definition with components
6. Mouse Motion Events: definition with components
7. Window Events: definition with components

( ½ mark for each events name definition(any five ) and ½ mark for components name(any five) / (5)
Q.5 / (a) / Write a SQL query to display 4 characters extracted from 3rd character onwards from string
e.g. if string is ‘ABCDEFG’ then
Output should be: CDEF
Ans: SELECT SUBSTR(‘ABCDEFG’, 3, 4) FROM DUAL;
(1 mark for correct answer ½ mark for partially correct answer) / (1)
(b) / Define the stages of program development process.
Ans: (i) Crack the problem: The problem is cracked and an algorithm is formulated.
(ii) Code the algorithm: The algorithm is translated into a program using some programming language.
(iii) Compile the program: After the program coding next step is compile the program and convert into object program. And find the error.
(iv) Execute the program: After compilation of error free program the program is executed.
( ½ marks for each correct step) / (2)
(c) / Differentiate between TextField and TextArea.
Ans: Text field: one-line field, like the Subject line of a comment form.
Text area: multi-line field, like the body of a comment form.
(1 mark for each correct answer, ½ mark for partially correct answer) / (2)
(d) / Find the error from the following code segment and rewrite the corrected code underlining the correction made.
int i
while ( i < = 10 )
{
if ( i % 2 == 0 )
System.out.println( i )
}
else
System.out.println ( i + 1);
} ;
i ++ ;
}
Ans:
int i=1;
while ( i < = 10 )
{
if ( i % 2 == 0 )
System.out.println( i );
else
System.out.println ( i + 1);
i ++ ;
}
(½ marks for each correct answer) / (2)
(e) / Rewrite following code using for loop without affecting its output. int num = -10;
while ( num < 55 )
{ System.out.println (num);
num ++ ; }
Ans:
for(int num=-10; num<55; num++)
System.out.println (num);
(1 mark for correct initialization, 1 mark for correct definition of for loop and 1 mark for correct output statement) / (3)
SECTION-C
Q.6 / (a) / Name any two major websites of e-Learning.
Ans: , ,
( ½ mark for each correct answer(any two) OR any other correct answer) / (1)
(b) / Write SQL command to create the following table EMPLOYEE:
Column Name => / EmpID / EmpName / Salary / Dept
Data Type => / int / Varchar / int / Varchar
Length => / 5 / 20 / 6 / 10
Key Type => / Primary Key / Not Null
Ans: create table EMPLOYEE(
EmpID int(5) Primary Key,
EmpNameVarchar(20) NOT NULL,
Salaryint(6),
Dept Varchar(10));
(2 marks for correct answer,1 mark for partially correct answer) / (2)
(c) / Predict the output for the following:
(i)SELECT INSTR(“WELCOME 2011”,”E”);
Ans: 2 ( 1 mark)
(ii)SELECT SUBSTR(“HOUSE,2,3);
Ans: OUS ( 1 mark)
(No mark for partially correct answer) / (2)
(d) / What do you mean by Degree and Cardinality?
Ans: Degree of a table is total number of attributes. Cardinality of a table is total number of rows.
( 1 mark for each correct answer) / (2)
(e) / Write a program in JAVA to calculate and display “Factorial” of a number.
Ans:
public class fact { public static void main(String[] args) {
int f = 1,n=5,i;
for(i=1;i<=n;i++){
f = f * i ; }
System.out.println("factorial of " + n + ”is =” + f );
} }
(3 marks for any equivalent correct answer)
(1½ mark for correct loop only)
( ½ marks for class definition and main() definition without loop) / (3)
Q.7 / (a) / Name any two popular DBMS software.
Ans: MySQL, Sysbase, Microsoft SQL Server, INGRES, Oracle etc.
( ½ mark for each correct answer(any two) OR any other correct answer) / (1)
(b) / What is MySQL Server?
Ans: MySQL server listens for client requests coming in over the network and accesses database content according to those requests and provides that to the clients.
(1 marks for correct answer, ½ mark for partially correct answer) / (1)
(c) / Explain the following SQL functions with suitable example.
(iv)MOD(): returns the modules.
e.g. select mod(10,3) output will be 1 ( 1 mark)
(v)CONCAT():used to merge strings.
e.g. select concat("today","is","sunday"); out will be todayissunday
( 1 mark)
(vi) CURDATE(): returns the current system date.
e.g. select curdate(); output will be 2011-02-08 <………(the system date)
( 1 mark) / (3)
(d) / Consider the following table EMPLOYEE and write the SQL queries:
EMPID / FIRSTNAME / LASTNAME / ADDRESS / CITY
100 / George / Smith / 83 First Street / Howard
105 / Mary / Jones / 842 Vine Ave. / Paris
152 / Sam / Tones / 33 Elm St. / Paris
215 / Sarah / Ackerman / 440 U.S. 110 / Upton
244 / Manila / Sengupta / 24 Friends Street / New Delhi
(i)To display Firstname, Lastname, Address and City of all employees living in city Paris.
Ans: SELECT FIRSTNAME, LASTNAME, ADDRESS,CITY FROM EMPLOYEES WHERE CITY= “Paris”; ( 1 mark)
(ii)To display the content of EMPLOYEES table in descending order to FIRSTNAME.
Ans: SELECT * FROM EMPLOYEES OREDR BY FIRSTNAME DESC;
( 1 mark)
(iii) To insert a record with following data:
264, John, Clark, 29 Town road, New York
Ans: INSERT INTO EMPLOYEE(264, ‘John’, ‘Clark’, ‘29 Town road’, ‘New York’); ( 1 mark)
(iv)To change the city for empid 152 as “Durban”.
Ans: UPDATE EMPLOYEE SET CITY= “Durbon” WHERE EMPID=152.
( 1 mark)
(v)To display FIRSTNAME whose empid is less than 200.
Ans: SELECT FIRSTNAME FROM EMPLOYEE WHERE EMPID<200.
( 1 mark ) / (5)

XI-IP QP SEE2016Page 1 of 14