RELATIONAL DATA BASE MANAGEMENT SYSTEMS QUESTION PAPER

B.Sc. DEGREE EXAMINATION December 2014 (INFORMATION TECHNOLOGY) (THIRD YEAR) 320. RELATIONAL DATA BASE MANAGEMENT SYSTEMS (Common with Double Degree)

SECTION – A
 Answer any EIGHT questions
(8×5 = 40)
 1. What are the types of Blocks? Explain.
2. Why Embedded SQL- Reason out?
3. How to create and use explicit cursors?
4. List and explain types of DBMS users.
5. Write a note on various exception handling statements in PL/SQL.
6. Explain about oracle data types.
7. Define Trigger. What are the uses of triggers in data base?
8. What are the object oriented programming concepts explain?
9. Write short notes on Trigger mutating tables.
10. Explain about variable and constants.
 SECTION – B
 Answer any THREE questions

(3× 20 = 60)
11. Discuss about Querying the tables with examples and also explain the
purpose of views.
12. Explain dynamic PL/SQL in details.
13. a) What are the control structures-explain?
b) BFILE
14. Explain in details about LOBs and Its uses.
15. Explain about Database security and previlege and its uses.

Click here to download Question paper

For more details click here or visit http://annamalaiuniversity.ac.in