6.2 Test

Question 1

(Business L0 6.2 Revision) - Data Types - What does the ‘Date’ data type refer to

Answer 1

Used to store a given time in a strict format (e.g. day/month/year, 05/07/2005)

Question 2

(Business L0 6.2 Revision) - Data Types - What does the ‘Integer’ data type refer to

Answer 2

These are numbers sorted as mathematical whole values

Question 3

(Business L0 6.2 Revision) - Data Types - What does the ‘Real/Float’ data type refer to

Answer 3

These are numbers sorted as mathematical fractional values

Question 4

(Business L0 6.2 Revision) - Data Types - What does the ‘Character’ data type refer to

Answer 4

Used for storing single characters (Single Alpha-Numerical Elements)

Question 5

(Business L0 6.2 Revision) - Data Types - What does the ‘String’ data type refer to

Answer 5

Used for text, data values that are made up of ordered sequences of characters, such as “hello world”

Question 6

(Business L0 6.2 Revision) - Data Types - What does the ‘Boolean’ data type refer to

Answer 6

This type is used to store True or False Values

Question 7

(Business L0 6.2 Revision) - Data Formats - What is ‘JSON’

Answer 7

JSON (JavaScript Object Notation) is a file and data format that uses human-readable text to store and transmit data objects.

Question 8

(Business L0 6.2 Revision) - Data Formats - What is ‘Fixed-Width Text File’

Answer 8

Data is contained in columns that are of a fixed width (meaning that each column contains a certain number of character positions). Data that does not fill the width of the column is padded with filler characters (spaces or zeroes).

Question 9

(Business L0 6.2 Revision) - Data Formats - What is ‘CSV’?

Answer 9

A (CSV) comma-separated values file, is an unlimited text file that uses a comma to separate values. Each line of the file is a data record. (e.g. Name, Age, Height)

Question 10

(Business L0 6.2 Revision) - Data Formats - What is ‘ASCII’

Answer 10

ASCII (American Standard Code For Information Interchange) is used for files that are plain text. ASCII files are just text. (E.g. ‘.txt’). Stores 128 characters

Question 11

(Business L0 6.2 Revision) - Data Formats - What is ‘XML’

Answer 11

The XML (The Extensible Markup Language) is a markup language that can be modified to match users needs by adding and defining building blocks or elements. You can create your own markup symbols to describe the structure of a file.

Question 12

(Business L0 6.2 Revision) - Data Analytics - What are File-Based Structures used for?

Answer 12

A (File-Based Structure/File System) is a methodology, for logically organising and storing large quantities of data so it is easy for a computer program or a human to find the files they need.

Question 13

(Business L0 6.2 Revision) - Data Analytics - What are Directory-Based Structures used for?

Answer 13

A Directory-Based Structure is a way that a computer organises data into a tree filing system.