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

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

5 pages, 25 questions, 0 questions with responses, 0 total responses,

	mca_india	+Fave Message
	Profile Timeline Uploads Q & 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. Two-phase locking protocol uses waiting, time stamping and optimistic methods use restacting, to avoid nonserializable execution. Justify the statement. What is the difference between document type definition and XML schema ? Explain using an example. 5 What is a join dependency ? Explain with an example. When a join dependency is referred as trivial ? MCS-043 5 What are the differences between datamining and knowledge discovery in database (KDD) ? Can these two techniques be used alternatively. Justify. (f) 4 5 Consider a small institute in which students register for programmes run by the institute. A program can be a full or a part time program or both. Every student necessarily registers in at least one programme and at most three programme. Assuming suitable attributes, design an EER diagram for the same. 5 2 What are the different types of index implementations available in POST gre SQL. Explain each one of them. What are triggers and what is their use ? Explain with the help of an example. 2. (a) Why is query expressed in relational algebra preferred over query expressed in SQL in query optimization. Explain this by taking a suitable example Determine all 4NF violations for the relation schema R(X, Y, Z, W) with multivalued dependencies X > >Y and X > > Z. Decompose the relation into 4NF. 5 5 6 6 The 3-phase commit protocol increases the system's availability and doesn't allow transaction to remain blocked until a failure is repaired. Justify the statement. (d) What are cursors. Explain with an example. 3. 5 3 (a) Create an object oriented database using 10 ODL for the following scheme. Make suitable assumptions about the attributes MCS-043 3 Answer the following query using OQL list all the account of a customer whose name is 'Q' "XYZ". "A linear join help to exhibit parallelism in 4 query execution". Is the statement correct ? Justify your answer. 3 Explain the "Deferred database modification" approach of log-based recovery. 3 (d) Define Multi-Version two-phase locking. 4 P.T.O. MCS-043 5 5 What is data warehousing ? Discuss various characteristics of Data warehousing ? 5 (d) Define multimedia databases and challenges in designing them. 5 (a) Differentiate between star schema and snowflake scheme using the same example. 5 (b) Differentiate between : 5. (a) What is semi-structured data, explain with example. What is the difference between a well formed XML document and a valid XML document ? What are views and what is their significance. How views are created in SQL explain using one example. 4. 6 Data-mining queries and data base query Clustering and classification approaches in data-mining. (c) How does Oracle manage database security ? 4 (d) What are deadlocks ? How are they detected ? Explain with the help of an example. 5 -o0oMCS - 043

Formatting page ...

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

mca_india chat

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