CBSE Class 11 Informatics Practices Worksheet Set G Solved

1.
(a) Define a GUI application to create a Combo Box Chat Item with the following values

The frame is designed as given below

Write a program to print the price of chat items according to the item selected in a text field (jTextField1) on clicking FIND COST button based on the following information.

(b) Write Java code to display odd numbers from 1 to 50 using while loop. 

(c) Write Java code to accept the number of lines n using input dialog box and generate the following pattern
1
22
333

(d) Give any one difference between while loop and do..while loop. 
(e) What will be displayed in jTextField1 and jTextField2 after the following code is executed :
int ndigits = 7;
int N=11;
while (N>2) {
ndigits = ndigits + 1;
N = N-3;
}
jTextField1.setText(“ “+ndigits);
jTextField2.setText(“ “+N);

(f) Rewrite the following code using for loop
Nm = 100;
while (Nm > 20)
{
T = T + Nm;
Nm = Nm - 10;
}

(g) Mr. Santhosh has developed a Java application through which the students of his school can view their marks by entering their admission number. The marks are displayed in various text fields. The application also has grade text field(jTextField7). What code in Java should he give so that the grade text field is invisible ?

2.
Given the following table DOCTOR

Write SQL commands for questions (a) to (e) based on the above table

(a)Increase the salary of Doctors of Cardiology Department by 5% 

(b) Create the structure of the above table. Define D_ID to accept unique values. 

(c) Remove the details of doctors whose name has „s‟ in it. 

(d) Add a new row with the following details

D_ID=2100 Name = “George” Gender = “Male” Salary = 52800

(e) Remove the field Salary from the table.

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