III CSE
Sample Questions Advanced Databases
Short Questions
Q.
Unit Question
No
No
1 Define Distributed Database and Distributed Data Base Management System.
2 Define distributed processing (or distributed computing)
3 What is Fragmentation? List out the Fragmentation techniques
4 What is transparency in DDBMS? List out the various types of transparency
in DDBMS.
5 List out the distributed databases applications
Unit 1 6 State Replication .List out the advantages of Replication
7 What is a interquery and intraquery parallelism?
8 List the types of Distributed Databases.
9 List the Design issues of Distributed Databases.
Write a SQL query to find out the names ,amount of employees who worked
10 on a project for more than 12 months(EMP(ENO, ENAME, TITLE),PROJ(PNO,PNAME,
BUDGET). SAL(TITLE, AMT) ,ASG(ENO, PNO, RESP, DUR)).
1 What is Query Processor?
2 State Query Decomposition.
3 List out the phases of Query Processing
4 What is a Normalization?
5 What is a Distributed Query Processing?
Unit 2
6 What is the objective of Distributed Query Optimization?
7 List out the steps of Query Decomposition.
8 How the redundancies are eliminated?
9 What is the importance of Rewriting Step in Query Decomposition?
10 State INGRES the Algorithm
1 Define Transaction.
2 List out the states of a properties.
3 What are the properties of transaction?
4 What is a Atomicity in transaction?
5 Define a schedule.
6 What are the classifications of concurrency control?
7 What is meant by deadlock?
8 Define deadlock conditions.
9 What is wound-and-wait.
10 Define serializability
Part –B:
Long Questions:
Unit Q.
Question
No No
Define Distributed DBMS? Discuss problem areas in DDBS environment.
1
Explain the different types of Fragmentation techniques with examples.
2 What is transparency in DDBMS? Explain Layers of transparency in DDBMS.
Explain the different types of Distributed Architectures (Architectural models)
3 with examples.
What are the features of the reference architecture for distributed databases?
4 Elaborate on the Design issues of Distributed Databases.
Unit 1 5 Explain the different types of Distributed Databases with examples.
6 Discuss the advantages and disadvantages of Distributed Database
7 Explain Fragmentation with suitable examples.
8 Distinguish centralized and distributed databases.
Explain fragmentation and replication
9 What is allocation? List and explain the information requirements during
allocation.
10 Explain Client Server architecture for Distributed DBMS.
1 Discuss Relational Calculus for Query Optimization.
2 Explain the main objectives and Main Problems in Query Processing.
3 Elaborate on the important characteristics of Query Processing.
Explain the query decomposition and Data Localization with suitable examples.
4
Explain query decomposition
5 Discuss Relational Algebra for Query Optimization.
6 Explain the different phases of Query Processing.
Unit 2 7 Discuss the characteristics of Query Processing.
8 Explain the different layers of Query Processing.
Explain query optimization techniques
9 Illustrate joins and semi joins with example
Explain semi join based Algorithm
What are the steps in query optimization?
10 Discuss Query optimization algorithm –System R Algorithm
Discuss Query optimization algorithm- System R* Algorithm
Unit 3 1 Explain the different properties of the transaction.
2 Explain Conflict serializability and View Serializability with examples.
Illustrate the transaction state diagram and explain the properties of the
3
transaction
4 Explain serializability with its types.
5 Explain Concurrency Control.
6 Describe deadlock management.
7 Explain deadlock prevention techniques.
8 Explain the different types of transactions.
9 Explain prevention and avoidance in deadlock.
10 Illustrate concurrency control mechanisms in Distributed Database.