Page 151 - C++

(b) To list the name of female teachers in History department. [1]
(c) To list all names of teachers with date of admission in ascending order. [1]
(d) To display Teacher’s name, Department, and Salary of female teacher. [1]
(e) To count the number of items whose salary is less than ` 10,000? [1]
(f) Give the output of the following SQL command: [2]
(i) SELECT MIN(DISTINCT Salary) FROM Teacher
(ii) SELECT MIN(Salary) FROM Teacher WHERE Sex = “M”
(iii) SELECT SUM(Salary) FROM Teacher WHERE Department = “History”
(iv) SELECT AVG(Salary) FROM Teacher WHERE Dateofjoining < {1/1/98}
6. (a) State the distributive law and verify the law using truth table. [1]
(b) Prove XY + YZ + Y'Z = XY+Z, algebraically. [2]
(c) Obtain the simplified form of a Boolean expression using Karnaugh map. [3]
F(w, x, y, z) = Σ(2, 3, 6, 10, 11, 14)
(d) Given the following truth table, derive a sum of product (SOP) and Product of Sum (POS) form of
Boolean expression from it : [1]
A B C F(A,B,C)
0 0 0 1
0 0 1 1
0 1 0 0
0 1 1 1
1 0 0 0
1 0 1 1
1 1 0 1
1 1 1 0

(e) Interpret the following Logic Circuit as Boolean Expression: [1]

(f) Represent the Boolean expression (X+Y)(Y+Z)(X+Z) with the help of NOR gate only. [1]
7. (a) Write two advantages and two disadvantages of STAR topology. [1]
(b) Write one difference between coaxial and optical cable. [1]
(c) Explain the following terms in short: [1]
(i) FTP
(ii) URL
(d) Define Packet Switching. [1]

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