Revised 4 - Information Technology Flashcards
Which IT personnel roles should always be segregated?
Operators Programmers Librarians
If it is not possible to segregate duties in an IT System- what actions should be taken to compensate for internal control purposes?
Include Computer Logs. Control Group should review the logs.
What is RAM?
Random Access Memory.
Internal memory in the computer used during immediate processing.
What is Job Control Language?
It schedules and allocates system resources.
What are the characteristics of Magnetic Tape storage?
Sequential Access - Sorts data in order
Slower data retrieval
Header Label prevents Operator error by loading wrong tape
External Labels prevent accidental destruction by operator
What are the characteristics of Magnetic Disks?
Random Access - Finds data in random spots
Faster data retrieval
Uses Boundary Protection for data
What are Parity Checks?
A control that detects internal data errors.
A bit is added to each character- it checks to see if a bit was lost.
What are the units of computer data from smallest to largest?
Bit - 1 (on) and 0 (off) Byte - 8 bits to a byte/character Field - group of related characters/bytes (Name, Zip Code, Serial #) Record - Group of related fields (Member name, address, phone number) File - Group of related records (Membership directory)
What is the duty of a design engineer?
Determine language used for a specific computer- on a computer-to-computer basis
What are object programs?
Programs written in base computer language- not similar to English.
How can source programs be recognized?
They are written in a language close to English.
What is the purpose of a Compiler?
Takes Source language (English) and converts to Object (Computer) Language
How does Online Analytical Processing work?
It uses a Data Warehouse to support management decision making.
What is the most common database language?
SQL - Structured Query Language
What is a Data Definition Language?
Defines SQL Database; Controls SQL Tables
