CBSE Class 11 Informatics Practices Worksheet Set 06 Solved

1.

(a) Ms. Sheethal has developed a Java application through which the students of her school can view their marks by entering their admission number. The marks are displayed in various text fields. What Java code should she give so that the text fields are disabled ?

(b) Rewrite the following code using do..while loop
Nm = 1;
T=0;
while (Nm < 20)
{
T = T + Nm;
Nm = Nm + 2;
}

(c) Write Java code to display even numbers between 1 to 30 using for loop.

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

$
$$
$$$

(e) Write the value of C after executing the following code :

int P;
int R=8;
int oddNum;
int C=0;
for (P=1; PoddNum = P%2;
if (oddNum == 1) {
C = C + 1; } }

(f) Define a GUI application to create a list Class Name with the following values

The frame is designed as given below

Write Java code to print the names of the class teacher according to the class selected in a text field (jTextField1) on clicking FIND button based on the following information. Use if statement. Display the message “Select any one class” if no class is selected in the list.

(g) What do you mean by nested loops ? 

2.
Given the following table EMPLOYEE

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

(a) Add a new row with the following details
EmpNo=2100 Name = “George” Job = “Salesman” Gender = “Male” Salary = 37800 

(b) Change the datatype of Salary to Numeric(8,2). 

(c) Increase the salary of Managers by 10% 

(d) Remove the details of employees whose name starts with „A‟ 

(e) Create the structure of the above table. Define EmpNo field not to have NULL values.

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