What are two examples of an OLTP environment?
Submitted by: Administrator# Transactions take a matter of seconds or less.
# Many transactions involve a small amount of data.
Answer-1:
On Line Banking
On Line Reservation (Transportation like Rail, Air etc.)
Answer-2:
1- ATM
2- POS
Answer-3:
OLTP is typified by a small number of rows (or records) or a few of many possible tables being accessed in a matter of seconds or less. Very little I/O
processing is required to complete the transaction. For eg.
1. This type of transaction takes place when we take out money at an ATM. Once our card is validated, a debit transaction takes place against our current
balance to reflect the amount of cash withdrawn.
2. This type of transaction also takes place when we deposit money into a checking account and the balance gets updated.
We expect these transactions to be performed quickly. They must occur in real time.
Submitted by: Administrator
# Many transactions involve a small amount of data.
Answer-1:
On Line Banking
On Line Reservation (Transportation like Rail, Air etc.)
Answer-2:
1- ATM
2- POS
Answer-3:
OLTP is typified by a small number of rows (or records) or a few of many possible tables being accessed in a matter of seconds or less. Very little I/O
processing is required to complete the transaction. For eg.
1. This type of transaction takes place when we take out money at an ATM. Once our card is validated, a debit transaction takes place against our current
balance to reflect the amount of cash withdrawn.
2. This type of transaction also takes place when we deposit money into a checking account and the balance gets updated.
We expect these transactions to be performed quickly. They must occur in real time.
Submitted by: Administrator
Read Online Teradata Job Interview Questions And Answers
Top Teradata Questions
☺ | What is stored procedure in Teradata? |
☺ | What is the difference between start schma and Fsldm? |
☺ | What are the enhanced features in Teradata V2R5 and V2R6? |
☺ | How teradata makes sure that there are no duplicate rows being inserted when its a SET table? |
☺ | What is an optimization and performance tuning and how does it really work in practical projects? |
Top Databases Programming Categories
☺ | RDBMS Interview Questions. |
☺ | SQL Interview Questions. |
☺ | SSRS Interview Questions. |
☺ | Database Administrator (DBA) Interview Questions. |
☺ | Sybase Interview Questions. |