Sail E0 Webinar

MCQs

Total Questions : 44 | Page 5 of 5 pages
Question 41. . A distributed database can use which of the following strategies?
  1.    Totally centralized at one location and accessed by many sites
  2.    Partially or totally replicated across sites
  3.    Partitioned into segments at different sites
  4.    All of the above
 Discuss Question
Answer: Option D. -> All of the above
Question 42. . Which of the following is a disadvantage of replication?
  1.    Reduced network traffic
  2.    If the database fails at one site, a copy can be located at another site.
  3.    Each site must have the same storage capacity.
  4.    Each transaction may proceed without coordination across the network.
 Discuss Question
Answer: Option C. -> Each site must have the same storage capacity.
Question 43. . Which of the following is not one of the stages in the evolution of distributed DBMS?
  1.    Unit of work
  2.    Remote unit of work
  3.    Distributed unit of Work
  4.    Distributed request
 Discuss Question
Answer: Option A. -> Unit of work
Question 44. . Which of the following is not one of the stages in the evolution of distributed DBMS?
  1.    Unit of work
  2.    Remote unit of work
  3.    Distributed unit of Work
  4.    Distributed request
 Discuss Question
Answer: Option A. -> Unit of work

Latest Videos

Latest Test Papers