TO CHECK FACTORIAL
SOURCE CODE
RESULT
TO CHECK THE SUM OF DIGITS
SOURCE CODE
RESULT
TO CHECK IF NUMBER IS ARMSTRONG
SOURCE CODE
RESULT
TO CHECK IF NUMBER IS PALINDRONE
SOURCE CODE
RESULT
Count the number of
uppercase/lowercase/vowels/spaces in
string
RESULT
REVERSE THE WORDS
RESULT
HAS ATLEAST 3 VOWELS AND 2
UPPERCASE
SOURCE CODE
RESULT
Encrypt the string by replacing every
even-index character with the succeeding
character, every odd-index character with
preceding character, every number by 7
and every special character by
RESULT
Reverse a list using with slicing
SOURCE CODE
RESULT
SHIFT THE ELEMENTS OF A LIST TO RIGHT
LEFT
SOURCE CODE
RESULT
REMOVE DUPLICATES FROM FILE
SOURCE CODE
OUTPUT
Reverse the words in a list of strings
SOURCE CODE
OUTPUT
a menu driven program to illustrate a
function of a dictionary
RESULT
TO WRITE LINES IN A TEXT FILE
SOURCE CODE
RESULT
Read the text file line by line and
display each word separated by a
#
SOURCE CODE
RESULT
WRITE 4-5 RECORD IN BINARY FILE
SOURCE CODE
RESULT
SEARCH FOR THE ROLE NUM AND
DISPLAY THE NAME IF NOT FOUND
DISPLAY
SOURCE CODE
RESULT
WRITE 4-5 RECORD IN CSV
SOURCE CODE
RESULT
SEARCH FOR A GIVEN ROLE NO.
SOURCE CODE
RESULT
2 PLAYER GAME
SOURCE CODE
RESULT
TO IMPLEMENT THE FUNCTION OF STACK
SOURCE CODE
RESULT
Create a book table
RESULT
DISPLAY ALL THE RECORDS
SOURCE CODE
RESULT
Display records based on multiple
conditions (using AND, OR, NOT in WHERE
clause)
SOURCE CODE
RESULT
AVRG PRICE MAX PRICE MIN PRICE
SOURCE CODE
RESULT
SUM OF BOOK PER GENRE
SOURCE CODE
RESULT
DETAILS OF EMPLOYEE WHO HAVE HOBBY
SPORT
SOURCE CODE
RESULT
NAME OF ELDEST EMPLOYEE
NO. OF EMPLOYEE AREA WISE
SHOW YOUNGEST EMPLOYEE FROM EACH
NATIVE PLACE
Show Sno, name, hobby and salary in
descending order of salary
Show the hobbies of those whose name
pronounces as „Abhay‟.
Show the appointment date and native
place of those whose name starts with „A‟
or ends in „d‟.
Show the salary expense with suitable
column heading of those who shall retire
after 20-jan-2006
Show an additional burden on the
company in case the salary of employees
having a hobby as sports, is increased by
10%.
Show the hobby of which there are 2 or
more employees.
Show how many employee shall retire
today if maximum length of service is 20
years.
Show those employee name and date of
birth who have served more than 17
years as on date
Show names of those who earn more than
all of the employees of Sales dept.
Show names of those who earn more than
at least one of the employees of
Marketing dept
Increase salary of the employees by 5 %
of their present salary with hobby as
Music or they have completed atleast 3
years of service
Show the maximum salary and the hobby
of employee.
Count the number of employees in each
department.
To display the maximum, minimum, sum
and average salary of each department
To display ename in lower case and job in
upper case.
To display employees name, salary and
Area of all the employees working in Agra
INSERT INTO EMPLOYEE
VALUES (130, 'RAHUL', '2000-05-15',
'Delhi', 'Music');
Insert a new column email in job table
Create a table with values of columns
empno, name, and hobby.
Erase the records of employee from job
table whose hobby is not Sports.
REMOVE TABLE EMPLOYEE