DBMS periodically suspends all processing and synchronizes its files and journals through the use of

If the state of the database no longer reflects a real state of the world that the database is supposed to capture, then such a state is called

If an transaction is performed in a database and committed, the changes are taken to the previous state of transaction by

In SQL, the CREATE TABLESPACE is used

____ means that the data used during the execution of a transaction cannot be used by a second transaction until the first one is completed.

The Oracle RDBMS uses the ____ statement to declare a new transaction start and its properties.

The property of transaction that persists all the crashes is

Identify the characteristics of transactions

Consider money is transferred from (1) account-A to account-B and (2) account-B to account-A.

Which of the following form a transaction?

A file is organized so that the ordering of data records is the same as or close to the ordering of data entries in some index. Then that index is called________.

A clustering index is defined on the fields, which are of type________.

Which one of the following is a Stripping technique?

Optical disk technology uses

The disk platters mounted on a spindle and the heads mounted on a disk arm are together known as ___________

In magnetic disk ________ stores information on a sector magnetically as reversals of the direction of magnetization of the magnetic material.