MCSL210 Practical Exam Lab | Set I, II, III, IV | Viva Question | DBMS and Java Lab | Dec-2024 Solve
My Insta id - / deeplearning4
DBMS-related (15 questions):
1. MCSL210 Write the SQL query to create a table STUDENT with fields RollNo, Name, Course, and Marks.
2. MCSL210 Insert five records into the STUDENT table.
3. MCSL210 Write a query to display all students who scored more than 70 marks.
4. MCSL210 Write an SQL query to find the maximum, minimum, and average marks from the STUDENT table.
5. MCSL210 Update the course of a student whose RollNo is 102 to "MCA".
6. MCSL210 Delete the record of a student whose marks are less than 40.
7. MCSL210 Write a query to display the names of students in alphabetical order.
8. MCSL210 Create a table EMPLOYEE with fields EmpID, EmpName, Salary, and Department.
9. MCSL210 Write a query to display employees with a salary greater than 50,000.
10. MCSL210 Write a query to display the total salary paid department-wise.
11. MCSL210 Write a query to join EMPLOYEE and DEPARTMENT tables based on DeptID.
12. MCSL210 Create a view to display employees of the "IT" department only.
13. MCSL210 Write a query to find employees who do not have any assigned department.
14. MCSL210 Write an SQL query to count the number of students enrolled in each course.
15. MCSL210 Write a query to retrieve all employee names whose salary is between 30,000 and 60,000.
Java-related (15 questions):
16. MCSL210 Write a Java program to display "Hello DBMS and Java Lab".
17. MCSL210 Write a Java program to find the factorial of a number using recursion.
18. MCSL210 Write a Java program to check whether a given number is prime or not.
19. MCSL210 Write a Java program to implement a simple calculator using switch case.
20. MCSL210 Write a Java program to print Fibonacci series up to n terms.
21. MCSL210 Write a Java program to reverse a given string.
22. MCSL210 Write a Java program to find the largest of three numbers using if-else.
23. MCSL210 Write a Java program to implement inheritance with classes Person and Student.
24. MCSL210 Write a Java program to demonstrate method overloading.
25. MCSL210 Write a Java program to demonstrate method overriding.
26. MCSL210 Write a Java program to create and handle an ArrayIndexOutOfBoundsException.
27. MCSL210 Write a Java program to read a file and display its contents.
28. MCSL210 Write a Java program to connect to a database using JDBC.
29. MCSL210 Write a Java program to insert a record into a STUDENT table using JDBC.
30. MCSL210 Write a Java program to retrieve and display all records from the EMPLOYEE table using JDBC.
#mcsl210 #mcsldbmsandjavalab #dbmsandjavalab #mcsl210question