
	Trending ▼ ICSE CBSE 10th ISC CBSE 12th CTET GATE UGC NET Vestibulares ResFinder

Pune University - FY BSc COMPUTER SCIENCE (Paper - II), April 2010

4 pages, 49 questions, 1 questions with responses, 1 total responses,

	pune_sci	+Fave Message
	Profile Timeline Uploads Q & A

Home > pune_sci >

Formatting page ...

Total No. of Questions : 5] [Total No. of Printed Pages : 4 [3718]-2 F. Y. B. Sc. (Computer Science) Examination - 2010 COMPUTER SCIENCE PAPER - II FILE ORGANISATION AND FUNDAMENTALS OF DATABASE (New 2008 Pattern) Time : 3 Hours] [Max. Marks : 80 Instructions : (1) All questions are compulsory. (2) Figures to the right indicate full marks. (3) Neat diagrams must be drawn wherever necessary. Q.1) Answer the following : (Any Ten) (1) What is Logical File ? (2) Define Fixed Length Records . (3) What is Query Optimizer ? (4) What is Referential Integrity ? (5) Define Natural Join. (6) Define Domain . (7) Define Cardinality of an Entity. (8) Define DCL . (9) [1x10=10] What is Clustering Index ? (10) Define Ordering Field or Key Field of an Ordered File. (11) Explain use of Foreign Key Constraint. (12) List any 2 design goals of Relational Database. Q.2) Answer the following : (Any Four) [5x4=20] (a) What are different types of the Database Users ? (b) Consider the relation R = (A, B, C, D, G, H, I) and set of functional dependencies defined on R, F as {A B, A C, CG H, CG I, B H} (i) (ii) [3718]-2 Compute closure of F i.e. F+ and Compute closure of Attribute Set (AG)+ 1 P.T.O.

Formatting page ...

Top Contributors
to this ResPaper
(answers/comments)

Pari parmar
(1)

Formatting page ...

Additional Info : F.Y. B.Sc. COMPUTER SCIENCE (Paper - II) : File Organisation and Fundamentals of Database (New 2008 Pattern), Pune University
Tags : fy bsc computer science question papers, fybsc computer science paper II, file Organisation, database fundamentals, 2008 Pattern, new course, pune university exam papers, university of pune question papers, pune university science, pune university courses, bsc pune university, msc pune university, pune university solved question papers, pune university model question paper, pune university paper pattern, pune university syllabus, old question papers pune university

pune_sci chat

Horizontal lines at:
Guest Horizontal lines at:
AutoRM Data:
Box geometries: