Scribd
Upload
21 views1 page

Class12 CS

The document outlines a model practical examination for Computer Science at Chinmaya Vidyalaya Pallavur. It includes tasks such as writing SQL queries to manipulate data in a table, creating a binary file to store student information, and generating a CSV file for employee data. Each task requires specific programming skills and data handling techniques.

Uploaded by

ushavalsa
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
21 views1 page

Class12 CS

The document outlines a model practical examination for Computer Science at Chinmaya Vidyalaya Pallavur. It includes tasks such as writing SQL queries to manipulate data in a table, creating a binary file to store student information, and generating a CSV file for employee data. Each task requires specific programming skills and data handling techniques.

Uploaded by

ushavalsa
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

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.

You might also like