click below
click below
Normal Size Small Size show me how
TPS
Transaction Processing Systems in HSC IPT course
Question | Answer |
---|---|
The two main types of TPS are: | Real-time and Batch processing |
Recent developments in data security in a TPS use human characteristics, this is referred to as. | Biometrics |
Which part of the ACID test ensures that all of the steps involved in a transaction are completed successfully as a group? | Atomicity |
EFTPOS, ATMs and on-line purchases are common examples of what type of processsing? | Real-time processing |
A data check to ensure data is within the specific range and of the correct type is called | Data validation check |
What is the purpose of normalisation? | To remove redundant data from a relational database |
This processing occurs when the transaction is processed straight away, immediately after the request is made. | Real-time processing |
Wha processing occurs when transactions are collected and stored and then processed at a convenient time-later. | Batch processing |
This type of back up ensures that there are three copies (generations) of backups. | Grandfather-Father-Son backup |
This backup only copies files that have changed since the previous backup. | Incremental backup |
The process of analysing the buying behaviour or patterns of the customers and the trends in the market for market research is called: | Data mining |
What is the reliability, accuracy and correctness of data called? | Data Integrity |
What database feature is used to create data validation rules such as required fields and lists? | Data dictionary |
Which aspect of the ACID integrity test ensures that information is always backed-up? | Durability |
What type of validation: when addresses or countries are selected from a list. | List validation |
This file contains information about an organisation’s business situation. All transaction data is stored in this file | Master file |
These systems are commonly used for people who are travelling, and making a motel reservation or booking a seat on a train. | Reservation systems |
POS terminals are used by retail stores to sell goods and services. | Point-of-Sale terminals |
What application is used by organisations to store all accounting and operational records? | Database |
This file stores the transaction records of a company. The data in the transaction file is used to update the master file. | Transaction file |
A database that collects information from different data sources is refferd to as: | Data warehouse |