Code No: C5115 MR22 [Link]: 12.
a) Differentiate function and procedure in PL/SQL
5
with an example. 1
MALLA REDDY ENGINEERING COLLEGE 2
b) Explain about single transaction scope and
(AUTONOMOUS) 5
Maisammaguda, Dhulapally, (Post Via Kompally), Secunderabad-500100. multiple transaction scope.
M TECH II SEMESTER SUPPLEMENTARY EXAMINATIONS, SEPTEMBER-2024 13. a) Explain about Large Objects(LOBs) and
SUBJECT: DATABASE PROGRAMMING WITH PL/SQL composite data types. 5
BRANCH: CSE-CSE 2 2
b) What is a cursor? Explain about implicit cursor
Time: 3 Hours Max. Marks: 60
and explicit cursor. 5
PART-A
Answer all the Questions 10x1M=10 M OR
M BT 14. a) Explain about bulk statements in PL/SQL.
5 2
Q. No Question ar Lev CO b) What are collections? Explain its role in PL/SQL 2
5
ks el programming.
1. Give the block structure in PL/SQL. 1 1 1 15. a) Explain how to create a function with pass-by- 5
2. Define anonymous block. 1 value parameter passing mechanism. 2 3
1 1
b) Discuss about transaction scope. 5
3. List different lexical units of PL/SQL. 1 OR
1 2
16. a) Explain about Function and Procedure
4. What is the purpose of CASE statement? 1 Architecture. 5
2 2 2 3
b) Explain how to create a procedure with pass-by- 5
5. Define a transaction in the context of data base. 1 1 3 reference parameter passing mechanism.
6. a) Explain in detail about package architecture.
Write about SQL call notation. 1 4
2 3 17. b) How to manage packages in the database 5 2
7. Define a package. 1 catalog? Explain. 5
1 4 OR
8. What are serially reusable pre-compiler 18. a) In the context of packages in PL/SQL, what do
1 2 4 5
directives? you mean by validation methods? Explain with an 4
2
9. 1 example.
Define INSTEAD OF trigger. 1 5 5
b) Explain about different components in package
10. What is the purpose of LONG Data type? 1 2 5 19. a) Explain trigger architecture with a neat diagram.
PART-B b) Explain about row level triggers with an 5 2 5
Answer all the Questions 5x10M=50 M example. 5
Mar
BT
C
OR
Q. No Question Lev 20. a) Explain about statement level triggers. Give an 5
ks O
el 5
example for it. 2
11. a) Explain about basic scalar datatypes in PL/SQL.
1 b) List and explain about event attribute functions. 5
b) Differentiate user defined exceptions and 5 2 *Bloom’s Taxonomy Level (BT Level): L1-Remember, L2- Understand, L3- Apply,
dynamic user defined exceptions. 5 L4- Analyse, L5- Evaluate, L6- Create.
OR