Database Management Systems

sybase

This node participating in the session tree instructs the commit point site to initiate the global commit of the transaction.

This transaction property has to be strictly followed to avoid a problem called cascading aborts.

This component of the RMAN environment contains control files, recovery meta data etc.

Here, it is possible to lock individual tuples.

This component of the RMAN environment spawn server sessions on the target database to do work of backup.

It is an automatic storage management disk group that includes RMAN backups, flashback logs etc.

This feature of the RMAN describes the level of multiplexing and deines which files are multiplexed.

The activity of providing durability of the transaction is called database recovery.

This node participating in the session tree hosts a database from which a client requests data.

Second normal form (2 NF) is depicted when a relation where the primary key contains multiple attributes and no non-key attributes should be functionally dependent on a part of the primary key.

This data type in Informix Universal Server database is used to extend an existing type through inheritance.

This object in Oracle is a group of records from one or more tables physically stored in a mixed file.

This object in the processing of high-level query has the task of producing an execution plan.

This DBMS software module processes and checks the specification of a database schema in the DDL and stores that description in the catalog.