Home > Databases > Quizzes > Advance Data Management Technology: Distributed Databases
Advance Data Management Technology: Distributed Databases
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 13% Most missed: “____ means that the data used during the execution of a transaction cannot be us…”
Advance Data Management Technology: Distributed Databases
Time left 00:00
25 Questions

1. Product design is mainly?
2. Which of the following transparencies in distributed database design requires the end user or programmer to specify the database fragment names but need not specify where these fragments are located?
3. Identify the characteristics of transactions
4. In distributed system, each processor has its own ___________
5. Which of the following are the simple predicates which can be directly extracted from the given applications?
6. Which is a unary operation:
7. Collection of stakeholder needs is called?
8. Lower level of abstraction includes?
9. In distributed systems, link and site failure is detected by ___________
10. Which routing technique is used in a distributed system?
11. The ___________ operation, denoted by −, allows us to find tuples that are in one relation but are not in another.
12. Reliability and availability of a 'Centralized Data Allocation' method is ___________ when compared to a 'Completely Replicated Data Allocation'.
13. For select operation the ________ appear in the subscript and the ___________ argument appears in the paranthesis after the sigma.
14. Understanding Stakeholder needs are called?
15. ______________ is very much required to process a query in a distributed database.
16. Stakeholder role in analyzing needs?
17. Consider money is transferred from (1)account-A to account-B and (2) account-B to account-A. Which of the following form a transaction?
18. Confirming with stakeholder that a product design satisfies their needs and desires are called?
19. What are the most common scenarios for resolutions?
20. For the given set of simple predicates Pr, how many min-term predicates we can derive (including invalid ones). Pr = {Branch = 'Vellore', Branch = 'Chennai', Salary <=20000, Salary > 20000} Assumptions: Consider there are five different branches.
21. What are the advantages of Replication of data in Distributed database?
22. Relational Algebra is a __________ query language that takes two relations as input and produces another relation as an output of the query.
23. Network operating system runs on ___________
24. In a distributed database application, if we have very many number of read only queries than update queries then ______________ allocation technique is advantageous.
25. Transaction processing is associated with everything below except