CBSE Class 11 Informatics Practices Worksheet Set 02 Solved

1.
(a) Write Java code to display area of a circle in jTextField2 on clicking AREA button. The user enters radius of the circle in jTextField1. Also write code to terminate application when the user clicks EXIT button.

(b) Predict the output of the following code fragment :

int a=30,b=40, i=10, j=10;
if (a<100)
if (b>50)
++i;
else ++j;
System.out.println(“i=”+i);
System.out.println(“j=”+j);

(c) Rewrite the following code in Java using if statement

int k;
char d;
switch (k) {
case 1: d=‟N‟;
break;
case 2: d=‟E‟;
break;
case 3: d=‟W‟;
break;
case 4: d=‟S‟;
break;
default: d=‟M‟; }

(d) An electronic shop has announced the following seasonal discounts on the purchase of certain items.

Develop the following GUI application based on the above criteria, to input name of a customer, amount of purchase and item of purchase (TV or Music System using Radio Button) by a customer. Compute and print the net amount to be paid by a customer in a text field (jTextField3) on clicking COMPUTE button. (Net amount = amount of purchase – discount)

(e) Develop the following GUI application to find day of the week.

Write Java code to accept an integer between 1 to 7 in jTextField1 and display day of the week (Monday for 1, Tuesday for 2 and so on..) in jTextField2 on clicking FIND DAY button using switch statement. If the user enters any other number display ERROR. Also write code for RESET button to clear both the text fields.

(f) Give any one difference between Radio Button and Check Box. 

2.

(a) Given the following table STUDENT

Write SQL commands based on STUDENT table for the following :

(i) Display names of the students whose average is in the range 70 to 90.

(ii) Display the details of the students in ascending order of Admno.

(iii) Display Admno and name of students from class 9 whose average marks are below 60.

(iv) Display details of the students whose name ends with „a‟

(v) Display Name and class of students whose average marks are not entered in the table

(b) Write output for the following SQL commands based on STUDENT table

(i) SELECT Name FROM STUDENT WHERE Class IN (11,12);

(ii) SELECT DISTINCT Class FROM STUDENT;

Please click on below link to download CBSE Class 11 Informatics Practices Worksheet Set B Solved