CS712 Distributed DBMS Mid Term Paper Spring 2017 of Virtual University (VU) 

Views: 273

Replies to This Discussion

Mid-Terms Syllabus for Spring 2017 Mid Term Papers 03 June 2017 to 15 June 2017

Dear Students,
This is to inform you that midterm syllabus (Lessons 1-22) will be included in the midterm examination spring 2017. The paper will comprise of both objective type questions 

CS712 - Distributed DBMS

22 lectures will be covered in mid term exams and there will short and descriptive question in your exams.

10 Mcqs: easy
3 Questions : 5 marks
1 Question : 10 marks
Subjective Questions were:
1)Compare Star and Mesh topology
2) how to ensure the completeness of horizontal fragmentation
3) what are problems that can occur in Distributed database enviorment
4)Briefly describe Frame work for Top Down process (10 marks)

CS712 - Distributed DB

 

The database environment has all of the following components except:

  1. Users
  2. separate files
  3. database administrator
  4. database

A table or file is broken down in different parts and stored at different locations is called ______________.

  1. Data Transparency
  2. Data Independence
  3. Fragmentation
  4. Replication

The ___________ operation, denoted by " − ", allows us to find tuples that are in one relation but are not in another.

  1. Union
  2. Set-difference
  3. Difference
  4. Intersection

 

Physical or logical arrangement of network is__________

  1. Topology
  2. Routing
  3. Networking
  4. None of the mentioned

 

Database architecture can be discussed in ______________ dimensions.

  1. Two
  2. Four
  3. Three
  4. Five

 

Which term is used with distributed databases storage ?

  1. Replication
  2. Fragmentation
  3. Both Replication and Fragmentation
  4. None of the above

 

For derived horizontal fragmentation _________ inputs are required.

  1. 5
  2. 4
  3. 2
  4. 3

 

Bond energy algorithm has been designed to determine ___________.

  1. Primary key
  2. Groups
  3. Relations
  4. Tuples

The computation time of the Clustering algorithm is ______________.

  1. On3
  2. On5
  3. On2
  4. On1

 

Hybrid Fragmentation combines ________ and ___________.

  1. Derived , primary replication
  2. Full , partial distribution
  3. Horizontal , vertical fragmentation
  4. Derived, primary allocation

 

 

 

Long Questions

 

  1. What is the purpose of integrity rules? How they are enforced on the database?(5 marks)
  2. How disjointness of horizontal fragmentation is verified?(5 marks)
  3. How can we verify the properties of completeness and reconstruction of a vertical fragmentation?(5 marks)
  4. Consider the relation Faculty (facId, facName, dept, salary, rank)

Three applications access the relation through following three queries respectively:

            q1: SELECT facId, facName, rank FROM Faculty WHERE facId = VALUE

            q2: SELECT rank, salary FROM Faculty WHERE rank = VALUE

            q3: SELECT facId, facName FROM Faculty WHERE dept = VALUE

Application access frequency matrix for the three sites =

             

Assume ref l (qk) = 1 for all qk and Sl. Determine attribute affinity matrix for the above relation.(10 marks)

 

CS712 Current Mid Term Paper

1. compare between star and bus topology 
2. Write the name of software component of SQL server
3. Difference between distributed and central computing?
4. Horizontal fragmentation ki ak easy si example thi wo krni thi ....
And 10mcq's

1)Ada vantages/disadvantages/reasons of Fragmentation
2) Needs of Data Independence
3) Global infinty formula for 5 attributes
4) Difference between horizontal and vertical fragmentation



Arooj Khan said:

1)Ada vantages/disadvantages/reasons of Fragmentation
2) Needs of Data Independence
3) Global infinty formula for 5 attributes
4) Difference between horizontal and vertical fragmentation

NICE WORK

RSS

Sponsored Links

Sponsored Links

© 2019   Created by Ali Khan (Admin).   Powered by

Badges  |  Report an Issue  |  Terms of Service