19 FEBRUARY 2021 CURRENT AFFAIRS QUIZ

The semijoin approach saves network traffic.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

A distributed database is which of the following?

A single logical database that is limited to one location.

A single logical database that is spread to multiple locations and is interconnected by a network

A loose collection of file that is limited to one location.

A loose collection of file that is spread to multiple locations and is interconnected by a network

TRUE ANSWER : ?
YOUR ANSWER : ?

A distributed database has which of the following advantages over a centralized database?

Slow Response

Software cost

Modular growth

Software complexity

TRUE ANSWER : ?
YOUR ANSWER : ?

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

TRUE ANSWER : ?
YOUR ANSWER : ?

The purpose of timestamping is to avoid the use of locks.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

A transaction manager is which of the following?

All of these

Maintains appropriate concurrency control

Maintains before and after database images

Maintains a log of transactions

TRUE ANSWER : ?
YOUR ANSWER : ?

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 ANSWER : ?
YOUR ANSWER : ?

The cost to perform a snapshot refresh may depend on whether the snapshot is simple or complex.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

The problem of concurrency control is more complex in a distributed database.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following is not one of the stages in the evolution of distributed DBMS?

Unit of work

Distributed unit of Work

Distributed request

Remote unit of work

TRUE ANSWER : ?
YOUR ANSWER : ?