Scribd
Upload
9 views2 pages

Class 12 Computer Science Practical Guide

The document is a practical file for Class 12 Computer Science, containing a series of programming exercises across various topics. It includes SQL queries for database manipulation, file handling tasks, Python SQL connectivity, Python programming concepts, and functions. Each section consists of multiple questions aimed at enhancing students' practical skills in computer science.

Uploaded by

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

Class 12 Computer Science Practical Guide

The document is a practical file for Class 12 Computer Science, containing a series of programming exercises across various topics. It includes SQL queries for database manipulation, file handling tasks, Python SQL connectivity, Python programming concepts, and functions. Each section consists of multiple questions aimed at enhancing students' practical skills in computer science.

Uploaded by

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

Class 12 Computer Science Practical File

SQL (One and Two Tables) - 8 Questions


1. Write a query to display all records from the student table.
2. Write a query to display name and marks of students scoring more than 80.
3. Write a query to count the number of students in each class.
4. Write a query to display employee name and department from employee and department tables
using join.
5. Write a query to find the maximum salary from the employee table.
6. Write a query to display students sorted by marks in descending order.
7. Write a query to display product name and supplier name using join on product and supplier
tables.
8. Write a query to display total sales grouped by year.

File Handling (Text, Binary, CSV - 6 Questions)


1. Write a program to count the number of lines in a text file.
2. Write a program to search for a word in a text file.
3. Write a program to write and read student records using binary file.
4. Write a program to update a record in a binary file.
5. Write a program to read data from a CSV file and display it.
6. Write a program to write a list of dictionaries into a CSV file.

Python SQL Connectivity - 4 Questions


1. Write a program to connect Python with MySQL and display database names.
2. Write a program to insert a record into the student table using Python.
3. Write a program to update marks of a student in the database using Python.
4. Write a program to fetch and display all rows from the employee table.

Python Recap (Strings, Dictionary, List, Tuples, Looping,


Conditional) - 10 Questions
1. Write a program to check if a string is palindrome.
2. Write a program to count frequency of characters in a string.
3. Write a program to add two lists element-wise.
4. Write a program to find the maximum element in a list.
5. Write a program to demonstrate tuple packing and unpacking.
6. Write a program to print multiplication table using loop.
7. Write a program to check if a number is prime using loop and condition.
8. Write a program to merge two dictionaries.
9. Write a program to count vowels in a string.
10. Write a program to find sum of even numbers in a list.

Python Functions - 4 Questions


1. Write a function to calculate factorial of a number.
2. Write a function to return nth Fibonacci number.
3. Write a function to check whether a number is Armstrong or not.
4. Write a function to find the GCD of two numbers.

You might also like