School &
CBSE
Logo
CENTRAL BOARD OF SECONDARY EDUCATION
School Name
Address
A TERM 2 PRACTICAL RECORD FILE IS SUBMITTED TO DEPARTMENT OF INFORMATICS PRACTICES
FOR THE PARTIAL FULLFILLMENT OF AISSCE EXAMINATION SESSION – 2021-22
SUBMITTED BY: [NAME OF STUDENT]
HOD(COMPUTER):[NAME OF SUBJECT TEACHER]
CLASS: [CLASS]
ROLL NO: [XXXXXXX]
IP PRACTICAL RECORD FILE | | Page 1
ACKNOWLEDGEMENT
I wish to express my deep sense of
gratitude and indebtedness to our learned
teacher TEACHER’S NAME , PGT COMPUTER
SCIENCE,
[SCHOOL NAME] for his invaluable help, advice
and guidance in the preparation of this project.
I am also greatly indebted to our
principal [Name of principal] and school
authorities for providing me with the facilities
and requisite laboratory conditions for making
this practical file.
I also extend my thanks to a number of
teachers ,my classmates and friends who helped
me to complete this practical file successfully.
[Name of Student]
IP PRACTICAL RECORD FILE | | Page 2
CERTIFICATE
This is to certify that [Name of
Student]
, student of Class XII, [NAME OF SCHOOL]
has completed the Term II - PRACTICAL FILE
during the academic year [SESSION] towards
partial fulfillment of credit for the Informatics
Practices practical evaluation of CBSE and
submitted satisfactory report,
as compiled in the following pages, under my
supervision.
Total number of practical certified are : 12
Internal Examiner Head of the
Department Signature Signature
External Examiner Principal
Signature Seal and Signature
IP PRACTICAL RECORD FILE | | Page 3
No. Practical Date Signature
1 Create a student table with the student id, name, and marks as
attributes where the student id is the primary key.
2 Insert the details of a new student in the above table
3 Delete the details of a student in the above table
4 Use the select command to get the details of the students
with marks more than 80
5 Find the min, max, sum, and average of the marks in a student
marks table
6 Find the total number of customers from each country in the
table (customer ID, customer Name, country) using group
by.
7 Write a SQL query to order the (student ID, marks) table
in descending order of the marks
Write a SQL query to display the marks without
8 decimal places, display the reminder after diving marks
by 3 and
display the square of marks
Write a SQL query to display names into capital letters, small
9 letters, display first 3 letters of name, display last 3 letters of
name, display the position the letter A in name
10 Remove extra spaces from left, right and both sides from
the text - " Informatics Practices Class XII "
11 Display today's date in "Date/Month/Year" format
12 Display dayname, monthname, day, dayname, day of
month, day of year for today's date
IP PRACTICAL RECORD FILE | | Page 4
1. Create a student table with the student id, name, and marks as attributes
where the student id is the primary key.
Ans.:
create table student
(studentid int(3) primary key,
name varchar(20) not null,
marks decimal(5,2));
2. Insert the details of a new student in the above table.
Table data:
IP PRACTICAL RECORD FILE | | Page 5
3. Delete the details of a student in the above
table. Ans.:
delete from student where studentid=5;
4. Use the select command to get the details of the students with marks more
than 80.
Ans.:
select * from student where marks>80;
IP PRACTICAL RECORD FILE | | Page 6
5. Find the min, max, sum, and average of the marks in a student marks table.
Ans.:
select max(marks), min(marks), sum(marks) , avg(marks)
from student;
6. Find the total number of customers from each country in the table (customer ID,
customer Name, country) using group by.
Ans.:
select country, count(customer_id) from customer group by
country;
7. Write a SQL query to order the (student ID, marks) table in descending order
of the marks.
Ans.:
select * from student order by marks desc;
8. Write a SQL query to display the marks without decimal places, display
the reminder after diving marks by 3 and display the square of marks.
Ans.:
select round(marks,0),mod(marks,3),pow(marks,2) from
student;
IP PRACTICAL RECORD FILE | | Page 7
9. Write a SQL query to display names into capital letters, small letters, display frist
3 letters of name, display last 3 letters of name, display the position the letter A in
name
Ans.:
select ucase(name), lcase(name), left(name,3),right(name,3),
instr(name,'a') from student;
10. Remove extra spaces from left, right and both sidesfrom the text - "
Informatics Practices Class XII "
Ans.:
select ltrim(" Informatics Practices Class XII ") "Left
Spaces", rtim(" Informatics Practices Class XII ") "Right
Trim", trim(" Informatics Practices Class XII ");
11. Display today's date in "Date/Month/Year"
format Ans.:
select concat(date(now()), concat("/",concat(month(now()),
concat("/",year(now())))));
IP PRACTICAL RECORD FILE | | Page 8
12 Display dayname, monthname, day, dayname, day of month, day of year for today's
date
Ans.:
select dayname(now()), monthname(now()), day(now()),
dayname(now()), dayofmonth(now()), dayofyear(now());
IP PRACTICAL RECORD FILE | | Page 9
