Page 164 - C++

(b) Give the output of the following SQL queries :

(i) SELECT DESIGNATION, COUNT (*) FROM ADMIN GROUP BY DESIGNATION HAVING COUNT (*)<2;
(ii) SELECT MAX (EXPERIENCE) FROM SCHOOL;
(iii) SELECT TEACHERNAME FROM SCHOOL WHERE EXPERIENCE > 12 ORDER BY TEACHERNAME;
(iv) SELECT COUNT (*), GENDER FROM ADMIN GROUP BY GENDER;

Q6 (a) State any one Absorption Law of Boolean Algebra and Verify it using truth table. (2)

(b) Draw the Logic Circuit of the following Boolean Expression: (2)

(X’+Y).Z + W’

(c) Derive a Canonical POS expression for a Boolean function F(U,V,W) represented by the following truth
table: (1)

U V W F(U,V,W)
0 0 0 0
0 0 1 1
0 1 0 1
0 1 1 1
1 0 0 0
1 0 1 0
1 1 0 1
1 1 1 1

(d) Reduce the following Boolean Expression to its simplest form using K-Map: (3)

F(X,Y,Z,W)= Σ (0,1,3,5,6,7,9,1,13,14,15)

Q7 (a) Ms. Raveena Sen is an IT expert and a freelancer. She recently used her skills to access the Admin
password for the network server of Super Dooper Technology Ltd. and provided confidential data of the
organisation to its CEO, informing him about the vulnerability of their network security. Out of the following
options (i) to (iv), which one most appropriately defines Ms. Sen? (2)

1) Hacker
2) Cracker
3) Operator
4) Network Admin

Justify the reason for your chosen option:

(b)What is the difference between POP3 and IMAP mail server? (1)

(c) How is Coaxial cable different from Optical Fibre? (1)