Home works and Assignments Online

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?

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: