Database Management Systems

Correct answer. JASPAR is a collection of transcription factor DNA-binding preferences, modelled as matrices.

Correct answer. Composite database: A database that amalgamates a number of primary sources, using a set of defined criteria that determine the priority of inclusion of the different sources and the level of redundancy retained. OWL is a composite database that amalgamates information from SWISS-PROT, PIR, GenBank and NRL-3D databases.

Correct answer. PRINTS and BLOCKS are secondary databases. Secondary database: A database that contains information derived from primary sequence data, typically in the form of regular expressions (patterns), fingerprints, blocks, profiles or Hidden Markov Models. PRINTS: Primary source- OWL; Stored Information - Aligned motifs (fingerprints) BLOCKS: Primary source- PROSITE/PRINTS; Stored Information - Aligned motifs (blocks)

A data dictionary contains data descriptions and defines the name, data type, and length of each field in the database. It serves as metadata repository that documents the structure and properties of data elements, unlike data tables (actual data), records (rows), or fields (individual data units).

There are seven types of keys in relational database. These are: 1.) Primary key 2.) Candidate key 3.) Super key 4.) Foreign key 5.) Alternate key 6.) Artificial key 7.) Composite key So, this is the correct answer.

This is the correct answer. The entity set that doesn’t have sufficient attributes to form a primary key and relies on another for its identification is called a weak entity set. It doesn’t have a primary key. So, this is the correct answer.

There are five types of attributes in relational database. These are: 1.) Simple attribute 2.) Composite attribute 3.) Single-valued attribute 4.) Multivalued attribute 5.) Derived attribute So, this is the correct answer.

There are 3 types of data models present in DBMS. These are: 1.) Object based data model 2.) Record based data model 3.) Physical data model So, this is the correct answer.

There are 3 types of record-based data models. These are: 1.) Hierarchical model 2.) Network model 3.) Relational model So, this is the correct choice.

Data warehouses integrate data from multiple source systems, which inherently contain different naming conventions and formats. During extraction and loading (ETL), the warehouse must handle these diverse formats before standardizing them for analysis.

Option (4) is the correct answer.

Option (4) is the correct answer.

Option (4) is the correct answer.

Option (2) is the correct answer.