CBSE Class 11 Informatics Practices Worksheet Set E 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