In a Merge-Scan Join ____

question 9

Multiple Choice

In a merge-scan join ____.

• A) neither of the two join attributes has to be in sorted order or has to have an index built over it
• B) one of the two join attributes either has to be in sorted order or has to have an index built over it
• C) both of the join attributes have to be in sorted order or have to have indexes built over them
• D) the only requirement is that every row of one table is compared against every row of the other table looking for a match on the join attributes.
• E) None of the above.

---

Definitions:

Lytic Virus

A type of virulent virus that replicates inside a host cell and causes its lysis (destruction), releasing new viral particles.

Lytic Infection

A type of viral infection that results in the destruction of the infected cell and its membrane, leading to the release of new viral particles.

Phage Components

Parts or structures that make up bacteriophages, viruses that infect and replicate within bacteria.

Assembly

The process of putting together a number of parts or components to form a complete unit, often referred to in manufacturing and software development.