Class 11 IP Practical
Questions Python Questions:
1) Write a Python program to enter first and last name, then display the
full name.
2) Write a Python program to add two numbers entered by user.
3) Write a Python program to calculate the perimeter of a rectangle.
4) Write a Python program to calculate the area of a given triangle.
5) Write a Python program to Calculate simple interest.
6) Write a Python program to check whether a given number is
positive, negative or zero.
7) Write a Python program to check whether a given number is even or odd.
8) Write a Python program to find the total marks, percentage and grade of
five subjects marks.
9) Write a Python program to check whether a given year is leap year or not.
10) Write a Python program to print 10 to 1 number using for loop.
11) Write a Python program to print multiplication table of any given number.
12) Write a Python program to print sum of first ten odd numbers.
13) Write a Python program to enter 5 numbers in a list then find the average
of all numbers.
14) Write a Python program to enter 5 numbers in a list then display all the
even numbers of list.
15) Write a Python program to create a dictionary and enter the name and
marks of five students.
16) Write a Python program to search an element in a list.
17) Write a Python program to print a list in reverse order without using reverse().
18) Write a Python program to count vowels in a
string. MYSQL Questions:
19) (a) To create a database
(b) To create student table with the student id, class, section, gender,
name, dob, and marks as attributes where the student id is the primary
key.
(c) To insert the details of at least 10 students in the above table.
(d)To display the entire content of table.
(e)To display Rno, Name and Marks of those students who are scoring marks
more than 50.
(f) To display Rno, Name, DOB of those students who are born between
‘2005- 01-01’ and ‘2005-12-31’ .
20) Consider the following Table named „empl‟ and Write SQL commands from
(a) to (n):
(a)Display all the records from table empl.
(b)Display EmpNo and EName of all employees from the table empl
(c) Display employee name, salary, and department number who are not
getting commission from table empl.
(d)Display employee number, name, sal*12 as Annual salary whose
commission is not
NULL from table empl.
(e)List all department numbers from table empl.
(f) List all unique department numbers from table empl.
(g)List the details of all clerks who have not been assigned department as
yet. (h)Display the details of employees whose name have only four letters.
(i) Display the details of all employee whose annual salary is between 25000
to 40000.
(j) How many job types are offered to employees?
(k) List the employees who earn more commission than their salaries.
(l) Display name, job title and salary of employee who do not have
manager. (m) Display the name of employee whose name contains „A‟ as
third letter. (n) Display the name of employee whose name contains „L‟ as
any letter.