Saturday, May 30, 2015

Periyar University B.Sc Computer Science Relational Database Management System 2011

Question Paper University : Periyar University
Question Paper Course: B.Sc Computer Science
Question Paper Subject: Relational Database Management System
Year in which the question paper was asked: 2011

B.SC/B.SC(IS) DEGREE EXAMINATION
NOVEMBER/DECEMBER 2011
FIFTH SEMESTER
RELATIONAL DATABASE MANAGEMENT SYSTEM
SECTION-A
1. what is database system?
2. define:entity & attribute
3. What is relational algebra?
4. Define:domain
5. What is normalization
6. How is the data in a database protected from with in a database?
7. What are the 3 parts of pl/sql block?
8. How are comments introduced in pl/sql?
9. Write the syntax of create trigger command
10. What is a package?
SECTION B
11)a.explain the 3 levels of data abstraction.
Or
B.what are the 4 different types of database system users?explain.
12)a.discuss about the set oriented relational operations.
Or
B.write a note on domain relational calculus.
13) a.what do you mean by a deletion anomaly?give 1 example
Or
B.what are the basic data security requirements?explain
14) a.what are the data types supported by pl/sql?give examples
Or
B.how to create and use explicit cursors?explain.
15)a.what are the composite types available in pl/sql?give examples.
Or
B.compare procedure and functions
SECTION-C
16.what is e-r model?what are the components of e-r model?explain with examples.
17.what are the various types of sql commands?explain
18.what are the different normal forms?explain about the fourth and fifth normal forms.
19.describe the various control structures in pl/sql.
20.write a brief note an triggers in pl/sql.

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!