AISSCE PRACTICAL EXAM



AISSCE PRACTICAL EXAM

Marks : 30 COMPUTER SCIENCE Time : 3hrs

Set 7

1. Programming in C++

Write a program to get Input for a single dimensional array for N elements and Convert into Two Dimensional as follows

Ex: a[5]={1,3,5,7,9}

a[5][5] = | 1 3 5 7 9 |

| 3 9 15 21 27 |

| 5 15 25 35 45 |

| 7 21 35 49 63 |

| 9 27 45 63 91 |

2. SQL Commands

Table - Library

|No |Title |Author |Type |Pub |Qty |Price |

|1 |Data Structure |Lipschutz |DS |McGraw |4 |217 |

|2 |Computer Studies |French |FND |Galgotia |2 |75 |

|3 |Advanced Pascal |Schildt |PROG |PHI |4 |350 |

|4 |Dbase dummies |Palmer |DBMS |PustakM |5 |130 |

|5 |Mastering C++ |Gurewich |PROG |BPB |3 |295 |

Consider the given table and answer the following questions with SQL

1. Select all the PROG type books published by BPB from Library

2. Display a list of all books with price more than 130 and sorted by Qty

3. Display a report listing book id, current value and misplacement charges for each books in the above table. Calculate the misplacement charges for all books as price *1.25.

4. Count the number of books published by PHI

5. Insert a new book in the Library table. Fill all the columns with values.

AISSCE PRACTICAL EXAM

Marks : 30 COMPUTER SCIENCE Time : 3hrs

Set 6

1. Programming in C++

Write a program to create structure for students with the details rollno, name, 5 subject marks, total and avg. Create array of structure for N students, Get input, Process and Show the Output.

2. SQL Commands

Table – Movie

|No |Title |Type |Rating |Stars |Qty |Price |

|1 |Gone with the wind |Drama |G |Gabie |4 |39.95 |

|2 |Friday the 13th |Horror |R |Jason |2 |69.95 |

|3 |Top Gun |Drama |PG |Cruise |7 |79.95 |

|4 |Splash |Comedy |PG13 |Hanks |3 |29.95 |

|5 |Independence Day |Drama |R |Turner |3 |19.95 |

Consider the given table and answer the following questions with SQL

1. Find the total value of the movie cassettes available in the movie table

2. count the number of movies where Rating is not ‘G’;

3. Insert a new movie in the movie table fill all the column with values

4. Delete all the records whose type is “Horror”

5. Increase the price of the movies whose rating is PG by Rs.20/-

AISSCE PRACTICAL EXAM

Marks : 30 COMPUTER SCIENCE Time : 3hrs

Set 5

1. Programming in C++

Create a menu driven C++ program to implement queue as an array of floating point numbers

2. SQL Commands

Table – Doctor

|Id |Name |Dept |Sex |Experience |

|104 |SMITH |ORTHOPEDIC |M |5 |

|107 |GEORGE |CARDIOLOGY |M |10 |

|114 |LARA |SKIN |F |3 |

|109 |K GEORGE |MEDICINE |F |9 |

|105 |JOHNSON |ORTHOPEDIC |M |10 |

|117 |LUCY |ENT |F |3 |

|111 |BILL |MEDICINE |F |12 |

|101 |JOHN |ENT |M |12 |

|130 |MORPHY |ORTHOPEDIC |M |15 |

Table – Salary

|Id |Basic |Allowances |Consultancy |

|104 |23000 |2300 |500 |

|107 |32000 |4000 |500 |

|114 |12000 |5200 |100 |

|109 |42000 |1700 |200 |

|105 |18900 |1690 |300 |

|101 |12000 |1000 |300 |

|130 |21700 |2600 |300 |

Consider the given table and answer the following questions with SQL

1. Display name of all doctors who are in “Medicine” having more than 10 years experiences from the table Doctor

2. Display the average salary of doctors working in “ENT” department using the tables Doctor and Salary, Average Salary = Basic + Allowance

3. Display the minimum allowance of female doctors

4. Display the highest consultation fee among the male doctors

5. Find the no. of female doctors

AISSCE PRACTICAL EXAM

Marks : 30 COMPUTER SCIENCE Time : 3hrs

Set 4

1. Programming in C++

Create a menu driven program to implement stack operations as linked list on the class student with the details (rollno)

2. SQL Commands

Table – Flights

|fl_no |starting |ending |no_flights |no_stops |

|IC301 |MUMBAI |DELHI |8 |0 |

|IC799 |BANGALORE |DELHI |2 |1 |

|MC101 |INDORE |MUMBAI |3 |0 |

|IC302 |DELHI |MUMBAI |8 |0 |

|AM812 |KANPUR |BANGALORE |3 |1 |

|AM501 |DELHI |TRIVANDRUM |1 |5 |

|MU499 |MUMBAI |MADRAS |3 |3 |

