Database Management Systems

This is a Java tool that provides a database programming interface for Java programs.

MIS (Management Information Systems) handles structured, routine decisions using predefined reports and data - it's NOT designed for unstructured problems. DSS (Decision Support Systems) specifically addresses unstructured decisions through analytical models, what-if analysis, and specialized databases. Statement 2 correctly describes DSS architecture.

The ProDom database contains protein domain families generated from the UniProtKB database by automated sequence comparisons.

Correct answer. Secondary databases contain results from the analysis of sequences in the primary databases. Examples of secondary databases are PROSITE and Pfam.

Correct answer. The Biological General Repository for Interaction Datasets (BioGRID) is a curated biological database of protein-protein and genetic interactions.

Correct answer. TreeFam is a database of evolutionary trees of animal genes which aims at developing a curated resource that gives reliable information about ortholog and paralog assignments, and evolutionary history of various gene families.

A data warehouse is a centralized repository that stores all information collected during database development, designed for query, analysis, and reporting. A repository typically stores metadata, RAD is a methodology, and CASE is a category of development tools.

End-user query tools provide graphical interfaces or wizards that allow data analysts to construct database queries and retrieve data without writing raw SQL code. Data extraction and data stores are backend processes, not user-facing tools.

Field names are the identifiers that describe what each database field represents. While 'Field definitions' would be more comprehensive, 'Field names' is the most appropriate answer among the given choices as it directly addresses what fields are called.

Data inconsistency occurs when the same data exists in multiple locations and only some of those locations are updated during a change. This is a common problem in poorly designed databases that lack proper normalization or update mechanisms.

SQL (Structured Query Language) is the standard programming language that relational database management systems use to perform their database tasks including querying, updating, and managing data. QBE is an alternative query interface, OLAP is for analytical processing, and OLTP refers to transaction processing systems.

The primary key in a database table serves to uniquely identify each record/row. It ensures that no two records have the same value in the primary key column, enabling unambiguous identification and retrieval of specific records.

A database management system (DBMS) is a software system used to create, maintain and provide controlled access to a database.

A data dictionary (or metadata repository) is a centralized repository that stores comprehensive descriptions of data elements including names, data types, lengths, constraints, and relationships. Unlike data tables (which store actual data), data records (rows), or data fields (individual cells), the data dictionary stores metadata about the database structure itself.

The four key characteristics of data warehouses are: subject-oriented (organized by subject), integrated (consistent data from multiple sources), time-variant (historical perspective), and NON-VOLATILE (not updateable). Data warehouses are designed for read-heavy analytical queries, not transactional updates. Updateable is the characteristic that does NOT apply to traditional data warehouses.