Makhanlal Chaturvedi National University of Journalism and Communication 2011 B.C.A Computer Application Mahobia campus of IT, Model , -, DBMS peper - Question Paper
Friday, 25 January 2013 08:25Web
MAHOBIA CAMPUS OF info TECHNOLOGY
MODEL exam MAY - 2011
Total Marks:- 100 Class:-2BCA Date:- 4-5-2011
Minimum Marks:- 40 SUB:- DBMS Time:- three Hrs.
(UNIT-I)
Q.1 define three - level architecture proposal ? [Marks : 10]
Q.2 define strong and weak entities with example ? [Marks : 10]
(OR)
Q.1 discuss structure of DBMS ? [Marks : 10]
Q.2 define instances and schema ? [Marks : 10]
(UNIT-II)
Q.1 What attributes & discuss its kinds ? [Marks : 10]
Q.2 define functional dependencies ? [Marks : 10]
(OR)
Q.1 Write about set theory and theirs concepts ? [Marks : 10]
Q.2 Write short notes on:- (a) Topless (b) Domains
[Marks : 10]
(UNIT-III)
Q.1 discuss relational Algebra in detail ? [Marks : 10]
Q.2 Write short notes on integrity and indexing ? [Marks : 10]
(OR)
Q.1 Write short notes on:- (a) Set operation (b)Joins and their kinds
[Marks : 20]
(UNIT-IV)
Q.1 discuss data dictionary storage in detail ? [Marks : 20]
(OR)
Q.1 discuss storage and file structure ? [Marks : 20]
(UNIT-V)
Q.1 Write short notes on:- (a) Centralized system (b) Clint server
(c) Parallel system (d) Distributed system
[Marks : 20]
(OR)
Q.1 define data base system architecture in detail ? [Marks : 20]
Earning: Approval pending. |