Kendriya Vidyalaya Jharoda Kalan
Program List (Computer Science) Subject Code: 083
Class XII
Session: 2024-25
1 Write a program to count the number of vowels present in a text file.
2
Write a program to write those lines which have the character 'p' from one text file
to another text file.
3
Write a program to count number of words in a file.
4 Write a menu driven program in python to count spaces, digits, words and lines from text file
TOY.txt.
5 Write a program to read a text file line by line and display each word separated by a #.
6 Write a program to read a text file and display the number of vowels/ consonants/uppercase/
lowercase characters in the file.
7
Write a program to create a binary file with name and roll number. Search for a given roll number
and display the name, if not found display appropriate message.
8 Write a program create a binary file with roll number, name and marks. Input a roll number and
update the marks.
9 Write a program to remove all the lines that contain the character ‘a’ in a file and write it to
another file.
10 Write a program to create a dictionary with roll number, name and marks. Accept 5 records from
the user and write them into a binary file.
11 Write a program to create a CSV file by entering user-id and password, read and search the
password for given user ID.
12 Write a program to create a menu driven python program to create a CSV file by entering dept-id,
name and city, read and search the record for given dept-id.
13
Write a random number generator that generates random numbers between 1 and 6 simulates a
dice).
14
Write a Python program to implement a stack using a list data-structure.
15 Write a program in Python to create a stack named Stack_Vow, which takes the elements as
vowels and implement all operations (Push, Pop and Traversal) on the stack called Stack_Vow.
16 Shreya has a list containing 10 integers. You need to help her create a program with separate
user defined functions to perform the following operations based on this list.
● Traverse the content of the list and push the even numbers
into a stack.
● Pop and display the content of the stack.
17 Write a program to connect with the database called org and display records of Employee
table. The Employee table has following columns:EmpID of type int, Ename of type string,
Salary of type integer, Gender of type character, DOJ of type date.
18
Write a program to connect with database and search employee number in employee table and
display record and if not found display appropriate message.
19 Write a program to connect with database and update the employee record of entered empno.
20 Write a program to connect with database and delete the record of entered employee number.
Structured Query Language
Consider the following tables and answer the following
Book
Book_Id Book_Name Author_Name Publisher Price Type Quantity
C0001 Fast Cook LataKapoor EPB 355 Cookery 5
F0001 The Tears William Hopkins First Pub 650 Fiction 20
T0001 My First C++ Brain & Brooke EPB 350 Text 10
T0002 C++ Brain works A.W. Rossaine TDH 350 Text 15
F0002 Thunderbolts Anna Roberts First Pub 750 Fiction 50
Issued
Book_Id Issuedto Quantity_Issued
T0001 Kamal 4
C0001 Arvind 5
F0001 Suresh 2
1. To show Book id, Book name, Author name and price of books of First Pub Publisher
2. To display the names and price of books in ascending order of their prices.
3. Display the price of book which has price between 300 to 500.
4. To increase the price of all books of EPB publishers by 50.
5. To display the Book_Id, Book_Name and quantity issued for all books which have been issued.
6. To display the Bookname and Price of Books for all books having ‘C++’ in the bookname.
7. Delete the book whose book id is T0002
8. Show all book whose book name starts with character ‘T’
Give the output of the following
9. Select Count(*) from Book;
10. Select Max(Price) from Book where Quantity >=15;
11. Select Book_Name, Author_Name from Book where Publisher=’First Pub’;
12. Select count(distinct Publisher) from Book where Price>=400;
13. Select count(distinct(Publisher)) from Book;
14. Select Book_Name,Publisher from Book where Type in (‘Text’,’Fiction’);
15. Select min(Price),Publisher from Book group by Publisher;
