Questions List:
Q. NUMA architecture.
Q.Define two classes of NUMA architecture
Q. Transaction replication in brief
Q: compare conservative timestamp ordering and multiversion timestamp ordering
Q. In context of query optimizer, which search strategy is better and in which condition?
Q. Design issues of object database system ?
Q: Advantage and disadvantages of shared memory?
Q. What are the principles to ensure the consistency and reliability of transaction? Level of consistency?
Q.Lets there are Cust(ID, name, contact, location) table. This table horizontally fragmented to three sites like Cust1, Cust2, and Cust3. (pg53)(pg-29)
Q: What are the Instruction / Transactions states? (pg21 q28)
PAJ algorithm?
Question Prepared:
Q. Comparison of Pessimistic and optimistic techniques.
Q. Comparison of array processing and multiprocessing with diagram.
Q. Parallel processing advantages and challenges?
Q. Architecture of parallel database system?
Q: Parallel Databases:
Q. Advantage and disadvantages of shared nothing?
Q. Define the consistency and reliability aspects of a Transaction?
Q. Replica Transactions?
Q. Transformation rules of rewriting queries?
Q. Types and Classification of Transactions?
Q. Termination conditions of Transactions?Q. Semantic and Structural heterogeneity?
Q. Schema Translation and schema integrity?
Q. Joining Techniques/what are the two methods of joining relations?
Unanswered
Q7. A query was given and any three possible executions were asked.
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?
No comments:
Post a Comment