Information Technology 4 Flashcards Preview

BEC 2014 > Information Technology 4 > Flashcards

Flashcards in Information Technology 4 Deck (17):
1

What does a processing control check?

Checks if data processing produced proper output

2

What is a hash total?

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.

3

What is a validity check?

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

4

What is a limit check?

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

5

What is a check digit?

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

6

What is a field check?

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

7

What is a Hot Site?

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

8

What is a Cold Site?

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

9

What is the most common database language?

SQL - Standard Query Language

10

What is a Data Definition Language?

Defines SQL Database

Controls SQL Tables

11

What is a Data Manipulation Language?

Queries SQL Database tables

12

What is a Data Control Language?

Controls Access to SQL Database

13

What are the characteristics of a Relational Database?

Logical structure

Uses rows and columns similar to spreadsheet

14

What are the characteristics of a Hierarchical Database?

Has various levels

Uses trees to store data

15

What are the advantages of a database?

Data is more accessible

Reduced redundancy

16

What are the disadvantages of a database?

Cost of installation

Skilled personnel required to maintain

17

What are the components of a database?

Desktop client

Application Server

Database Server

Think: Your desktop computer runs applications and saves to a database