Two mark questions with answers in Distributed database / Important two mark questions and answers in distributed database
Two mark questions (To know more, please click the links)
- List the fragmentation types.
- Give the different strategies used for placement of data in distributed database.
- Who is transaction coordinator?
- Define replication
- List down some advantages of DDBMSs.
- Name some disadvantages of fragmentation.
- What is Primary Horizontal fragmentation?
- List down the steps involved in Primary horizontal fragmentation.
- What is Derived horizontal fragmentation?
- Define fragmentation transparency.
- Who is the transaction coordinator in distributed transactions?
- What are the roles of transaction manager?
- List down the roles of transaction coordinator.
- What are the messages used by 2 Phase Commit protocol?
- What are the two phases of 2PC protocol?
- What is the major disadvantage of 2PC protocol?