Periyar University 2011 B.Sc Computer Science Relational database management system - Question Paper

B.SC/B.SC(IS) DEGREE exam
NOVEMBER/DECEMBER 2011
5th 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 three 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?
part B
11)a.explain the three levels of data abstraction.
Or
B.what are the four various kinds 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 one example
Or
B.what are the basic data security requirements?explain
14)a.what are the data kinds supported by pl/sql?give examples
Or
B.how to create and use explicit cursors?explain.
15)a.what are the composite kinds 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 different kinds of sql commands?explain
18.what are the various normal forms?explain about the 4th and 5th normal forms.
19.describe the different control structures in pl/sql.
20.write a brief note an triggers in pl/sql.

Earning:   Approval pending.