Download Model question papers & previous years question papers
|
Posted By: rajaram Member Level: Bronze Posted Date: 13 Sep 2007
|
2007 Bharathiar University M.C.A RELAATIONAL DATABASE MANAEGEMENT SYSTEM Question paper
|
|
|
4090 Q.P.Code :[5 MCA 17]
(For the candidates admitted from 2005 onwards)
M.C.A.DEGREE EXAMINATION,APRIL 2007.
Second Semester
RELATIONAL DATABASE MANAGEMENT SYSTEM
Time : Three hours Maximum : 75 marks
Answer ALL questions.
SECTION A---(10 * 1=10 marks)
1.) What is physical data independence?
2.) Define candidate key.
3.)Define cardinality of a relation.
4.) what is formula?
5.) What is DML?
6.) Define transaction.
7.) What is lossless-join?
8.) Expand DES.
9.)What is meant by pipelined parallelism?
10.) What is data skew?
SECTION B---(5 * 3=15 marks)
Answer ALL questions.
11.) (a) Compare file system versus a DBMS.
Or
(b) Write short notes on weak entities.
12.) (a) Descripe primary and foreign key constraints with suitable examples.
Or
(b) Explain briefy semantics of TRC queries.
13.) (a) What is trigger? How do you creat it ? Give an example.
Or
(b) What is schedule? What are the different types of schedules?
14.) (a) What is multivalued dependency? Give an example.
Or
(b) Write short notes on different access controls.
15.) (a) Explain briefly different types of distributed DBMS architectures.
Or
(b) What is substitution principle? Give an example.
SECTION C---(5 * 10 =50 marks)
Answer ALL questions.
16.) (a) (i) Explian different levels of abstraction in a DBMS. (6)
(ii) Compare entities versus attributes. (4)
Or
(b) Construct an E-R diagram ofr a univrsity registrar's office.The office maintance data about each class,including the instructor,the enrollment and place of the class meetings. For each student-class pair,a grade is recorded.Document that you make about the mapping constraints.
17.) (a) Explain any five relational algebra operators with suitable examples.
Or
(b) (i) Discues how do you enforce integrity constraints.
(ii) Write short notes on logical data base design.
18.) (a) (i) Descripe the specification of complex integrity constraints in SQL-92.
(ii) Explain the characteristics of transaction.
Or
(b) Discuss lock-based concurrency control in detail.
19.) (a) Explain BCNF and 3NF with suitable examples.
Or
(b) What is deadlock? Explain how do you prevent and detect it with suitable examples.
20.) (a) (i) Discuss the architecture of parallel databases.
(ii) Compare RDBMS,OODBMS and ORDBMS.
Or
(b) Explain the different between RDBMS and ORDBMS database design through examples.
___________________*************************___________________
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.