Data Software

Question 1

What is Data Probability?

Answer 1

Ability to move and transfer files easily between different computer systems without the need to re-create

Question 2

What is Data Compression?

Answer 2

Converting a file to a compressed format

Question 3

Advantages of Data Compression

Answer 3

• Quality maintained
• Reduced file size
• Fast internet use

Question 4

What are the common compressed Image/Graphic files?

Answer 4

JPEG and Gif

Question 5

What are the common compressed files for Text?

Answer 5

• CSV (Comma Separated Value)
• RTF (Rich Text Format)
• ASCII (American STANDARD Code for Information Interchange)

Question 6

What is CSV?

Answer 6

Data/fields separated by commas, first line field names and other lines.
It is highly portable e.g transfer between spreadsheet&database

Question 7

What is RTF?

Answer 7

It is highly portable and saves letters, numbers and simple formatting. It can transfer between different email or word processing programs

Question 8

What is ASCII?

Answer 8

Highly portable, used to transfer between different word processing programs. It saves letters, numbers and NOT simple formatting

Question 9

What are the common compressed video files?

Answer 9

MPEG4, MP4

Question 10

What are the common compression of Audio files?

Answer 10

MP3, WAV, MIDI (Musical Instrument Digital Interface)

Question 11

What is PDF?

Answer 11

Portable Document Format

A portable file that is a read only document. Highly portable, uses Adobe Reader

Question 12

Advantage of PDF

Answer 12

• Free to download

Question 13

What is Winzip Compression?

Answer 13

Zipping files for email or internet transfer

Question 14

What is Data Capture and its types?

Answer 14

Can be paper or screen based

• Paper - hard copy
• Screen - soft copy

Question 15

Importance of Paper based form design

Answer 15

Very relevant as it allows a quick transfer to a computer

Question 16

What is the purpose of Validation checking?

Answer 16

To ensure that the data entered is sensible

Question 17

What is the purpose of Verification checking?

Answer 17

To ensure if data is accurate

Question 18

What is a Database Software?

Answer 18

A program that stores data in tables using relationships

Question 19

What is an Input Mask?

Answer 19

Where data must be entered in a certain format

Question 20

What is Validation Rules?

Answer 20

Rule that checks the data entered

Question 21

What are Forms?

Answer 21

On screen data capture for updating in tables

Question 22

What is a report?

Answer 22

Query results that are presented in a table format. It can include graphics to enhance the report, calculations

Question 23

What is Queries?

Answer 23

Used in a criteria to find records

Question 24

What is a Flat File?

Answer 24

Only contains One table with no relationships included

Question 25

What are the problems using a Flat File?

Answer 25

• Data Redundancy - Flat file data is repeated unnecessarily, therefore it causes error-prone and slows down searching
• Data Integrity - data error-prone therefore data might be inaccurate or unreliable

Question 26

What is a Relational Database?

Answer 26

More than one table is included. These tables are linked using key fields

Question 27

Advantages of Relational Database

Answer 27

• Since tables are linked together with key fields, it helps avoid data redundancy and ensures good integrity
• Makes searching and sorting quicker
• Data is stored centrally - easier to keep secure