Page 144 - C++

(i) To display the name of all activities with their Acodes in descending order.
(ii) To display sum of PrizeMoney for each of the Number of participants groupings (as shown in
column ParticipantsNum 10,12,16)
(iii) To display the coach’s name and ACodes in ascending order of ACode from the table COACH
(iv) To display the content of the GAMES table whose ScheduleDate earliar than 01/01/2004 in
ascending order of ParticipantNum.
(v) SELECT COUNT(DISTINCT ParticipantsNum) FROM ACTIVITY;
(vi) SELECT MAX(ScheduleDate),MIN(ScheduleDate) FROM ACTIVITY;
(vii) SELECT SUM(PrizeMoney) FROM ACTIVITY;
(viii) SELECT DISTINCT ParticipantNum FROM COACH;
6. (a) State and Verify Demorgan’s Laws. [2]
(b) Write the equivalent Boolean Expression for the following Logic Circuit. [2]

(c) Write the POS form of a Boolean function F, which is represented in a truth table as follows: [1]
U V W F
0 0 0 1
0 0 1 0
0 1 0 1
0 1 1 0
1 0 0 1
1 0 1 0
1 1 0 1
1 1 1 1

(d) Reduce the following Boolean Expression using K-Map: [3]
F(A,B,C,D)= ∑(0,1,2,4,5,6,8,10)
7. (a) What is the significance of ARPANET in the network? [1]
(b) Expand the following terminologies: [1]
(i) CDMA
(ii) GSM
(c) Give two major reasons to have network security. [1]
(d) What is the purpose of using a Web Browser? Name any one commonly used Web Browser. [1]
(e) Skyline Fashion Technology is planning to expand their network in India, starting with two cities in
India to provide infrastructure for distribution of their product. The company has planned to set
up their main office units in KOLKATA at three different locations and have named their offices as
“Finance unit”, “Media unit” & “Production unit”. The company has its corporate unit in MUMBAI.

MTP.6 Computer Science with C++ —CBSE XII