Page 51 - IP

iii.

2301003 65000
2201002 20000

(2 mark for correct output)
OR

Sometimes we do not want to see the whole output produced by a statement with
Group By clause. We want to see the output only for those groups which satisfy
some condition. It means we want to put some condition on individual groups
(and not on individual records). A condition on groups is applied by Having
clause. For example consider the following query:

select Acc_No, sum(Amount) from Customer c, Transaction t where
c.Acc_No=t.Acc_No group by c.Acc_No having Transaction_Type="Credit";

This query will create account number wise groups and instead of displaying the
total amount of all type of transactions, it will only display the total of credit
transactions only.

(2 mark for correct answer)

7. (a) It’s an era of online financial transactions. Help Julie in identifying any two 2
challenges which a common man may face for the same.

Ans: i. A common man should have an electronic gadget like smart phone or
computer.
ii. A common man should be oriented for online financial safety measures.
(1 mark for each correct answer)

(b) Mention any one major environmental benefits of ICT to Ms. Megha so that she 1
can utilize it in her future “Save Earth” campaign

Ans: Major environmental impact of ICT on our society is that it is creating a virtually
paperless work environment so reducing cutting down of trees for paper
manufacturing.

(1 mark for each correct answer)

(c) Ms. Achla, works as a Programmer in a survey firm named “National Survey 2
Foundation”. In her current project, she is supposed to design a survey page for
an online educational training program. Help her in choosing the most
appropriate controls for the specified task from Textfield, Label, RadioButton,
CheckBox, ListBox, ComboBox, Button and write in the third column:

S. No. Control used to input Control

1 TRAINEE’S NAME

2 TRAINING LOCATION

3 GRADE THE SESSION
(Excellent, Good, Satisfactory, Unsatisfactory)

4 SUGGESTIONS

14