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 

Comments

Popular Posts

B.SC 2ND YEAR CHEMISTRY QUESTION PAPERS

PDO PREVIOUS YEAR QUESTION PAPERS

KANNADA GRAMMAR PDF.

Staff Nurse entrance exam model question paper

KSOU B.ED QUESTION PAPERS

CHILD HEALTH NURSING MODEL QUESTION PAPER- ANM

PRIMARY HEALTH CARE QUESTION PAPER

RAILWAY STAFF NURSE EXAM QUESTION PAPER

2nd YEAR GNM QUESTION PAPERS

ADARSHA Entrance Exam Question Papers with Answer Key