CBSE Class 11 Informatics Practices Worksheet Set 05 Solved

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

(a) Create the structure of the above table with W_ID as Primary key. 

(b) Remove the details of the worker whose name ends with ‘s’ 

(c) Increase the rate by ₹10 for all workers. 

(d) Add a new field Bonus with data type numeric(7,2) in the above table. 

(e) Add a new row with the following values

W_ID = 2001, NAME = Francis, RATE = 325

VALUE POINTS 

1.

(a) Difference between list and combo box. (Any one point) 

(b) jTextField1.setEditable=false; 

(c) t=5.0 (1 mark)

The loop is executed 5 times (1 mark)

(d) Rewrite the following code using for loop

for (Nm=1;Nm<20;Nm=Nm+2)
T=T+Nm;

(e) Write Java code to display the numbers from 1 to 100 using while
loop.
i=1;
while (i<=100)
{
System.out.println(i);
i++;
}

(f) To generate the following pattern
1
12
123
int N,i,j;
String x;
x=JOptionPane.showInputDialog(“Enter the number of lines”);
N=Integer.parseInt(x);
for(i=1;i<=N;i++)
{
for(j=1;j<=i;++j)
System.out.print(j);
System.out.println();
}

(g) Code to perform Action on clicking Submit button
{
String St,Sec,R;
R=jTextField1.getText();
St=(String)jList1.getSelectedValue();
Sec=(String)jList2.getSelectedValue();
JOptionPane.showMessageDialog(null,"Roll Number "+R+" from
"+St+" Stream, Section "+Sec);
}

2.
(a) CREATE TABLE WORKER(W_ID INT PRIMARY KEY, NAME
VARCHAR(20), HRS INT, RATE INT);

(b) DELETE FROM WORKER WHERE NAME LIKE „%s‟; 

(c) UPDATE WORKER SET RATE= RATE + 10; 

(d) ALTER TABLE WORKER ADD Bonus NUMERIC(7,2); 

(e) INSERT INTO WORKER(W_ID,NAME,RATE)
VALUES(2001,‟FRANCIS‟,325);

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