Sunday, July 5, 2015

320 RELATIONAL DATA BASE MANAGEMENT SYSTEMS 2014 Question Paper

Sponsored Links

Annamalai University Collection of Old and Previous Years Question Papers
B.Sc. DEGREE EXAMINATION, December 2014
III Year
320 - RELATIONAL DATA BASE MANAGEMENT SYSTEMS Question Paper Dec 2014
Time: 3 hours
Maximum :100 Marks

Total No. of Pages: 01
Q.P Code : 5406
Register Number:
Name of the Candidate:
Annamalai University Question Papers Old and Previous Years
B.Sc. DEGREE EXAMINATION December 2014
(INFORMATION TECHNOLOGY)
(THIRD YEAR)
320. RELATIONAL DATA BASE MANAGEMENT SYSTEMS
(Common with Double Degree)
Time: Three hours Maximum: 100 marks
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.

Duraimani

B.E Civil Engineer Graduated from Government College of Engineering Tirunelveli in the year 2016. She has developed this website for the welfare of students community not only for students under Anna University Chennai, but for all universities located in India. That's why her website is named as www.IndianUniversityQuestionPapers.com . If you don't find any study materials that you are looking for, you may intimate her through contact page of this website to know her so that it will be useful for providing them as early as possible. You can also share your own study materials and it can be published in this website after verification and reviewing. Thank you!