Database Management Systems

This is the data cleansing stage where certain information is removed, which is deemed unnecessary and may slow down queries.

This OLAP database servers analytically involves in the aggregation of data such as simple roll-ups or complex expressions, involving inter-related data.

Distributed query optimisation reduces the amount of required data transfer, when compared to transferring all the table data to the local site for processing.

In prepare phase, the system does not actually commit or roll back the transaction instead all nodes referenced in a distributed transaction is told to prepare to commit.

It is used for referential integrity between one or more tables.

The relationship between attributes is known as functional dependency.

Correct choice

If a transaction is under way, the container temporarily suspends it until the bean's transaction finishes.

It is the perspective of data in the data ware house from the viewpoint of the end user.

Here, the attributes data are scaled so as to fall within a small specified range, such as -1.0 to 1.0 or 0.0 to 1.0.

It is used to support simultaneous transaction and acts as a container for open databases.

This kind of driver is most appropriate on a corporate network, where client installation is not a major problem.

This option is correct because InterPro is an integrated pattern database that integrates information from PROSITE, Pfam, PRINTS, ProDom  and SMART databases. 

Embase (often styled EMBASE for Excerpta Medica dataBASE) is a biomedical and pharmacological database of published literature designed to support information managers and pharmacovigilance in complying with the regulatory requirements of a licensed drug.

A data mart is a repository of data gathered from operational data and other sources that are designed to serve a particular community of knowledge workers.