Operational Database

What is an operational database?

• An operational database is a database designed to support transaction-oriented applications.

• An operational database is a database primarily used for data backup.

• An operational database is a database that stores historical records.

• An operational database is a database used for data analysis only.

Operational database is also called as

• ETL

• OLAP

• OLTP

• None of these

Operational database is designed to support high volume of

• Analytical processing

• Transaction processing

• Both a and b

• None of these

What are some common examples of operational databases?

• MySQL, Oracle Database, Microsoft SQL Server, PostgreSQL, MongoDB, Redis

• Cassandra

• SQLite

• Elasticsearch

It is usually concerned with

• Historical data

• Day to day data

• Current data

• None of these

It is concerned with ____

• None of these

• Both c and d

• Subject oriented

• Process oriented

The data are updated ____

• Regularly according to need

• Rarely

• Frequently

• All of the above

OLTP stands for

• Oriented transaction processing database

• Online time period database

• Online transaction processing database

• None of these

The operational database is a source of information for ____

• Data warehouse

• Data integration

• Data mining

• All of the above

It has detailed information to run ____ activites

• Analytical activities

• Day to day business activities

• Processing activities

• None of these