XIICS Practical List
XIICS Practical List
4.
5.
6.
7.
8.
9.
Section: ___
Program Description
Write a program to input two numbers m and n and display first m multiples
of n.
Write a menu driven program to calculate the TSA and volume of a cube,
cuboid, or cylinder depending upon users choice.
Write a program to read a string and print out the following :
1) No. of capital alphabets,
2) No. of small alphabets,
3) No. of non-alphabets
Write a program to read a string and print it after replacing each of its capital
alphabets by the corresponding small alphabet and each small alphabet by its
corresponding capital alphabet.
Write a function to accept an array and its size as argument and write code
to remove all duplicate elements of the array. Place value 0 at the end . Write
main to call this function .
Write a function to accept two dimensional array , row size and column size
as argument and display the row sum and column sum. Also write main to
invoke this function .
Write a program to input elements in a 2D array and then display the sum of
main diagonal elements of this array.
Write a function to check whether a given string is palindrome or not.
A class STUDENT has 3 data members:
Name, Roll Number, Marks of 5 subjects, Stream
and member functions to input and display data. It also has a function
member to assign stream on the basis of the table given below:
Average Marks Stream
96% or more Computer Science
91% - 95%
Electronics
86% - 90%
Mechanical
81% - 85%
Electrical
75% - 80%
Chemical
71% - 75%
Civil
Declare a structure STUDENT and define the member functions.
Write a program to define a structure STUDENT and input the marks of n
(<=20) students and for each student allot the stream. (Dont use any array).
#1/9
Date
Sig
n.
10.
11.
12.
13.
14.
15.
#2/9
16.
Write a program to input a text file name, read the contents of the file and
create a new file named COPY.TXT, which shall contain only those words from
the original file which dont start with an uppercase vowel (i.e., with A, E, I,
O, U). For example, if the original file contains
The First Step To Getting The Things You Want Out Of Life is
This: Decide What You Want. Ben Stein
Then the text file COPY.TXT shall contain
The First Step To Getting The Things You Want Life is This:
Decide What You Want. Ben Stein
17.
18.
Write an interactive C++ program to open a text file and then display the
following:
1) Frequency table of all the alphabetic characters present in the file.
2) Number of numeric characters present in the file.
Create a text file (w/o using any C++ program) containing the names of
students and their marks in the following format:
Ajay 350
Vijay 340
19.
20.
where name and marks are separated by either a space or a tab and end of
line is a record separator. Write a program to read this file and display the
records
in
two
columns
name
and
marks.
Within the name column, the students names are to be left justified and
marks are to be right justified in the marks column.
Declare a structure telerec in C++, containing name (20 characters) and
telephone number. Write a program to maintain a file of telephone records.
The program should allow the following functions on the file:
1) To append records in the file.
2) Display the name for a given telephone number. If the telephone number
does not exist then display error message record not found.
3) Display the telephone number(s) for a given name. If the name does not
exist then display error message record not found.
A blood bank maintains a data file that contains the following information for
every donor: Name, Date of Birth, Telephone number, Blood group. Write a
program in C++ to do the following:
1) Given a blood group, display name, date of birth and phone number of all
the persons of the given blood group.
2) Append records in the file.
3) Input a telephone number and modify the corresponding record.
#3/9
21.
22.
Create two payroll files COMP1.DAT and COMP2.DAT. Each of the files should
have the following fields:
EmpNo : Integer
Name : A string of 20 characters
Salary : A floating point number.
Both the files should be created in the increasing order of the EmpNo. Your
program should then merge the two files and obtain a third file
NEWCOMP.DAT. The program should also display the data from all the three
files.
Do not use arrays for merging and sorting of the files. You can assume that
the EmpNo are unique.
Write a menu driven program in C++ to perform the following functions on a
binary file BOOK.DAT containing objects of the following class:
class Book
{
int BookNo;
char Book_name[20];
public:
// function to enter book details
void enterdetails();
//function to display Book details
void showdetails();
//function to return Book_no
int Rbook_no() {return Book_no;}
//function to return Book_name
int Rbook_name() {return Book_name;}
};
23.
24.
1.
2.
3.
4.
Append Records
Modify a record for a given book no.
Delete a record with a given book no.
Search for a record with a given Book name
5.
Display a sorted list of records (sort on Book No.)
6.
Display a sorted list of records (Sort on Book Name)
Write a program that reads a list of numbers from the user and places them
in an array of type float. Once the numbers are stored in the array, the
program should find their average and print it along with the list of numbers.
Use pointer notation wherever possible.
Write a program to create a linked list in which each node contains the
roll number and marks for a student of a class. Then display a list of all
those students whose marks are above 50.
#4/9
25.
26.
27.
28.
29.
30.
31.
32.
33.
Write a function in C++ which accepts an integer array and its size as
arguments/parameters and assigns the elements into a two-dimensional
array of integers in the following format:
If the array is 1, 2, 3, 4, 5, 6 If the array is 1, 2, 3
The resultant 2-D array is:
The resultant 2-D array is:
123456
123
123450
120
123400
100
123000
120000
100000
Write a program to input two matrices, find their sum, difference, or product
depending upon users choice, and then display the resultant matrix along
with the original matrices.
Write a menu driven program which allows the user to perform the following
operations on a stack (Array implementation):
1) Push
2) Pop
3) Display
Write a menu driven program which allows the user to perform the following
operations on a queue (Array implementation):
1) Insert
2) Delete
3) Display
Write a menu driven program which allows the user to perform the following
operations on a stack (Linked implementation):
1) Push
2) Pop
3) Display
Write a menu driven program which allows the user to perform the following
functions on a queue (Linked implementation):
1) Insert
2) Delete
3) Display
34.
35.
36.
37.
38.
#6/9
39.
Consider the tables given below and answer the questions that follow:
Table: Employee
No
1
2
3
4
5
6
7
Name
Mukul
Kritika
Naveen
Uday
Nupur
Moksh
Shelly
Salary
30000
35000
32000
38000
32000
37000
36000
Zone
West
Centre
West
North
East
South
North
Age
28
30
40
38
26
28
26
Grade
A
A
C
B
A
Dept
10
10
20
30
20
10
30
Table: Department
Create Table
Dept DName MinSal MaxSal HOD
1. Create the table Employee.
10
Sales
25000
32000
1
2. Create the table Department.
20
Finance 30000
50000
5
Insert data in a table
30
Admin
25000
40000
7
3. Insert data in the table Employee
4. Insert data in the table Department.
Simple Select
5. Display the details of all the employees.
6. Display the Salary, Zone, and Grade of all the employees.
7. Display the records of all the employees along with their annual salaries. The
Salary column of the table contains monthly salaries of the employees.
8. Display the records of all the employees along with their annual salaries. The
Salary column of the table contains monthly salaries of the employees. The
new column should be given the name Annual Salary.
Conditional Select using Where Clause
9. Display the details of all the employees who are below 30 years of age.
10. Display the names of all the employees working in North zone.
11. Display the salaries of all the employees of department 10.
Using NULL
12. Display the details of all the employees whose Grade is NULL.
13. Display the details of all the employees whose Grade is not NULL.
Using DISTINCT Clause
14. Display the names of various zones from the table Employee. A zone name
should appear only once.
15. Display the various department numbers from the table Employee. A
department number should be displayed only once.
Using Logical Operators (NOT, AND, OR)
16. Display the details of all the employees of department 10 who are above 30
years of age.
17. Display the details of all the employees who are getting a salary of more than
35000 in the department 30.
18. Display the names and salaries of all the employees who are not working in
department 20.
19. Display the names and salaries of all the employees who are working neither
in West zone nor in Centre zone.
#7/9
20.
Display the names of all the employees who are working in department 20 or
30.
21. Display the details of all the employees whose salary is between 32000 and
38000.
22. Display the details of all the employees whose grade is between A and C.
23. Display the details of all the employees aged above 30 in West zone.
Using IN Operator
24. Display the names of all the employees who are working in department 20 or
30. (Using IN operator)
25. Display the names and salaries of all the employees who are working neither
in West zone nor in Centre zone. (Using IN operator)
Using BETWEEN Operator
26. Display the details of all the employees whose salary is between 32000 and
38000.
(Using BETWEEN operator)
27. Display the details of all the employees whose grade is between A and C.
(Using BETWEEN operator)
Using LIKE Operator
28. Display the name, salary, and age of all the employees whose names start
with M.
29. Display the name, salary, and age of all the employees whose names end with
a.
30. Display the name, salary, and age of all the employees whose names contain
a
31. Display the name, salary, and age of all the employees whose names do not
contain a
32. Display the details of all the employees whose names contain a as the second
character.
Using Aggregate functions
33. Display the sum and average of the salaries of all the employees.
34. Display the highest and the lowest salaries being paid in department 10.
35. Display the number of employees working in department 10.
Using ORDER BY clause
36. Display the details of all the employees in the ascending order of their
salaries.
37. Display the details of all the employees in the descending order of their
names.
38. Display the details of all the employees in the ascending order of their grades
and within grades in the descending order of their salaries.
Using GROUP BY clause
39. Display the total number of employees in each department.
40. Display the highest salary, lowest salary, and average salary of each zone.
41. Display the average age of employees in each department only for those
departments in which average age is more than 30.
Using UPDATE, DELETE, ALTER TABLE
42. Put the grade B for all those whose grade is NULL.
43. Increase the salary of all the employees above 30 years of age by 10%.
#8/9
44.
Delete the records of all the employees whose grade is C and salary is below
30000.
45. Delete the records of all the employees of department 10 who are above 40
years of age.
46. Add another column HireDate of type Date in the Employee table.
JOIN of two tables
47. Display the details of all the employees who work in Sales department.
48. Display the Name and Department Name of all the employees.
49. Display the names of all the employees whose salary is out of the specified
range for the corresponding department.
50. Display the name of the department and the name of the corresponding HOD
for all the departments.
#9/9