Distributed Databases A distributed database is which of the following? A loose collection of file that is spread to multiple locations and is interconnected by a network A loose collection of file that is limited to one location. A single logical database that is spread to multiple locations and is interconnected by a network A single logical database that is limited to one location. A loose collection of file that is spread to multiple locations and is interconnected by a network A loose collection of file that is limited to one location. A single logical database that is spread to multiple locations and is interconnected by a network A single logical database that is limited to one location. ANSWER DOWNLOAD EXAMIANS APP
Distributed Databases Synchronization for pull replication is less disruptive and occurs only when needed by each site, not when a central master site thinks it is best to update. True False True False ANSWER DOWNLOAD EXAMIANS APP
Distributed Databases An increasingly popular option for data distribution as well as for fault tolerance of any database is to store a separate copy of the database at each of two or more sites. False True False True ANSWER DOWNLOAD EXAMIANS APP
Distributed Databases Storing a separate copy of the database at multiple locations is which of the following? Vertical Partitioning Data Replication Horizontal and Vertical Partitioning Horizontal Partitioning Vertical Partitioning Data Replication Horizontal and Vertical Partitioning Horizontal Partitioning ANSWER DOWNLOAD EXAMIANS APP
Distributed Databases In a semijoin, only the joining attribute is sent from one site to another, and then only the required rows are returned. True False True False ANSWER DOWNLOAD EXAMIANS APP
Distributed Databases Location transparency allows for which of the following? All of these Programmers to treat the data as if it is at one location Users to treat the data as if it is at one location Managers to treat the data as if it is at one location All of these Programmers to treat the data as if it is at one location Users to treat the data as if it is at one location Managers to treat the data as if it is at one location ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS