Database Management Systems

In Redo Log file, the parameter file contains a number of parameters that can be used to configure the Oracle9i instance.

This level describes what data is actually stored in the database and the relationships existing among data.

Vertical fragmentation requires the grouping of attributes into sets, which are referenced in the similar manner by applications.

Data localisation is the second layer in the query processing, responsible to localise the query's data using data distribution information.

Database block is the smallest unit of allocation in an Oracle database.

In fragmentation schema, each global relation is split into several non-overlapping portions that are called as fragments.

This component of the RMAN environment is where the server sessions spawned by the RMAN executable run.

During this phase, recovery manager determines which objects the command will access.

Here, it is possible to lock at the record level or at the file level.

The node participating in the session tree instructs all directly referenced nodes other than the commit point site to prepare the transaction.

This transaction's property requires that if a transaction is interrupted by a failure its partial results are not taken into consideration and the whole operation has to be repeated.

A flash recovery area is a file system or automatic storage management disk group which include such as files created by RESTORE and RECOVER commands, archived redo logs etc.

This component of the RMAN environment application spawn server sessions on the target database.

This feature of the RMAN describes such as the contents of the backup sets, the number and size of the input and output disk buffers etc...........

This scheme of the degree of durability provides than does two-very-safe while avoiding the problem of lost transactions.