Database Management Systems

A schema has a one-to-one correspondence with a user account in the Oracle database.

This memory component of the SGA consists of blocks that hold data dictionary information read in from the data files.

These files are used to recover changed data that was in memory at the time of a crash.

This object in distributed database is a set of tables and views that are used as read-only reference about the database.

This option in Startup command of oracle starts up the database using the static non-default parameter file.

This file in oracle database is present in multiple copies in the database on separate disks because if any one of the control files is unavailable or deleted, the database shuts down.

This type of schema in the reference architecture for distributed database defines the mapping between the global relations and fragments.

This is the logical structure that can classify or group database objects.

This phase in database design process is the one in which we design the specifications for the stored database in terms of physical storage structures, record placement and indexes.

This activity in database application system life cycle comprises the process of specifying the conceptual, external and internal database definition.

This measure of database system allows the same data to be used for multiple applications with each application having its own view of the data.

This background process resolves distributed transactions that are pending due to a network or system failure in a distributed database.

This segment in oracle is created by oracle for use by SQL statements that need a temporary work area.

This component of data block in oracle uses the bulk of the space in the data block.

This characteristic in the database design phase specifies that the model should have a small number of basic concepts that are distinct and non-overlapping in meaning.