Distributed Databases A semijoin is which of the following? All of the attributes are sent from one site to another and then only the required rows are returned. All of the attributes are sent from one site to another and then only the required rows are returned. Only the joining attributes are sent from one site to another and then only the required rows are returned. Only the joining attributes are sent from one site to another and then all of the rows are returned. All of the attributes are sent from one site to another and then only the required rows are returned. All of the attributes are sent from one site to another and then only the required rows are returned. Only the joining attributes are sent from one site to another and then only the required rows are returned. Only the joining attributes are sent from one site to another and then all of the rows are returned. ANSWER DOWNLOAD EXAMIANS APP
Distributed Databases Which of the following is not one of the stages in the evolution of distributed DBMS? Remote unit of work Unit of work Distributed request Distributed unit of Work Remote unit of work Unit of work Distributed request Distributed unit of Work ANSWER DOWNLOAD EXAMIANS APP
Distributed Databases With failure transparency, all of the actions of a transaction are committed or none of them are committed. True False True False ANSWER DOWNLOAD EXAMIANS APP
Distributed Databases A transaction manager is which of the following? Maintains a log of transactions Maintains appropriate concurrency control Maintains before and after database images All of these Maintains a log of transactions Maintains appropriate concurrency control Maintains before and after database images All of these ANSWER DOWNLOAD EXAMIANS APP
Distributed Databases Storing a separate copy of the database at multiple locations is which of the following? Data Replication Vertical Partitioning Horizontal Partitioning Horizontal and Vertical Partitioning Data Replication Vertical Partitioning Horizontal Partitioning Horizontal and Vertical Partitioning ANSWER DOWNLOAD EXAMIANS APP
Distributed Databases Some of the columns of a relation are at different sites is which of the following? Vertical Partitioning Horizontal Partitioning Data Replication Horizontal and Vertical Partitioning Vertical Partitioning Horizontal Partitioning Data Replication Horizontal and Vertical Partitioning ANSWER DOWNLOAD EXAMIANS APP