PCA25C03J · Cycle Test 2

Database Technology

Covers units 3 & 4: Concepts of PL/SQL / Decomposition & Normalization Techniques

PART — A (4 X 5=20 Marks)

Answer Any FOUR Questions

1.
Summarize with suitable example purpose of SQL Triggers.
5mCO2BL2
2.
Write suitable SQL sub-queries and brief the concept behind it.
5mCO2BL1
3.
What is meant by SQL Procedure? Write suitable example for it.
5mCO2BL1
4.
List out and brief various data types available in PL/SQL.
5mCO3BL1
5.
How will you write the PL/SQL block structure? Write a suitable example for it.
5mCO3BL1
6.
Point out various advantages of using three-tier architecture.
5mCO4BL1

Answer ALL Questions

7.a)
Explain with suitable examples (10+ 5)
(a) SQL JOINS
(b) SQL CLAUSE
15mCO2BL2
OR
b)
Explain with suitable programming examples (8+7)
(a) PL/SQL CURSORS
(b) PL/SQL EXCEPTIONS
15mCO3BL2
8.a)
Implement various conditional statements in PL/SQL.
15mCO3BL3
OR
b)
Explain in detail various components involved in client server architecture.
15mCO4BL2