Download Model question papers & previous years 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



Course: M Tech Automobile   University/board: Periyar University





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.





Return to question paper search

Next Question Paper: JNTU- H Non Conventional Energy Sources previous papers

Previous Question Paper: B.Sc(IT)/B.Sc-IT-LE(Visual Basic)

Related Question Papers:


  • Visual Programming


  • Mathamatics -1


  • System Analysis And Design


  • B.Sc (CS) /B.Sc (IS) /B.C.A - Operating System


  • B.a. (english ca) degree examination, november/december 2009. first semester grammar and usage


  • Categories


    Submit Previous Years University Question Papers 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.


    Looking for University or College admissions in India for 2019 - 2020 academic year?

    APPLY NOW
    Top Contributors
    TodayLast 7 Daysmore...

    Awards & Gifts
     
    SpiderWorks Technologies Pvt Ltd, Kochi - India. © All Rights Reserved.