cs712 final term solved papers by moaaz

cs712 final term solved papers

cs712 finalterm solved papers pdf

cs712 finalterm solved papers

Reply by Rana on February 26, 2017 at 7:57pm

Q1. Differentiate round robin and range partitioning using diagrams?

Q2.Explain principal of consistency and level of consistency?

Q3.Advantages and disadvantages of shared memory?

Q4.Lets there are Cust(ID, name, contact, location) table. This table horizontally fragmented to three sites like Cust1, Cust2, and Cust3.
Apply query to get customer those location=â€™Islamabadâ€™?
And make the tree graph of this query?

Q5.Termination conditions of Transactions?
Q6. Question about was query optimizer?
Q7. Question about search strategies?

Reply by bukhari on February 27, 2017 at 12:45am

Q1:

Define the consistency and reliability aspects of a Transaction?

Q2:

What are the Instruction / Transactions states?

Q3:

Write sql query as per conditions and give CNF and DNF forms?

Q4:

Fragmentation on given relation based on projects manages by an employee?

Q5:

Round Robin and Hash partitioning differences

Q6:

PAJ algorithm?

Q7:

Query Optimization components?