GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Database  >  Teradata
Next Question 
 Teradata  |  Question 1 of 27    Print  
What are two examples of an OLTP environment?
è  Transactions take a matter of seconds or less.
è  Many transactions involve a small amount of data.



  
Total Answers and Comments: 4 Last Update: August 10, 2007   
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
October 17, 2005 07:45:39   #1  
Kapil D Sapra        

RE: What are two examples of an OLTP environment?

On Line Banking

On Line Reservation (Transportation like Rail Air etc.)


 
Is this answer useful? Yes | No
August 14, 2006 20:21:38   #2  
ielosta Member Since: August 2006   Contribution: 5    

RE: What are two examples of an OLTP environment?

The two expamples of OLTP are:

1- ATM.

2- POS.


 
Is this answer useful? Yes | No
November 17, 2006 07:22:23   #3  
Mushtaq Mirza        

RE: What are two examples of an OLTP environment?

hello all

Basically any ERP package cn be considered as and OLTP System.

or any system that is build to run transactions which helps the organization's to capture there day to day activities can be refered to as a OTLP system.

Thanks

Mushtaq


 
Is this answer useful? Yes | No
August 10, 2007 09:44:26   #4  
Neelima Dahi        

RE: What are two examples of an OLTP environment?

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.


 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape