Database Management Systems

This type of issue in federated distributed database provides facilities for specification and implementation that vary from system to system.

Data integrity refers to the correctness of data in the database.

This component of transaction control statement consists of a node that hosts a database from which a client requests data.

This data model is a model in which data is represented by a collection of records and the relationships are represented by links.

Domain, in a relational data model, is defined as a set of allowed values for one or more attributes in a relation.

Tablespace names, the database identifier and name, etc., are maintained in the control file.

This memory component of the PGA contains bind information and a runtime area that is created as soon as an execute request is initiated.

This background process is used to resolve distributed transactions that are pending due to a network failure in a distributed database.

Clusters are groups one or more tables physically stored together and share common columns.

Two specific caches library cache and the data dictionary cache form this memory component of the SGA.

Each data file belongs to only one tablespace.

This memory component of the SGA is managed in a manner that free blocks are always made available for new blocks being read into memory.

The information in a rollback segment is used during database recovery to generate read-consistent database information.

When a statement is executed, Oracle looks for an identical statement/ execution plan in this memory component of the SGA.

These are created when a SQL statements needs a temporary work area to complete execution.