1. A.). Explain Pl/Sql Variables and constants?
B) Write a PL/SQL code to find the factorial of a number using procedure
2. A) What is difference b/w procedure and function?
B) Write a PL/SQL code to check a given number is prime or not using procedure.
3. A). Explain about conditional statements
B) Write a PL/SQL code to check a given year is leap year or not using procedure
4. A) Explain about PL/SQL Iterative statements?
B) Write a PL/SQL program that uses function and accept empno from function and update the comm by adding Rs.500 if the sal is less than 2000 else update
comm. is 300
5. A) Explain about functions in PL/SQL? Explain the syntax in detail
B) Write a PL/SQL program to Accept a deptno from the user then Delete all the rows with that deptno using functions. Show how many rows have been deleted.
6. A) What is a cursor? Explain
B) Write a PL/SQL code to list employee along with their sal, who are either salesman or clerk and live in CHICAGO using cursor.
7. Write a PL/SQL code to create package specification and body to perform the following i) Find emp salary by passing emp no ii) Delete row by passing empno iii) Insert row by passing arguments
8. A) What is PL/SQL ? explain various sections?
B) Write a PL/SQL code to find biggest element in the given three values
9. A) What are the Exceptions in PL/SQL list at least 10 system defined exceptions
B) Write a PL/SQL code to user defined and system defined exceptions
10. A) What is a trigger? Explain in detail
B) Write a pl/sql program to track the emp table for insertion, deletion and update that uses triggers
Click here to download programs
.
MID -IMP Questions
1. Explain Object-Based Logical model?
2. Explain different components of DBMS?
3. What is data warehouse? Explain
4. What are the advantages of DBMS?
5. Difference between logical vs physical model
6. What is meant by data mining?
7. Briefly explain about database administration
8. Explain Various objects of DBMS