CBSE Question Paper 2011 class 12 Informatics Practices

myCBSEguide App

myCBSEguide App

Complete Guide for CBSE Students

NCERT Solutions, NCERT Exemplars, Revison Notes, Free Videos, CBSE Papers, MCQ Tests & more.

Download Now

 

CBSE Question Paper 2011 class 12 Informatics Practices conducted by Central Board of Secondary Education, New Delhi in the month of March 2011. CBSE previous year question papers with solution are available in myCBSEguide mobile app and cbse guide website. The Best CBSE App for students and teachers is myCBSEguide which provides complete study material and practice papers to cbse schools in India and abroad.

CBSE Question Paper 2011 class 12 Informatics Practices

Download as PDF

CBSE Question Paper 2011 class 12 Informatics Practices

General Instruction:

  • This question paper contains 7 Questions.
  • Answer the questions after carefully reading the text.

Q1 Answer the questions after carefully reading the text. (1)
(a) Ms. Taufiq Ahmed wants to prevent unauthorized access to/from his company’s
local area network. Write the name of a system (software/ hardware), which
he should install to do the same

(b) Beauty Lines Fashion Inc. is a fashion company with design unit and market unit 135 meters away from each other. The company recently connected their LANs using Ethernet cable to share the stock related information. But after joining their LANs, they are not able to share the information due to loss of signal in between. Which device out of the following. should you suggest to be installed for a smooth communication? (1)
(i) UPS
(ii) Modem
(iii) Repeater
Ans: Repeater

(d) Name any two Indian scripts included in Unicode. (1)

(e) Mr. Jayanto Das is confused between Shareware and Open source software Mention at least two points of differences to help her understand the same. (2)
(f) Identify the type of Topology from the following: (2)
(i) If each node is connected with the help of independent cable with the help of a central switching (communication controller)
(ii) If each node is connected with the help of a single coaxial cable.

(g) Define the following with reference to Threats to Network Security. (2)
(i) Trojan Horse
(ii) Worm

Q2 (a) While working in Netbeans, Ms. Kanta Surbhi wants to display ‘Cleared’ or
‘Re-attempt required’ message depending the marks entered in jTextField.
Help her to choose more appropriate statement out of ‘If statement’ and ‘Switch
statement’. (1)

(b) Write a statement to make jTextArea1 as un-editable. (1)

(c) Which HTML tags are used for making a table and adding rows in a HTML document? 1

(d) How is <UL> tag different from <OL> tag of HTML? (1)

(e) What will be the value of A and B after execution of the following code: (2)
int A = 100, B ;
for (B=10; B<=12; B++)
{
A+=B;
}
JOptionPane. showMessageDialog (this, “A:”+A+” B:”+B+”) ;

(f) Differentiate between HTML and XML. 2
(g) Write Java code that takes the price of a pencil from jTextField1 and quantity of pencils from jTextField2 and calculates total amount as price * quantity to be displayed in jTextField3 and also find 10% tax amount to be displayed in jTextField4. (2)

Q3 (a) Write MySql command will be used to open an already existing database
“LIBRARY”. (1)

(b) The Mname Column of a table Members is given below: (2)

Mname
Aakash
Hirav
Vinayak
Sheetal
Rajeev

Based on the information, find the output of the following queries:
(i) Select Mname from members where mname like “%v”;
(ii) Select Mname from members where mname like “%e%”;

(c) A table “TRAINS” in a database has degree 3 and cardinality 8. What is the number of rows and columns in it? (2)

(d) Differentiate between Alternate key and Candidate key. (1)

(e) Define data encapsulation with reference to Object Oriented Programming. (1)

(f) A worke_ld consisting of 4 digits is stored in a string variable strWrkld. Now
Mr. Jai wants to store this Id in integer type of variable IntWrkld Write a Java
statement to do this. (1)

(g) Sarthya, a student of class XI, created a table “RESULT”. Grade is one of the column of this table. To find the details of students whose Grades have not been entered, he wrote the following MySql query. which did not give the desired result. (2)
SELECT*FROM Result WHERE Grade = “Null”;
Help Sarthya to run the query by removing the errors from the query and
write the correct Query.

