OLD CBSE Question Paper CLASS XII: INFORMATICS PRACTICES _2011

Informatics Practices 2011 CBSE

1. All questions are compulsory.2. Please give the explanation for the answer where applicable.3. To view the answer, click on the Answer link alongside the Question. Time Allotted:03:00:00 Maximum Marks:70 Question 1 : (a) Ms. Taufiq Ahmed wants to prevent unauthorized access to/from his company’s local area network. Write the name of a system (hardware/software), 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. 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? i) UPS ii) Modem iii) Repeater (c) Which of the following is not a feature of Networking?                                                            1) Resource sharing 2) Uninterrupted power supply 3) Reduced cost 4) Reliability (d) Name any two Indian scripts included in Unicode.             (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. (f) Identify the type of Topology from the following:               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. i) Trojan Horse ii) Worm                [1+1+1+1+2+2+2=10] (10 Marks) Question 2 : (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’. b) Write a statement to make jTextArea1 as an un-editable.   c) Which HTML tags are used for making a table and adding rows in a HTML document? d) How is < UL > tag different from < OL > tag of HTML? e) What will be the value of A and B after execution of the following code: 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. 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.         [1+1+1+1+2+2+2=10] (10 Marks) Question 3 : a) Write MySql command that will be used to open an already existing database “LIBRARY”. b)   The Mname Column of a table Members is given below:     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? d) Differentiate between Alternate Key and Candidate Key. e) Define data encapsulation with reference to Object Oriented Programming. f)A worker_Id 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.  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. SELECT * FROM Result WHERE Grade =”Null”; Help Sarthya to run the query by removing the error from the query and write the correct Query.  [1+2+2+1+1+1+2=10] (10 Marks) Question 4 : (a) What will be displayed into jTextField1 after executing the following code: int N=20; N=N+1; 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.  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: jTextArea1.setText(“LivenIn Peacet and harmony”); d) The following code has some error(s).Rewrite the code underlining all the corrections made: 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 the result of the following: 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;         int Total=0,Jump=5;                                                      int I; for(i=0,I=<5;i++) {               Jump+=5,               Total+=Jump; }           jTextArea1.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. Mr.Ram accepts payment through three types of credit cards. The offer is given according to the following scheme: Type of Card Offer Platinum 20% of amount Gold 15%  of amount Silver 10% of amount If the Bill amount is more than Rs. 25,000/- then the customer gets an additional offer of 5%. Write 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) button is clicked] To calculate net amount as [TotalCost(jTextField2)-offer(jTextField3)]–Additional offer(jTextField4)] To display the net amount in jTextField5. [2+2+1+2+1+2+1+2+2=15] (15 Marks) Question 5 : (a) What is the purpose of DROP TABLE command in MYSQL? How is it different from DELETE command?  (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? (c) Consider the table RESULT given below. Write commands in MySql for (i) to (iv) and output for (v) to (vii)  Table : Result No Name Stipend Subject Average Division 1 Sharon 400 English 38 THIRD 2 Amal 680 Mathematics 72 FIRST 3 Vedant 500 Accounts 67 FIRST 4 Shakeer 200 Informatics 55 SECOND 5 Anandha 400 History 85 FIRST 6 Upasna 550 Geography 45 THIRD (i)To list the names of those students, who have obtained Division as First in the ascending order of Name.         (ii)To display a report listing NAME, SUBJECT and Annual stipend received assuming that the stipend column has monthly stipend.  (iii)To count the number of students, who have either Accounts or Informatics as Subject. (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”;                      [2+1+1+1+1+1+1+1+1=10] (10 Marks) Question 6 :                                    [2+1+2+2+1+1=9] (9 Marks) Question 7 : a) What is the impact of e-learning sites on students learning process? b) Write two advantages of e-Business sites. c) Write three important features of e- Governance? Give URL of one of the commonly used e-Governance portal.    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: 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. [1+1+2+2 = 6] (6 Marks)