XII_CS_Practical_List_2024-25
XII_CS_Practical_List_2024-25
XII_CS_Practical_List_2024-25
Class-XII(CS)(Session2024-25)
Subject Name with code:(083) Computer Science
DetailsofPracticalExamination
MaximumMarks:30
DatabaseManagement
1. Queries using Create database, Show databases, Use, Create table, Show Tables,
Describe, Rename, Alter, Select, From, Where, Insert, Update commands
2. Queries using DISTINCT, BETWEEN, IN, LIKE, ISNULL, ORDERBY, GROUPBY, HAVING
3. Queries for Aggregate functions-SUM(), AVG(),MIN(),MAX(),COUNT()
4. WAP to connect Python with MySQL using database connectivity and
perform the following operation on data in database: Create a table in
database
5. WAP to connect Python with MySQL using database connectivity and
perform the following operation on data in database: Insert record in the
table
6. WAP to connect Python with MySQL using database connectivity and perform
the following operation on data in database: Fetch records from the table using
fetchone(), fetchall() and fetchmany( ).
7. WAP to connect Python with MySQL using database connectivity and
perform the following operation on data in database: Update record in the
table
8. WAP to connect Python with MySQL using database connectivity and
perform the following operation on data in database: Delete record from
the table
***