Trending ▼   ResFinder  

IGNOU UNIVERSITY MCA - II (SEM 4) DEC 2009 : Advanced Database Design

5 pages, 25 questions, 0 questions with responses, 0 total responses,    0    0
mca_india
   		+Fave Message
ProfileTimelineUploadsQ & A
 Home > mca_india >

Formatting page ...

II MCS-043 I MCA (Revised) r-cf) C 1 CC) CD Term-End Examination December, 2009 MCS-043 : ADVANCED DATABASE DESIGN Maximum Marks : 100 Time : 3 hours Note : Question number / is compulsory. Answer any three questions from the rest. 1. (a) Consider the following query : SELECT ENAME, PNAME FROM EMP, ASG, PROJ WHERE PROJ. TITLE = "Comp Engg" AND ASG. ENO = EMP. ENO AND ASG .PNO = PROJ.PNO Assuming that the size of EMP relation is 400 tuples, PROJ has 100tuples and ASG has 20,000 tuples. There are no indexes. Derive a query execution plan for above. Make suitable assumptions. MCS-043 1 P.T.O.

Formatting page ...

Formatting page ...

Formatting page ...

Formatting page ...

 

  Print intermediate debugging step

Show debugging info


 

Additional Info : Mca - II (sem 4) December 2009 Question Paper - Advanced Database Design (Revised Course)
Tags : mca exam papers, mca question papers, ignou mca question papers, ptu mca question papers, mca sample question paper, mca mumbai university question papers, mca exam syllabus, mca exam question paper, online mca exam papers, online mca exam preparation, mumbai university mca question papers, ignou university mca question papers  

© 2010 - 2024 ResPaper. Terms of ServiceContact Us Advertise with us

 

mca_india chat