Chapter 7 - Organizing Big Data

Question 1

List the 2 formats that can be imported into Excel

Answer 1

1. Text data

2. Database tables

Question 2

List 4 examples of databases that can be imported into Excel

Answer 2

1. Oracle
2. Cybase
3. MySQL
4. Access

Question 3

What is an example of the text data format that can be imported into Excel?

Answer 3

Cobol

Question 4

List the 3 types of text file formats

Answer 4

1. Free format
2. Delimited
3. Fixed width

Question 5

In which text file format does the reader have to determine the text that will be included in the field?

Answer 5

The free format

Question 6

Which text file format separates the fields by a certain character?

Answer 6

The delimited format

Question 7

In which text file format is the field width determined?

Answer 7

The fixed width format

Question 8

What is a collection of records called?

Answer 8

A file

Question 9

What is one complete set of fields called?

Answer 9

A record

Question 10

What is a single piece of information called?

Answer 10

A field

Question 11

When importing data from a database what is imported into the table?

Answer 11

The file

Question 12

When importing data from a database what information is imported into the rows?

Answer 12

The records

Question 13

When importing data from a database what information is imported into the columns?

Answer 13

The fields