INFORMATICS PRACTICES 065(XI) HALF YEARLY EXAMINATION SET-A TIME 03 HOURS MM 70 No te : 1) This question paper having 7 questions. 2) All questions are compulsory. Q1 Define any three terms (a)System Software (b) Any one out put device (c) Primary Memory (d) Printer (e) Anti Virus Write a program for the series. 1,4,9,16,25,36…….100 Write a program for the series. 0,2,4,6,8,10,12,14,16,18,20 10 (c) What will be the value of variable ‘k’ after execution of the program int k=9,i=1; for(i=1;i<=5;i++) {i++; k=k+10;} 3 (d) P=12,d=7 K =++P+d++; after execution k will be 2 Q2(a) (b) Q3 2 3 Emp 10 Emcode Name City Sal Designation Age Write the SQL query for the table a) b) c) d) e) f) g) h) i) j) To display the Name who lives in Delhi To display the sal of manager To display all details if designation is clerk To display all details if designation is not ‘jr cleark’. Find maximum salary of this table Find total sal of this table To display Emcode and name if sal is more than 5000 and living in delhi To display the name of all employee if they are more than >50 years Name all employee if started by ‘s’ To display all details if thay lives in either in Noida or Delhi. Q4 What will happened if you fired these queries a) Select round(12322.7865,2) b) Select round(654333.765,-2) c) Select truncate(12322.7865,2) d) Select truncate(654333.765,-2) e) Select char(70) f) Select ucase("INDIA") g) Select trim(“ INDIA "); h) Select POWER (3,3) i) Select concate("BHARAT","INDIA") j) Select SUBSTR("INFORMATICS PRATICES”,2,8); 10 Q5 a) Why do you think USB are popular these days? 1 Define MICR and OCR Write equivalent java expressions for the following expression:3b+ 2ab2 2 2 b) c) Page 1/2 INFORMATICS PRACTICES 065(XI) d) 5 EMPLOYEES EMPID FIRSTNAME LASTNAME Gender CITY Age 010 105 152 215 244 300 335 400 441 George Mary Sam Sarah Manila Rabert Henry Rachel Peter Smith Jones Tones Ackerman Sengupta Samuel Williams Lee Thompson M F M F F M F F M Howard Losantville Paris Upton New Delhi Washington Boston New York Paris 45 55 36 48 23 44 36 55 40 Write the output for Employees table if the following queries are fired i) ii) iii) iv) v) Q6 a) b) c) Q7 a) Select * from Employees where empid>300; Select lastname ,firstname from Employees where city like “New Delhi”; Select empid,firstname from Employees where age>40 Select Firstname from Employees where gender=’f’ and city=’New Delhi’; Select firstname from Employees if gender=’F’ and empid>300; Write a complete Java’s program to add three numbers in Java’s graphical mode. Write a program in Java to calculate the payable amount after multiply item with item price it will calculate total cost, impose 10% as tax after adding tax show payable amount.(Hint Item as 3 and price as 200 total cost will be 600 and tax will be 60 payable amount will be 660. 4 4 What is the difference between getText( ) and setText( ) method? With example 2 Suruchi works for a Shopping Mart. She wants to create controls on a form for the following operations: Choose most appropriate controls out of Text box, Label, Radio Button, List box, Combo box, Check box and Command button. 4 SNo 1 2 3 4 Function Enter the Item code Select Item Size (from a list of sizes) Enter Quantity Submit the Form Control b) What is the major difference between check boxes and option buttons? 2 c) Name any 2 types of Operating System. 1 d) What is Spam? Write any two damages caused by it? 1 e) What do you understand by Primary key give one example 2 Page 2/2 INFORMATICS PRACTICES 065(XI)