My Profile
Active Members
TodayLast 7 Days
more...
Awards & Gifts
Online Exams
Fresher Jobs
Our fresher job section is exclusively for fresh graduates! Find jobs for freshers in major Indian
cities including Bangalore, Chennai, Hyderabad, Pune or Kochi
Resources
Find educational articles, blogs, discussion threads and other resources.
Colleges
Find details about any college in India or search for courses.
|
Download Model question papers & previous years question papers
|
Posted By: rajaram Member Level: Bronze Posted Date: 11 Sep 2007
|
2006 Bharathiar University M.C.A RELATIONAL DATABASE MANAGEMENT SYSTEM Question paper
|
|
|
1227 [05 MCA 17]
(For the candidates admitted from 2005 onwards)
M.C.A. DEGREE EXAMINATION, APRIL 2006.
Second Semester
RELATIONAL DATABASE MANAGEMENT SYSTEM
Time : Three hours Maximum : 75 marks
Answer ALL questions.
SECTION A---(10 * 1 =10 marks)
1.) What do you mean by the degree of a relation?
2.) What is logical data independence?
3.) What is a single-valued attribute? Give example.
4.) What is an atom?
5.) What is a trigger?
6.) What is a null?
7.) What is a many-to-may relationship? Give example.
8.) What is a time out?
9.) What do you mean by " Inheritance "?
SECTION B---(5 * 3 =15 marks)
11.) (a) Why do we neeed a DBMS?
Or
(b) What are the three characterstics of the relational data model?
12.) (a) How does tuple relational calculus differ from domain relational calculaus?
Or
(b) How are views different from base tables?
13.) (a) How are rows grouped, based on some criteria? Give examples.
Or
(b) How are duplicates eliminates from the UNION result set?
14.) (a) What is an inseration anomaly? Give example.
Or
(b) What are the different dimensions of security?
15.) (a) What are the disadvantages of distributed database systems?
Or
(b) What is synchronization and why is it necessary?
SECTION C---(5 * 10 =50 marks)
16.) (a) Compare and contrast in between file systems and database management systems.
Or
(b) Illustrate the conceptual database design with the ER model.
17.) (a) Illestrate the procedure to convert E-R Diagram to Rleational model with a suitable example.
Or
(b) Expalin the various operations involved in Relational algebra with examples.
18.) (a) Write the general syntax of complete SELECT statement and explain each option with suitable example.
Or
(b) What do you mean concurrency control? Explain the various concurrency control mechanisms based on locking.
19.) (a) Expalin the schema refinement process in database design.
Or
(b) Descripe about the access control of database .
20.) (a) Explain the distributed DBMS architecture.
Or
(b) Illustrate parallel query optimization process.
Return to question paper search
|
|
|
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.
|
Watch TV Channels
Watch Asianet TV onlineKairali TV in InternetSurya TV onlineAmritha TV Channel
|