Database Management Systems

Personal edition Oracle universal installer installs Real application clusters, but supports only a single user development and deployment environment.

Instance is the collection of memory structures and Oracle background processes that operates aganist an Oracle database.

Runtime Oracle universal installer installs networking services and support files.

Tablespace is a logical grouping of database objects, usually to facilitates security, performance, or the avalibility of database object such as tables and indexes.

Redo log files facilitate the Oracle mechanism to recover from an instance failure or a media failure.

Schema is a named group of objects associated with a particular user account, such as tables, indexes, functions and so forth.

Data files in a database contains all the information of the database save or retrive using SELECT and other DML statements.

In Oracle, data dictionary is a set of tables and views that are used as a read only reference about the database.

When database is shutdown in immediate mode, the oracle server automatically rolls back all currently active transactions.

When the database is shutdown in NORMAL mode, an instance recovery will not need to be done during the subsequent startup.

RESTRICTED SESSION option can be used if you wish to perform some kind of maintance on the database such as export and import.

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).