XII-CS SAMPLE PRACTCAL QUESTION-PAPER

Central Board of Secondary Education

All India Senior Secondary Certificate Examination – 2013

Subject: Computer Science  (083)  Date-

S.No.	Description	Marks
1	Problem Solving using Java	10
2	SQL Queries	5
3	Practical Record	5
4	Project Work	5
5	Viva Voce	5

 

Evaluation of Practical Examination:

 SECTION – A

Attempt any one C++ Programming assignment given below (Question is randomly selected based on chit drawn)

Q1. Write a menu based program to perform the following operations on matrices

(a) Add two matrixes (b) Multiply two matrixes  (c) Subtract two matrixes

Q2.Write an OOP to perform the mathematical operations on complex numbers :

1-Add  2-Substract   3-Multiply

Q3. Write a program to perform  following string operations without using in-built library functions

1 Find length of string  2 Reverse a string  3 Change the case of all char in a string

Q4. Write a program to perform following in a TEXT FILE :

1. Count no. Of vowels   2. Count no. Of consonants   3. Count total no. Of alphabets

Q5. Write a program to concat/combine the content of 2 different files into a third file.

Q6. Write a program to perform  Insertion sort

Q7. Write a program to perform  Selection sort

Q8. Write a program to perform  Binary-Search.

Q9. Write a program to    Implement stack using array. 

Q10. Write a program to   Implement Dynamic link list.

Q11. Write a program to implement Queue using the concept of dynamic allocation.

 

SECTION – B 

     Attempt ALL 5  SQL queries:    

  TABLE NAME :    WORKERS

W_ID	FIRSTNAME	LASTNAME	ADDRESS	CITY
102	Sam	Tones	33 Elm St.	Paris
105	Sarah	Ackerman	440 U.S. 110	New York
144	Manila	Sengupta	24 Friends Street	New Delhi
210	George	Smith	83 First Street	Howard
255	Mary	Jones	842 Vine Ave.	Losantiville
300	Robert	Samuel	9 Fifth Cross	Wasington
335	Henry	Williams	12Moore Street	Boston
403	Ronny	Lee	121 Harrison St.	New York
451	Pat	Thompson	11 Red Road	Paris

TABLE NAME : DESIG

W_ID	SALARY	BENEFITS	DESIGNATION
102	75000	15000	Manager
105	85000	25000	Director
144	70000	15000	Manager
210	75000	12500	Manager
255	50000	12000	Clerk
300	45000	10000	Clerk
335	40000	10000	Clerk
400	32000	7500	Salesman
451	28000	7500	Salesman

 

(i)                              Write commands to create above 2 tables.

(ii)                            To display w_id, firstname, address and city of all employees living in new york from the table workers.

(iii)                           To display the content of workers table in ascending order of lastname.

(iv)                          To display the firstname, lastname and total salary of all clerks from the tables workers and desig, where total salary is calculated as salary + benefits.

(v)                            To display the W_ID FIRSTNAME, DESIGNATION of all employees.