Home » Class XI » Computer Science XI A,B

# Computer Science XI A,B

Date of submission: 03/01/2010

Mrs. SuniAbraham, PGT(CS)

1. What is an array ? Explain the need of arrays.
2. Differentiate between single and multi dimensional arrays .
3. Write a program to find the largest element in an array.
4. Write a program to accept elements in a two dimensional array and print it.
5. Write a program to accept a string in an array and check whether it is a palindrome or not.

CLASS XII  A/B       COMPUTER  SCIENCE

Write SQL commands for (b) to (e) and write the outputs for (g) on the basis of table CLUB.

Table: CLUB

 COACH_ID COACHNAME AGE SPORTS DATOFAPP PAY SEX 1 KUKERJA 35 KARATE 27/03/1996 1000 M 2 RAVINA 34 KARATE 20/01/1998 1200 F 3 KARAN 34 SQUASH 19/02/1998 2000 M 4 TARUN 33 BASKETBALL 01/01/1998 1500 M 5 ZUBIN 36 SWIMMING 12/01/1998 750 M 6 KETAKI 36 SWIMMING 24/02/1998 800 F 7 ANKITA 39 SQUASH 20/02/1998 2200 F 8 ZAREEN 37 KARATE 22/02/1998 1100 F 9 KUSH 41 SWIMMING 13/01/1998 900 M 10 SHAILYA 37 BASKETBALL 19/02/1998 1700 M

Q To show all the information about the swimming coaches in the club.

Q To list names of all the coaches with their date of appointment (DATOFAPP) in descending order.

To isplay a report showing coachname, pay, age, and bonus (15% of pay) for all the coaches.

Q To insert a new row in the CLUB table with the following data: 11, “PRAKASH",37, “SQUASH",{25/02/1998},2500, “M”

Q) Give the output of following SQL statements:

(i)Select COUNT (distinct SPORTS) from CLUB;
(ii) Select MIN(AGE) from CLUB where SEX="F";
(iii) Select AVG(PAY) from CLUB where SPORTS="KARATE";
(iv) Select SUM(PAY) from CLUB where DATOFAPP>(31/01/98);

Q 2 Assume that there is one more table COACHES in the database as shown below:

Table: COACHES

 SPORTS PERSON SEX COACH_NO AJAY M 1 SEEMA F 2 VINOD M 1 TANEJA F 3

What will be the output of the following query: SELECT SPORTS PERSON, COACHNAME
FROM CLUB, COACHES
WHERE COACH_ID=COACH_NO;

Q(a)State Absorption Laws. Verify one of the Absorption Laws using a truth table.

Q(b) Prove X’.Y+Y’.Z=X’.Y.Z+X’.Y’.Z’+X.Y’.Z+X’.Y’.Z algebraically.

Q © Obtain simplified form for a boolean expression
F(x,y,z,w)= å(1,3,4,5,7,9,11,12,13,15) using Karnaugh Map.

Q(d) Draw the logic circuit for a half adder.

Q(e) Represent the Boolean expression X’Y+Y’Z with the help of NAND gates only.

Q (f) Write the Sum of Products form of the function G(U,V,W). Truth table representation of G is as follows:

 U V W G 0 0 0 0 0 0 1 0 0 1 0 1 0 1 1 1 1 0 0 1 1 0 1 0 1 1 0 0 1 1 1 1

Q  (a) What are Routers?

Q(b) What is the purpose of using a Modem?

Q © Write two advantages and two disadvantages of Bus Topology in network.

Q (d) What is the difference between LAN and WAN?