Distributed Databases Some of the columns of a relation are at different sites is which of the following? Vertical Partitioning Horizontal and Vertical Partitioning Horizontal Partitioning Data Replication Vertical Partitioning Horizontal and Vertical Partitioning Horizontal Partitioning Data Replication ANSWER DOWNLOAD EXAMIANS APP
Distributed Databases A distributed database can use which of the following strategies? Partially or totally replicated across sites All of these Totally centralized at one location and accessed by many sites Partitioned into segments at different sites Partially or totally replicated across sites All of these Totally centralized at one location and accessed by many sites Partitioned into segments at different sites ANSWER DOWNLOAD EXAMIANS APP
Distributed Databases Storing a separate copy of the database at multiple locations is which of the following? Horizontal and Vertical Partitioning Horizontal Partitioning Data Replication Vertical Partitioning Horizontal and Vertical Partitioning Horizontal Partitioning Data Replication Vertical 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 Data replication is favored where most process requests are read-only and where the data are relatively static. True False True False ANSWER DOWNLOAD EXAMIANS APP
Distributed Databases Location transparency allows for which of the following? 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 All of these ANSWER DOWNLOAD EXAMIANS APP