Information Technology

Question 1

Operators

Programmers

Librarians

Answer 1

Information Technology

Question 2

Designs or purchases IT system

Responsible for flowcharts

Liaison between Users and Programmers

Note: Think IT Manager

Answer 2

Information Technology

Question 3

A Systems Administrator controls database access.

Answer 3

Information Technology

Question 4

Writes- Updates- Maintains- & Tests software- systems- and compilers

Answer 4

Information Technology

Question 5

In order to maximize internal control- a Systems Programmer should NOT have application programming duties/abilities or be an Operator on the system.

Answer 5

Information Technology

Question 6

Schedules and Monitors Jobs

Runs IT Help Desk

Answer 6

Information Technology

Question 7

For internal control purposes- they should not be a Programmer on the system.

Answer 7

Information Technology

Question 8

Include Computer Logs.

Control Group should review the logs.

Answer 8

Information Technology

Question 9

To assist with decision making.

Answer 9

Information Technology

Question 10

A type of Management Information System (MIS) that processes accounting transactions.

Answer 10

Information Technology

Question 11

Specialized for Company Executive needs

Assists with Strategy Only

No Decision-Making Capabilities

Answer 11

Information Technology

Question 12

Computer uses reasoning

Structured

No human interpretation needed

Answer 12

Information Technology

Question 13

Computer provides data

Gives Interactive Support

Human interpretation needed

Answer 13

Information Technology

Question 14

User initiates the report.

The report is created upon demand.

Answer 14

Information Technology

Question 15

Exception reports are produced when Edit Tests- Check Digits- or Self-Checking Digits identify a problem

Answer 15

Information Technology

Question 16

A type of Ad Hoc report- initiated by a user.

Answer 16

Information Technology

Question 17

The User develops and executes their own application.

Answer 17

Information Technology

Question 18

E-commerce makes business transactions easier.

Answer 18

Information Technology

Question 19

Compromised data or theft.

Less paper trail for auditors.

Answer 19

Information Technology

Question 20

Uses globally-accepted standards

Efficient

Answer 20

Information Technology

Question 21

A file server stores shared programs and documents.

Answer 21

Information Technology

Question 22

Located on a File Server- a Database allows users to share documents.

Answer 22

Information Technology

Question 23

It connects computers in close proximity.

Answer 23

Information Technology

Question 24

It connects computers that are far apart.

Answer 24

Information Technology

Question 25

Privately-owned Network Serves as 3rd Party Between 2 Companies Routes EDI Transactions Accepts wide range of Protocols Very Costly

Answer 25

Information Technology

Question 26

Prevents unauthorized access to a network.

Answer 26

Information Technology

Question 27

Takes over a computer Needs a host program to run

Answer 27

Information Technology

Question 28

Takes over multiple computers Doesn't need a host program to run

Answer 28

Information Technology

Question 29

They prevent and detect hardware errors.

Answer 29

Information Technology

Question 30

Random Access Memory. Internal memory in the computer used during immediate processing.

Answer 30

Information Technology

Question 31

Computer Processing Unit It processes commands within a computer.

Answer 31

Information Technology

Question 32

It schedules and allocates system resources.

Answer 32

Information Technology

Question 33

Keyboard Mouse Scanner Magnetic Ink Reader Magnetic Tape Reader EDI Point of Sale Scanner

Answer 33

Information Technology

Question 34

Speakers Monitors Printers

Answer 34

Information Technology

Question 35

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

Answer 35

Information Technology

Question 36

Random Access - Finds data in random spots Faster data retrieval Uses Boundary Protection for data

Answer 36

Information Technology

Question 37

Connects one network to another Note: the Internet is connected by Gateways

Answer 37

Information Technology

Question 38

A control that detects internal data errors. A bit is added to each character- it checks to see if a bit was lost.

Answer 38

Information Technology

Question 39

Transmitted data is returned to the sender for verification (it echoes back to the sender)

Answer 39

Information Technology

Question 40

It authorizes program changes and approves program test results.

Answer 40

Information Technology

Question 41

Software that controls access to IT systems. Note: Don't confuse this with anti-virus software

Answer 41

Information Technology

Question 42

It confirms a message has not been altered.

Answer 42

Information Technology

Question 43

PDA/Smartphone/Tablet Microcomputer - PC- Laptop (cost-effective) Minicomputer - Like a Mainframe- but smaller Mainframe - Large computer with terminals attached Supercomputer - Very powerful and very big

Answer 43

Information Technology

Question 44

Bit - 1 (on) and 0 (off) Byte - 8 bits to a byte/character Field - group of related characters/bytes (i.e. Name- Zip Code- Serial #) Record - Group of related fields (i.e. Member name- address- phone number) File - Group of related records (i.e. Membership directory)

Answer 44

Information Technology

Question 45

Determine language used for a specific computer- on a computer-to-computer basis

Answer 45

Information Technology

Question 46

Programs written in base computer language- not similar to English.

Answer 46

Information Technology

Question 47

They are written in a language close to English.

Answer 47

Information Technology

Question 48

Takes Source language (English) and converts to Object (Computer) Language

Answer 48

Information Technology

Question 49

It uses a Data Warehouse to support management decision making.

Answer 49

Information Technology

Question 50

Using artificial intelligence and pattern recognition to analyze data stores within a Data Warehouse.

Answer 50

Information Technology

Question 51

To process a company's routine transactions.

Answer 51

Information Technology

Question 52

Data held- updates multiple files all at once Leaves a better audit trail Uses Grandfather-Father-Son backup (3 levels of backup kept in 3 locations)

Answer 52

Information Technology

Question 53

Checks to see if output data is valid- distributed and used in an authorized manner.

Answer 53

Information Technology

Question 54

Checks if data processing produced proper output

Answer 54

Information Technology

Question 55

An input control number- a meaningless sum of values included in the input. Example would be summing a list of SSNs to make sure the data is the same once entered as it was prior to input into the system.

Answer 55

Information Technology

Question 56

Checks to see if data in existing tables or files belongs in the set For example- is there a # in an alpha-only field or a letter in a numeric-only field

Answer 56

Information Technology

Question 57

Checks to see if numbers surpass a certain limit- i.e. in an age field is the number greater than 110.

Answer 57

Information Technology

Question 58

An input control that adds an identification number to a set of digits - usually at the end

Answer 58

Information Technology

Question 59

An input check that prevents invalid characters- i.e. checks for alphabetic letters in a SSN field

Answer 59

Information Technology

Question 60

A disaster recovery system where if the main system goes down- a Hot Site is ready to take over immediately.

Answer 60

Information Technology

Question 61

If a main system goes down- a Cold Site will take time to get set up and running.

Answer 61

Information Technology

Question 62

SQL - Standard Query Language

Answer 62

Information Technology

Question 63

Defines SQL Database Controls SQL Tables

Answer 63

Information Technology

Question 64

Queries SQL Database tables

Answer 64

Information Technology

Question 65

Controls Access to SQL Database

Answer 65

Information Technology

Question 66

Logical structure Uses rows and columns similar to spreadsheet

Answer 66

Information Technology

Question 67

Has various levels Uses trees to store data

Answer 67

Information Technology

Question 68

Data is more accessible Reduced redundancy

Answer 68

Information Technology

Question 69

Cost of installation Skilled personnel required to maintain

Answer 69

Information Technology

Question 70

Desktop client Application Server Database Server Think: Your desktop computer runs applications and saves to a database

Answer 70

Information Technology