Advance DB 5-6

This is a DBMS special file to keep track of database transactions.

• Audit Train

• History

• Log File

• Document

It is a collection of data in support of management decision-making process.

• Transaction Processing System

• Data Warehousing

• Data Visualization

• DBMS

These tools are used to interact with the data warehouse to obtain information.

• Program Tools

• End-user Access Tools

• Utility Tools

• Dictionary Tools

This is an area of data warehouse where you can see data about data.

• Metadata

• Storage Data

• Table

• Database

Area of warehouse where detailed and summarized data are stored.

• Backup Data

• Table

• Database

• Storage

It performs all the operations associated with the extraction and loading of data into the warehouse.

• Link Manager

• Data Manager

• Storage Manager

• Load Manager

Choose among the problem is not data warehouse problem

• Increasing Data Volumes

• Data Ownership

• Long Duration of Projects

• Complexity of Integration

Choose among the following is not the best characteristics of data warehouse

• Subject Oriented

• Intangible

• Time-variant

• Non-Volatile

Choose among the following is not the failure that can affect database processing

• Unauthorized Access

• Carelessness

• Sabotage

• Media Failures

It is the point of synchronization between the database and the transaction log file.

• Savepoint

• Checkpoint

• Releasepoint

• Syncpoint