ALPINE PUBLIC

SCHOOL KHURJA
PRACTICAL FILE
FOR
CBSE 2022-2023 EXAMINATION
[AS A PART OF THE INFORMATION
TECHNOLOGY (802)]
BOARD PRACTICAL EXAMINATION – 2022-
2023
CLASS – XII

Under the Guidance of:

Mr. Gagan Bhardwaj

PGT (IT)

Submitted By

1
 Name :

CERTIFICATE

This is to certify that __________________ , Roll No. _____of C lass 12th Session 2022-23 has prepared
the Practical File as per the Prescribed Practical Syllabus of Information Technology Code 802, Class 12
AISSCE(CBSE) under my supervision.

It is the original work done by him/her. His/her work is really appreciable.

I wish him/her a very bright success.

__________________________

Signature of Teacher

___________________________

Signature of External

2
 INDEX

S.NO PRACTICAL DESCRIPTION PAGE NO. TEACHER’S

SIGNATURE
1 Write a java application to find the maximum of three
integers entered by the user.
2 Write a Java program with method to calculate are of circle.
3 Java Program to Print all Even Number between 1 to 10.
4 Java Program to check number is Prime or not.
5 Write a program to find the factorial of entered number.
6 Write a program to print Fibonacci series up to 10 terms.
7 Write a program to find the sum of all even numbers between
1 to 100.
8 Write a program to print reverse of entered number.
9 Write a program to convert entered string into Upper case.
10 Write a program in java to count vowels and consonant of a
given string.
11 Write a program to enter 10 numbers in an array and find the
largest element.
12 Write a program to print day name by using switch case.
13 Write a program to find the given year is a leap year or nor.
14 Write a Program to create a class Rectangle and calculate area
using method and object.
15 Write a program in Java to enable user to handle divide by
zero exception.
16 Create a database Company, show the list of databases and
select Company database.
17 Create table Employee(empid int(4) primary key, ename
varchar(15) not null, dob date, designation varchar(20) ,
department varchar(20), Hiredate date, salary de(8,2) check
(salary>10000).
18 Show the structure of employee table.
19 Insert five records in employee table.
20 Display all the information of employees whose designation is
NEITHER Manager nor Salesman.
21 Display the details of all the employees whose Hiredate is
after December 2020.
22 Display all information of Clerk and Manager in descending
salary wise
23 List all employees whose name start with character ‘a’.
24 Display ename and Salary of those Employees whose Salary is
in the range 15000 and 28000.
25 Display average Salary, highest Salary and total no. of

3
 Employees for each department.
26 Increase the Salary of 'Clerk' by 5% Sal and verify the update d
rows.
27 Add a new column named Address.
28 Drop the column address
29 Display ename, designation, salary and Hiredate of 'Clerk '
whose Salary is below 28000.
30 Display unique designation .

4
 Practical 1

Write a java application to find the maximum of three integers entered by the user.

5
 Practical 2

Write a Java program with method to calculate are of circle.

6
 Practical 3

Java Program to Print all Even Number between 1 to 10.

7
 Practical 4

Java Program to check number is Prime or not.

8
 Practical 5

Write a program to find the factorial of entered number.

9
 Practical 6

Write a program to print Fibonacci series up to 10 terms.

10
 Practical 7

Write a program to find the sum of all even numbers between 1 to 100.

11
 Practical 8

Write a program to print reverse of entered number.

12
 Practical 9

Write a program to convert entered string into Upper case.

Practical 10

Write a program in java to count vowels and consonant of a given string.

13
Practical 11

Write a program to enter 10 numbers in an array and find the largest element.

14
Practical 12

Write a program to print day name by using switch case.

15
 Practical 13

Write a program to find the given year is a leap year or nor.

16
 Practical 14

Write a Program to create a class Rectangle and calculate area using method and object.

17
 Practical 15

Write a program in Java to enable user to handle divide by zero exception.

18
Practical 1: Create a database Company, show the list of databases and select Company database.

19
Solution :

Practical 2: Create table Employee(Empid int(4) primary key, Ename

varchar(15) not null, dob date, designation varchar(20) , department varchar(20), Hiredate date,
salary de(8,2) check (salary>10000).

Solution :

Practical 3: Show the structure

of employee table.

Solution :

Practical 4: Insert five records in employee table.

Solution :

20
Practical 5: Display all the information of employees whose designation is NEITHER Manager nor
Salesman

Solution :

Practical 6: Display the details of all the employees whose Hiredate is after December 2020.
Solution :

Practical 7: Display all information of Clerk and Manager in descending salary wise

Practical 8: List all employees whose name has the first character ‘a’

Practical 9: Display Name and Salary of those Employees whose Salary is in the range 15000 and 28000
( both are inclusive).

21
Practical 10: Display average Salary, highest Salary and total no. of Employees for each department.

Practical 11: Increase the salary of 'Clerk' by 5% salary and verify the update d rows.

Practical 12: Add a new column named Address.

22
Practical 13: drop the column address.

Practical 14: Display ename, designation, salary and Hiredate of 'Clerk ' whose Salary is below 28000.

Practical 15: Display unique designation.

23