Download Model question papers & previous years question papers
Submit Previous Years University Question Papers
Posted Date: 13 Nov 2011 Posted By:: swathi Member Level: Bronze Points: 5 (₹ 1)
2011 Periyar University M Tech Automobile Relational database management system Question paper
B.SC/B.SC(IS) DEGREE EXAMINATION
RELATIONAL DATABASE MANAGEMENT SYSTEM
1. what is database system?
2. define:entity & attribute
3. What is relational algebra?
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?
11)a.explain the 3 levels of data abstraction.
B.what are the 4 different types of database system users?explain.
12)a.discuss about the set oriented relational operations.
B.write a note on domain relational calculus.
13)a.what do you mean by a deletion anomaly?give 1 example
B.what are the basic data security requirements?explain
14)a.what are the data types supported by pl/sql?give examples
B.how to create and use explicit cursors?explain.
15)a.what are the composite types available in pl/sql?give examples.
B.compare procedure and functions
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.
Return to question paper search
and make money from adsense revenue sharing program
Are you preparing for a university examination? Download model question papers
and practise before you write the exam.