Database Management Systems

This memory component of the SGA contains 'dirty' or modified blocks and clean or unused blocks.

These are the logical structures that directly refer to the database's data.

 RMAN can use image copies during RMAN restore and recover operations.

 During the execution phase, recovery manager sends the remote procedure calls to the target database, monitors their progress and collects the results.

 Data files can have certain characteristic set  to let them automatically extend  when the database runs out of space.

This physical design structure comprises one or more data files, which are physical structures with the operating system a person is using.

Data modelling is the process of modelling and formalising data requirements in an intrinsic part of the database design process.

This field in the structure of management information base defines the access that a user has to do with an object.

Perpetual system is the method where record is updated after each receipt and issue; it ensures greater accuracy. Standard valuation is the method of recording material issue at pre-determined standard price while in market value system; they are recorded at market price. In periodic inventory system, periodic record of inventory is maintained.

It only provides the periodic figures at the end of a particular period.

It is not based on physical verification. Rather book records are used. Periodic inventory system is based on physical verification.

MS-Word is a word processing application, not a database management system. Oracle, MS-Access, and FileMaker are all database software.

In the context of databases, a schema is the structural definition that outlines how data is organized and the relationships between tables.

This is a recovery technique that recovers from non-catastropic transaction failure is the one that do not physically update the database on disk, until a transaction reaches its commit point.

This operation of recovery manager signals a successful end of the transaction, so that any changes executed by the transaction can be safely committed to the database.