|IC701 |DELHI |AHMEDABAD |4 |0 |

|IC899 |MUMBAI |KOCHI |1 |4 |

Table – Fares

|fl_no |airlines |fare |tax |

|IC701 |Indian Airlines |6500 |10 |

|MU499 |Sahara |9400 |5 |

|AM501 |Jet Airways |13450 |8 |

|IC302 |Indian Airlines |4300 |10 |

|IC799 |Indian Airlines |10500 |10 |

|MC101 |Deccan Airlines |3500 |4 |

|IC899 |Indian Airlines |8300 |4 |

Consider the given table and answer the following questions with SQL

1. Display Fl_no and No_Flights from “Kanpur” to “Bangalore” from the table flights.

2. Arrange the contents of the table flights in the ascending order of Fl_no.

3. Display the Fl_no and fare to be paid for the flights from “Delhi” to “Mumbai” using the tables flights and fares, where the fare to be paid = Fare + Tax / 100

4. Display the minimum fare=”Indian Airlines” is offering from the table

5. Count the number of Flights starting from Mumbai

AISSCE PRACTICAL EXAM

Marks : 30 COMPUTER SCIENCE Time : 3hrs

Set 3

1. Programming in C++

Create a file handling program to store, retrieve and display employee details ( eno, ename, salary and experience)

2. SQL Commands

Table – Workers

|w_id |firstname |Lastname |address |city |

|105 |Sarah |Ackerman |440, US 110 |New York |

|144 |Manila |Sengupta |24 Friends St |New Delhi |

|210 |George |Smith |83 First St. |Howard |

|255 |Mary |Jones |542 vine ave |Losantiville |

|335 |Henry |Williams |12 moore st. |Boston |

|403 |Ronny |Lee |121 harrison st |New York |

|451 |Pat |Thompson |11 red road |Paris |

|102 |Sam |Tones |33 elm st |Paris |

|300 |Robert |Samuel |9 fifth cross |Washington |

Table – Desig

|w_id |salary |benefits |designation |

|105 |85000 |25000 |Director |

|144 |70000 |15000 |Manager |

|210 |75000 |12500 |Manager |

|255 |50000 |12000 |Clerk |

|102 |75000 |15000 |Manager |

|300 |45000 |10000 |Clerk |

|335 |40000 |10000 |Clerk |

|403 |32000 |7500 |Salesman |

|451 |28000 |7500 |Salesman |

Consider the given table and answer the following questions with SQL

1. Display w_id, Firstname, Address and City of all employees living in New York from the table Workers

2. Display the content of workers table in ascending order of Lastname

3. Display the firstname, lastname and total salary of all clerks from the table workers and desig where total salary is calculated as Salary+ Benefits

4. Display the minimum salary among manager and clerks from the table desig

5. Find the total salary of workers designation wise.

AISSCE PRACTICAL EXAM

Marks : 30 COMPUTER SCIENCE Time : 3hrs

Set 2

1. Programming in C++

Write a program to get Input for a single dimensional array for N elements and Sort the array using bubble sort technique and Read a Value and find the position and index of that value in the array.

2. SQL Commands

Table – BOOKS

|Book_Id |Book_Name |Author_Name |Publishers |Price |Type |Quantity |

|C01 |Fast Cook |Lata Kapoor |EPB |355 |Cookery |5 |

|F01 |The Tears |William Hopkins |First |650 |Fiction |20 |

|T01 |My C++ |Brain and Brooke |FPB |350 |Text |10 |

|T02 |C++ Brain |A.W.Rossaine |TDH |350 |Text |15 |

|F02 |Thuderbolts |Anna Roberts |First |750 |Fiction |50 |

Table – ISSUED

|Book_Id |Quantity_Issued |

|T01 |4 |

|C01 |5 |

|F01 |2 |

|C01 |4 |

|T02 |3 |

1. To list the book name and author name from books of Text type.

2. To display the names and price from books in ascending order of their price.

3. To increase the price of all books of EPB publishers by 50.

4. To display the Book Name, Quantity_Issued and Price for all books of EPB publishers.

5. To display the maximum price from books

AISSCE PRACTICAL EXAM

Marks : 30 COMPUTER SCIENCE Time : 3hrs

Set 1

1. Programming in C++

Write a program create a text file with some words and to check number of words in the file.

2. SQL Commands

Table : CLUB

|COACH-ID |COACHNAME |AGE |SPORTS |DATOFAPP |PAY |SEX |

|1 |KUKREJA |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 |

1. To list names of all coaches with their data of appointment (DATOFAPP) in descending order.

2. To display a report, showing coach name, pay, age and bonus (15% of pay) for all coaches.

3. To insert a new record in the CLUB table with the following data:

11,”Rajender”,25,”Football”,{27/05/2004},4500,”M”

4. To display the coach id who joined after 01/01/1998

5. To display the Coach names whose name end with ‘N’

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download