Scribd
Upload
4 views2 pages

Computer Science Practical Questions

The document outlines a series of practical programming tasks related to computer science, including file handling, data structures, and SQL queries. It includes tasks such as reading text files, creating binary files, managing student records in CSV format, and performing various database operations using Python and MySQL. Each task is numbered and specifies the required functionality, such as displaying counts of characters, managing book details, and querying employee and student data.

Uploaded by

rg973369
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
4 views2 pages

Computer Science Practical Questions

The document outlines a series of practical programming tasks related to computer science, including file handling, data structures, and SQL queries. It includes tasks such as reading text files, creating binary files, managing student records in CSV format, and performing various database operations using Python and MySQL. Each task is numbered and specifies the required functionality, such as displaying counts of characters, managing book details, and querying employee and student data.

Uploaded by

rg973369
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Computer Science Practical file questions

[Link] TITLE OF THE PROGRAME

Read a text file and display the number of vowels/consonants/uppercase/lowercase


01.
characters in the file.

Create a binary file with name and roll no. Search for a given roll number and
02.
display the name, if not found display appropriate message.

Create a menu driven program to accept, show, delete, modify and search data in a
03. CSV file with student name and roll no and marks. Search for a given roll number
and display the name and marks, if not found display appropriate message.

Program to maintain book details like book code, book title and price using stacks
04.
data structures (implement push(), pop() and traverse() functions).

Write a menu based program to add, delete and display the record of hostel using
05. list as stack data structure in python. Record of hostel contains the fields : Hostel
number, Total Students and Total Rooms

Query to find the Item number, dealer, and price arranged in ascending order in
06.
Item Table

07. Query to find the highest and lowest price for each article type.

Query to display Employee number, name, department and annual salary for all
08.
employees where annual salary is (monthly salary * 12) from employee table.

Query to display student name and marks of 5 subjects from student and marks
09.
table if score of maths and science is more than 80.

Write a SQL query to find the salespersons and customers who live in same city.
10.
Return customer name, salesperson name and salesperson city

11. Function to create a table in MySQL using python and MySQL interface

12 Function to insert a record in table ‘Students’ using python and MySQL interface

1
13 Function to show all record in table ‘Students’ using python and MySQL interface

14 Function to delete a record in table ‘Students’ using python and MySQL interface

You might also like