Database Management Systems

A thesaurus is a controlled vocabulary tool used in information retrieval to organize terms and show relationships between concepts.

PRECIS (Preserved Context Indexing System) is a pre-coordinate indexing system developed by Derek Austin for the British National Bibliography.

KWIC (Keyword-in-Context) indexing is a computer-based system that generates index entries by permuting the words in the title of a document.

Rollback is used to recover from transaction failure. We make savepoints, like checkpoints to save our transactions.

 For every functional dependency, X->Y in a set F of functional dependencies are over. Unfortunately, BCNF is not dependency preserving. Dependency preserving is not a condition for BCNF decomposition.

 A transaction can never be partially aborted or partially commited or partially terminated.

The ANSI/SPARC is a three level architecture. This shows that a data model can be an external model (or view), a conceptual model, or a physical model. This is not the only way to look at data models, but it is an useful way, particularly when comparing models.

 A data type as used in a typical relational database might be the set of integers. The popularity of the network data model coincided with the popularity of the hierarchical data model.Thus, the Network model uses SET .

 Data aggregation is when the data is accrued, possibly from various sources.

View is like a window to the table in the database or of the database, through which we can see the database. VIEW is a command to make a view of some essential attributes or columns of a database or table, so it is also called a sub-schema.

Versioning involves recording and managing changes to a multi-user GEO database by creating a 'version' of the database—an alternative, independent, persistent view of the database that does not involve in creating a copy of the data and supports multiple concurrent.

System failures are detected by transaction manager. They also maintain the state of the base prior to failure.

PSIBLAST is a statistically driven search method that finds regions of similarity between your query sequence and database sequences and produces gapped alignments of those regions. Within these aligned regions, the calculated score is a level higher than you would normally expect.

Yes, it is the correct answer. InterPro is an integrated pattern database designed to unify multiple databases for protein domains and functional sites. The database integrates information from PROSITE, Pfam, PRINTS, ProDom and SMART databases. The sequence patterns from the five databases are further processed. Only overlapping motifs and domains in a protein sequence derived by all five databases are included.

Yes this is the correct answer.