PM SHRI Kendriya Vidyalaya
Vikaspuri, shift-1
Computer Science (083)
PROGRAM FILE
SUBMITTED TO : SUBMITTED BY:
Mrs. Geeta Name :
PGTCS Class : XII A
KVVP (S-1) CBSE Board Roll No.:
Acknowledgement:
I, …………………………….of class XII
Section A would like to express our
Sincere gratitude to our
computer science teacher
Ms. GEETA, PGT (COMPUTER SCIENCE),
for her vital support, guidance and encouragement
without which
this project would not have come forth.
We would also like to express our gratitude to
our school KENDRIYA VIDYALAYA
VIKASPURI .
CERTIFICATE
This is to certify that, Practical on
Computer science is successfully completed by
….……………………… of
Class: XII, Division: A
CBSE Board Roll no. :………………..
for the academic year
2023-2024.
Signature:
Subject Teacher : Mrs. Geeta
Internal Examiner External
Examiner
Mrs. Geeta , PGT(CS)
Principal
Date: / /
Program-1: WAP to compute xn of given two integers x and n
Code
Output
Program-2: WAP for calculating simple interest.
Code
Output
Program-3: WAP to accept a number from the user and display
whether it is an even number or odd number.
Code:
Output
Program-4: WAP to accept percentage of a student and display its
grade accordingly.
Code
Output
Program-5: WAP to print Fibonacci series up to certain limit.
Code
Output
Program-6: WAP to display prime numbers up to a certain limit.
Code
Output
Program-7: WAP to accept a number, find and display whether it is a
Armstrong number or not.
Code
Output
Program-8: WAP to accept a number and find out whether it is a
perfect number or not.
Code
Output
Program-10: WAP to print the following pattern.
1
12
123
Code
Output
Program-11: WAP to accept a string and display whether it is a
palindrome.
Code
Output
Program-12: WAP that counts the number of alphabets and digits,
uppercase letters, lowercase letter, spaces and other chaaracters in the
string entered.
Code
Output
Program-13: WAP to accept a string(a sentence) and returns a string
having first letter of each word I capital letter.
Code
Output
Program-14: WAP to remove all even numbers from the given list.
Code
Output
Program-15: WAP to display second largest element of a given list.
Code
Output
Program-16: WAP to display cumulative elements of a given list.
For eg. List is [10,20,30,40]
Output should be [10,30,60,100]
Code
Output
Program-17: WAP to display frequencies of all elements of a list.
Code
Output
Program-18: WAP in python to display those strings which are string
with ‘A’ of given list.
Code
Output
Program-19: WAP in python to find and display the sum of all the
values which are ending with 3 from a list.
Code
Output
Program-20: WAP to shift the negative numbers to right and the
positive numbers to left so that the resultant list will look like this.
Original list: [-12,11,-13,-5,6,-7,5,-3,-6]
Output should be: [11,6,5,-6,-3,-7,-5,-13,-12]
Code
Output
Program-21: A list Num contains the following elements:
3,21,5,6,14,8,14,3
WAP to swap the content with next value divisible by 7 so that the
resultant array will look like:
3,5,21,6,8,14,3,14
Code
Output
Program-22: WAP to accept values from user and create a tuple.
Code
Output
Program-23: WAP to input total number of sections and stream name
in 11th class and display all information on the output screen.
Code
Output
Program-24: WAP to input names of ‘n’ countries and their capital
and currency, store it in a dictionary and display in tabular form. Also
search and display for a particular country.
Code
Output
1. Command for creating a database.
2. Command for using the database.
3. Command for creating a table.
4. Command for showing the structure of table.
5. Command to show tables present in database.
6. Command for inserting data into a table.
7. Command to view the content of the table.
8. Command to retrieve data.
9. Command for using keyword DISTINCT.
10. Command for using WHERE clause.
11. Command for using ORDER BY clause.
12. Command for using UPDATE.
13. Command for using ALTER ( to modify structure of table).
14. Command for using like operator.
15. Command for using aggregate functions.
16. Command for using GROUP BY.
17. Command for using HAVING clause.
18. Command for equi-join of tables.
19. Command to retrieve data from two tables.
20. Command for using group by clause in join.
21. Command for adding primary key.
22. Command to delete a column.
23. Command to remove primary key.
24. Command to increase marks.
25. Command to change data type of an existing column.