Q4 (a) What will be displayed in jTextField1 after executing the following code. (2)
int N = 20;
N = N + l ;
If (N<21)
jTextField1.setText(Integer.toString(N+10));
else
jTextField1.setText(Integer.toString(N+15));
(b) Rewrite the following program code using a Switch statement. (2)

if (code ==1)
Day = “Monday” ;
else if (code == 2)
Day = “Tuesday” ;
else if ( code ==3)
Day = “Wednesday” ;
else if ( code == 4)
Day = “Thursday” ,
else
Day = “No Match” ;

(c) What will be displayed In jTextArea1 after executing the following statement: (1)
jTextAreal.setText(“Live\nIn Peace\t and harmony”);

(d) The following code has some error(s). Rewrite the correct code underlining all the corrections made: (2)
Int P=3; sum = 0; //Declaring P and sum as Integer
{
Sum = P;
P += 3;
}
while (P=<12)
jTextField1 (Integer.tostring(sum)) ;

(e) Given a string object namely ‘VALUE’, having value as “324” stored in it.
What will be result of the following: (1)

JOptionPane.showMessageDialog(null,””+(Value.length()+
Integer.parseInt(value)));
(f) The following code has some error(s). Rewrite the correct code underlining all the corrections made: (2)
int Total = 0, Jump = 5;
int I;
for (i = 0, I =<5, i ++)
{
Jump+ =5,
Total +=Jump;
}
jTextAreal.showText (” ” + Total) ;

(g) Mr. Ram Kishore, the owner of the Kiddi Land Enterprises has asked his programmer Saumya to develop the following GUI in Netbeans.
CBSE Question Paper 2011 class 12 Informatics Practices

Mr. Ram accepts payment through three types of credit cards. The offer is given according to the following scheme:

Type of Card Offer
Platinum20% of amount
Gold15% of amount
Silver10% of amount

If the Bill amount is more than Rs.25,000/- then the customer gets an additional
offer of 5% Write the Java code for the following :
(a) To assign Additional offer as 0(jTextField4) and Net amount as 0 (jTextField5). Also set them as un-editable.

(b) [when “Calculate Offer”(JButton1) is clicked] To calculate discount as per the given criteria and display the same in
jTextField3 To assign Additional offer (jTextField4) as 5% of
amount(jTextField2) as per the above condition.
To enable “Calculate Net Amount”(jButton2) button

(c) [When “Calculate Net Amount” (jButton2) is clicked] To calculate net amount as [TotalCost(jTextField2)]-offer(jTextField3)
-Additional offer (jT extField4)] To display the net amount in jTextField5

Q5 (a) What is the purpose of DROP TABLE command in MySql? How is it different from DELETE command? (2)
(b) Table Employee has 4 records and Table Dept has 3 records in it. Mr. Jain wants to display all information stored in both of these related tables. He forgot to specify equi-join condition in the query. How many rows will get displayed on execution of this query? (1)

(c) Consider the table RESULT given below Write commands in MySql for (i) to (iv) and output for (v) to (vii)
Table Result

NoNameStipendSubjectAverageDivision
1Sharon400English38THIRD
2Amal680Mathematics72FIRST
3Vedant500Accounts67FIRST
4Shakeer200Informatics55SECOND
5Anandha400History85FIRST
6Upasna550Geography45THIRD

(i) To list the names of those students, who have obtained Division as FIRST in the ascending order of NAME. (1)

(ii) To display a report listing NAME, SUBJECT and Annual stipend received
assuming that the stipend column has monthly stipend. (1)

(iii) To count the number of students, who have either Accounts or Informatics as Subject. (1)
(iv) To insert a new row in the table EXAM:

6, “Mohan”, 500, “English”, 73, “Second”
(v) SELECT AVG (Stipend) FROM EXAM WHERE DIVISION = “THIRD” ;

(vi) SELECT COUNT(DISTINCT Subject) FROM EXAM;
(vii) SELECT MIN(Average) FROM EXAM WHERE Subject = “English”;

