CBSE Academic XII STD Informatics Practices Sample Question Paper 2016 – 17 : cbseacademic.in

Name of the Board : CBSE Academic
Class : XII STD
Document Type : Sample Question Paper
Subject : Informatics Practices
Year : 2016 – 2017

Website : http://cbseacademic.in/SQP_CLASSXII_2016_17.html
Download Sample Question Paper : https://www.pdfquestion.in/uploads/10099-Informatics17.pdf

Informatics Practices Question Paper :

Time: 3 Hrs.
M.M.: 70

Related : CBSE Academic XII STD Human Rights & Gender Studies Sample Question Paper : www.pdfquestion.in/10095.html

1 (a) After realizing the issues with proprietary software, Ms. Sunita has decided to use only Open Source Software. Suggest any one suitable open source software to her, for each of the following categories:
i. Operating System
ii. Browser 1
(b) Expand the following
i. ODF
ii. PPP 1
(c) What is Domain Name Resolution? 1
(d) How a Phonetic text entry is different from Keymap based text entry? 1
(e) Which of the following activity can be termed as Eavesdropping

i. If Jack sets up an unauthorized parallel telephone line to capture the data. ii. If Jill has stolen his friend’s keyboard.
iii. If Martina installs some receiver hardware to capture the data while on its way.
iv. If Kim gets someone’s login information by casually watching what he/she is typing.

Select the best suitable option from the following
i. Option i only
ii. Option ii only
iii. Option i and ii both
iv. Option i and iii both

How Eavesdropping is different from snooping by mentioning any one activity which will be termed as snooping?

(f) It’s an era of networking! Almost everyone and everything is connected through one way or the other, hats off to the technology. We have never been so much linked as we are today.
Daniel has just started his hands on practice of networking. Help him in the following

I. He has just connected 10 computers of his resource room to establish a network. Name the network (LAN/MAN/PAN/WAN) which will be formed. Mention any two main benefits which Daniel could achieve by establishing a network.

II. Help him in identifying the correct topology which has following characteristics
Its very easy to diagnose the fault in this topology.
Failure of central hub/switch leads to failure of the entire network.
Depict the topology by drawing the diagram showing 4 interconnected computers through central hub/switch.

2 (a) Shalini is learning Java programming language, as it allows developers to write code that can run on any machine, regardless of architecture or platform. Help her in finding solutions of her problems:

I. She wants to compare two integer values for equality in her java code. Out of (=) and (= =), which operator she should use and why?
II. Help her in writing Java code to initialize two integer variables named num1 and num2 with values 5 and 10 respectively. Increase the value of num1 by 5 and decrease the value of num2 by 5.

(c) Realizing the importance of the Internet, Ms. Shikha a Mathematics teacher, has decided to use Internet as a medium to teach her students Mathematics in an interesting way.

3 (a) In today’s digitized world with a need to store data electronically, it is very important to store the data in the databases. SQL is used to interact with the Database Management System.
I. Classify the following commands according to their type (DDL/DML)
i. INSERT INTO
ii. ALTER TABLE

II. Which clause would you use with Select to achieve the following
i.To select the values that match with any value in a list of specified values.
ii.Used to display unrepeated values of a column from a table.

III. Chhavi has created a table named Orders, she has been asked to increase the value of a column named salesamount by 20. She has written the following query for the same.
Alter table Orders Add salesamount = salesamount+20; Is it the correct query?Justify.

(b) I. Name any one Single row function and any one Aggregate function. Also mention the difference in their working.
II. Explain why the following queries give different outputs on execution:
i. SELECT COUNT(ENAME) FROM EMP;
Output: 5

ii. SELECT Count(*) FROM EMP;
Output: 8

(c) Geetanjali had created a table “Customer” in the database “Test”. Immediately after the successful creation of the database, she wrote the Rollback command to undo the creation of the table. Did she execute rollback successfully? Explain. 2

4 (a) Ms. Meena is not able to understand the statement “Java is a case sensitive language”. Help her in understanding the above mentioned statement by giving suitable example. 1

(b) Ms. Rachel is designing a frame in Netbeans in which she has used four Radio Button controls. She want that only one radio button out of four should be selected at a time. Which property of the Radio Button should be selected to achieve the same?

(c) What will be displayed in jTextArea1 after the following code is executed:
int i;
for(i=10;i<50;i=i+30)
{
i=i+15;
jTextArea1.append(“”+i);
}
jTextArea1.append(“\n”+i);

(d) The following code has error(s). Rewrite the correct code underlining all the
corrections made :
value1=1, value2=2;
while(value1<value2)
jTextArea1.append (“\n”+value1*value2;
value1++
}

(e) Mr. Ashish works as a programmer in “Universal Technologies Pvt. Ltd.”. He has designed a Library software to generate the member ship fee depending upon the membership type considering discount eligibility as well. A screenshot of the same is shown below:

Help him in writing the code to do the following:
i. After selecting appropriate Radio Button, when ‘Check Fee’ button is clicked, fee should be displayed in the respective text field according to the following criteria:
Membership Type Fee
Monthly 500
Quarterly 1000
Yearly 1500

ii. After selecting appropriate Radio Button, when ‘Check Discount’ button is clicked, appropriate discount should be displayed in the respective text field according to the following criteria :
Discount Eligibility Discount
Students 200
Other 100

iii. When ‘Calculate’ button is clicked, Net Fee should be calculated and displayed in the respective text field as per the given formula: Net Fee = Fee – Discount

iv. When ‘Clear All’ button is clicked, All the text fields should be cleared