Chinmaya Vidyalaya Pallavur
Model Practical Examination
Computer Science(083)
1. Write Queries for the following using the data from the above given table (create
table if not exists along with the data given)
(a) To Display the average price of all the Uniform of Raymond Company from table COST.
(b) To display details of all the Uniform in the Uniform table in descending order of Stock
date.
(c) To Display max price and min price of each company.
d) To display the company where the number of uniforms size is more than 2.
(e) To display the Ucode, Uname, Ucolor, Size and Company of tables uniform and cost.
2.Write a program to create a binary file with roll number and name.Search for a given roll
number and display the name,if not found display appropriate message.
3.Write a program to create a CSV file,to store data,empno,empname,salary and search
empno and display name, salary and if not found display appropriate message.