SAVITRIBAI PHULE PUNE UNIVERSITY
MSc (Computer Application) Sem-III Practical Examination (2023 Pattern)
SUBJECT: CA 561A MJP: Lab Based on CA 560A MJ
Slip 1 Total Marks: 35
Q1. Write a JDBC program to display all the details of the Person table in proper format. (10
marks)
Q2. Write a JDBC program to insert records into the Employee table using
PreparedStatement. Accept details from the user. (20 marks)
Or
Write a JDBC program to perform a search on the Person table for all persons born in 1986.
(20 marks)
Q3. Viva (5 marks)
Slip 2 Total Marks: 35
SAVITRIBAI PHULE PUNE UNIVERSITY
MSc (Computer Application) Sem-III Practical Examination (2023 Pattern)
SUBJECT: CA 561A MJP: Lab Based on CA 560A MJ
Slip 2
Q1. Write a program to find the primary IP address of a host name passed as a parameter.
(10 marks)
Q2. Write a server program that echoes messages sent by the client until the client types
“END”. (20 marks)
Or
Write a client-server program that sends the name of a text file from client to server and
displays contents on the client machine. (20 marks)
Q3. Viva (5 marks)
SAVITRIBAI PHULE PUNE UNIVERSITY
MSc (Computer Application) Sem-III Practical Examination (2023 Pattern)
SUBJECT: CA 561A MJP: Lab Based on CA 560A MJ
Slip 3 Total Marks: 35
Q1. Write a multithreading program to display all vowels from a given string. (10 marks)
Q2. Define a thread "PrintText_Thread" to print given text n times. Create and run 3 such
threads. (20 marks)
Or
Write a Java program to calculate sum and average of 1000 integers using 10 threads. (20
marks)
Q3. Viva (5 marks)
SAVITRIBAI PHULE PUNE UNIVERSITY
MSc (Computer Application) Sem-III Practical Examination (2023 Pattern)
SUBJECT: CA 561A MJP: Lab Based on CA 560A MJ
Slip 4 Total Marks: 35
Q1. Write a servlet program to display current date and time of the server. (10 marks)
Q2. Create a servlet that greets the user based on their IP. Use Cookies to check if it’s the
user's first visit or not. (20 marks)
Or
Design a servlet to provide information about client request and server environment. (20
marks)
Q3. Viva (5 marks)
SAVITRIBAI PHULE PUNE UNIVERSITY
MSc (Computer Application) Sem-III Practical Examination (2023 Pattern)
SUBJECT: CA 561A MJP: Lab Based on CA 560A MJ
Slip 5 Total Marks: 35
Q1. Write a JSP program to display current date and time using out implicit object. (10
marks)
Q2. Create a JSP page that accepts a number and displays it in words. (20 marks)
Or
Write a JSP program to perform arithmetic operations based on radio button selection. (20
marks)
Q3. Viva (5 marks)
SAVITRIBAI PHULE PUNE UNIVERSITY
MSc (Computer Application) Sem-III Practical Examination (2023 Pattern)
SUBJECT: CA 561A MJP: Lab Based on CA 560A MJ
Slip 6 Total Marks: 35
Q1. Write a JDBC program to display number of columns and SQL types from ResultSet
using ResultSetMetaData. (10 marks)
Q2. Write a JDBC program to update number_of_students in Course table. (20 marks)
Or
Create a menu-driven JDBC program to perform operations on District table. (20 marks)
Q3. Viva (5 marks)
SAVITRIBAI PHULE PUNE UNIVERSITY
MSc (Computer Application) Sem-III Practical Examination (2023 Pattern)
SUBJECT: CA 561A MJP: Lab Based on CA 560A MJ
Slip 7 Total Marks: 35
Q1. Write a client-server program to display server machine’s date and time on client. (10
marks)
Q2. Write a program to accept a list of file names on the client and check how many exist on
the server. (20 marks)
Or
Write a simple GUI-based chat app between client and server. (20 marks)
Q3. Viva (5 marks)
SAVITRIBAI PHULE PUNE UNIVERSITY
MSc (Computer Application) Sem-III Practical Examination (2023 Pattern)
SUBJECT: CA 561A MJP: Lab Based on CA 560A MJ
Slip 8 Total Marks: 35
Q1. Write a program to simulate traffic signal using Java threads. (10 marks)
Q2. Write a program to implement the producer-consumer problem with thread
synchronization. (20 marks)
Or
Create a Java program to use 3 threads to print different messages N times each using
constructor. (20 marks)
Q3. Viva (5 marks)
SAVITRIBAI PHULE PUNE UNIVERSITY
MSc (Computer Application) Sem-III Practical Examination (2023 Pattern)
SUBJECT: CA 561A MJP: Lab Based on CA 560A MJ
Slip 9 Total Marks: 35
Q1. Write a JDBC program to perform search operation on Person table for females born
between 2000–2005. (10 marks)
Q2. Create a table User and design a complete servlet login module with HTML and
PostgreSQL integration. (20 marks)
Or
Write a servlet to greet users based on IP and cookie info. (20 marks)
Q3. Viva (5 marks)
SAVITRIBAI PHULE PUNE UNIVERSITY
MSc (Computer Application) Sem-III Practical Examination (2023 Pattern)
SUBJECT: CA 561A MJP: Lab Based on CA 560A MJ
Slip 10 Total Marks: 35
Q1. Write a JDBC program to display all countries in the West Region. (10 marks)
Q2. Write a menu-driven JDBC program to perform operations (insert, modify, delete, view,
search) on District table. (20 marks)
Or
Create a table Course and update a specific course’s student count. (20 marks)
Q3. Viva (5 marks)