Database Management Systems

This property of the database transaction is used to specify that once the transaction is complete then it will persist in the system despite the system failure or other problem.

It provides programmatic access to relational data from the java programming language.

In VB, this control can provide access to a specific column or a set of columns in a data source through a data control or through remote data.

This component of the RMAN environment is the database to be backed up or recovered.

A flash recovery area includes files created by RESTORE and RECOVER commands.

A transaction can lock a data item in shared mode if it is not locked at all.

Catalog database is a separate database created to hold the recovery catalog.

Here, the contents of the backup sets that define which files are multiplexed.

It is a copy of the primary database that is updated using archived logs created by the primary database.

During the execution phase, RMAN sends the remote procedure calls to the target database and monitors their progress.

Stored scripts can be associated with a single database in the catalog.

The problem with this scheme is that updates of a committed transaction may not have made it to the backup site, when the backup site takes over processing.

JDBC helps you to write java applications that manage the activity such as sending queries and updating statements to the database.

Using the JDBC API, applications can execute SQL statements, retrieve results and propagate changes back to an underlying data source.

Phrase-level recovery performs local correction on the input to repair the error.