Q6 a) Write a MySQL command for creating a table “PAYMENT” whose structure is given below: (2)
Table: PAYMENT

Field Name Datatype Size Constraint
Loan_numberInteger4Primary key
Payment_numberVarchar3
Payment_dateDate
Payment_amountInteger8Not Null

b) In a database, there are two tables “Product” and “Client” as shown below: (2)
Table: PRODUCT

P_ID ProductName Manufacture Price
P001MoisturiserXYZ40
P002SanitizerLAC35
P003Bath SoapCOP25
P004ShampooTAP95
P005Lens SolutionCOP350

Table: Client

C_ID ClientName City P_ID
01Dreamz DisneyNew DelhiP002
05Life Line IncMumbaiP005
1298.4New DelhiP001
15AppoloBangloreP003

Write the commands in SQL queries for the following:

(i) To display the details of Product whose Price is in the range of 40 and 120 (Both values included)

(ii) To display the ClientName, City from table Client and ProductName and Price from table Product, with their corresponding matching P_ID

(iii) To increase the Price of all the Products by 20.

(c) In a Database School there are two tables Member and Division as show below.
Table: Member

Empld Name Pay Divno
1001Shankhya3400010
1003Ridhima3200050
1002Sunish4500020

Table: Division

Divno Divname Location
10MediaTF02
20DanceFF02
30ProductionSF01

(i) Identify the foreign key in the table Member. (1)

(ii) What output, you will get, when an equal-join query is executed to get the
Name from Member Table and corresponding from Division table?

NameDivname
ShankhyaMedia
SunishDance

OR

NameLocation
SankhyaTF02
SunishFF02

OR

NameDivnameLocation
SankhyaMediaTF02
SunishDanceFF02

(1 mark for providing any of the above outputs)

OR

(1 Mark for providing any output from the tables mentioned above

OR

(writing that the corresponding join column not available)

OR

(1 mark if Q6(i) is correct)

Q7 a) What is the impact of e-Learning sites on students learning process? (1)

b) Write two advantages of e-Business sites. (1)

c) Write three important features of e-Governance? Give URL of one of the commonly used e-Governance portal. (2)

d) Jaina is creating a form for her practical file. Help her to choose most appropriate controls from List Box, Combo Box, TextField, TextArea, Radio Button, Check box, Label and Command button for the following entries from user. (2)
(i) A message “Enter Name” in front of a Text Field.

(ii) An input to choose more than one subjects from a set of given choices.

(iii) An input for entering comments of user.

(iv) An input for accepting the residential area out of Rural and Urban as options.

These are questions only. To view and download complete question paper with solution install myCBSEguide App from google play store or log in to our student dashboard.

Download myCBSEguide App

CBSE Question Paper 2011 class 12 Informatics Practices

Download class 12 Informatics Practices question paper with solution from best CBSE App the myCBSEguide. CBSE class 12 Informatics Practices question paper 2011 in PDF format with solution will help you to understand the latest question paper pattern and marking scheme of the CBSE board examination. You will get to know the difficulty level of the question paper.

Previous Year Question Paper for class 12 in PDF

CBSE question papers 2018, 2017, 2016, 2015, 2014, 2013, 2012, 2011, 2010, 2009, 2008, 2007, 2006, 2005 and so on for all the subjects are available under this download link. Practicing real question paper certainly helps students to get confidence and improve performance in weak areas.

To download CBSE Question Paper class 12 Accountancy, Chemistry, Physics, History, Political Science, Economics, Geography, Computer Science, Home Science, Accountancy, Business Studies and Home Science; do check myCBSEguide app or website. myCBSEguide provides sample papers with solution, test papers for chapter-wise practice, NCERT solutions, NCERT Exemplar solutions, quick revision notes for ready reference, CBSE guess papers and CBSE important question papers. Sample Paper all are made available through the best app for CBSE students and myCBSEguide website.




Test Generator

Test Generator

Create Papers with your Name & Logo

Try it Now (Free)

Leave a Comment