Database

Question 1

Database

Answer 1

Consists of more than one table

Question 2

Table

Answer 2

Consists of more than one record

Question 3

A key

Answer 3

Uniquely identifies records in a table

Question 4

Data verification

Answer 4

Checking data is input correctly

Question 5

Example of data verification

Answer 5

Proof reading

Question 6

Data validation what it does

Answer 6

Checks data is reasonable, sensible and within acceptable limits and if data present and correct type

Question 7

If the data validation displays an error message

Answer 7

The data has been rejected

Question 8

Five validation checks

Answer 8

Presence Check
Length check
Type check
Format check
Range check

Question 9

Presence check

Answer 9

Ensures data is present and can’t be left blank or null

Question 10

Length check

Answer 10

Correct number of characters

Question 11

Type check

Answer 11

Check that all data is entered in the correct data type

Question 12

Example of length check

Answer 12

Phone number

Question 13

Type check example

Answer 13

Numeric, text and data

Question 14

Type check example

Answer 14

Numeric, text and data

Question 15

Format check

Answer 15

Data entered matches a predetermined pattern

Question 16

Format check example

Answer 16

Postcode

Question 17

Range check

Answer 17

Data is entered within a lower and upper limit

Question 18

<

Answer 18

Less than

Question 19

<=

Answer 19

Less than or equal to

Question 20

>

Answer 20

Greater than

Question 21

> =

Answer 21

Greater than or equal to

Question 22

=

Answer 22

Equal to

Question 23

<>

Answer 23

Not equal to

Question 24

Ascending

Answer 24

Small to big

Question 25

Descending

Answer 25

Big to small

Question 26

Query criteria

Answer 26

Checks to present us with answers to our questions

Question 27

Is null

Answer 27

Checks if blank

Question 28

Isn’t null

Answer 28

Checks if data is present

Question 29

Sorting

Answer 29

How it’s been sorted

Question 30

Grouping

Answer 30

Any grouping (on what field)

Question 31

Big data

Answer 31

Large amounts of data that has potential to be mined for information

Question 32

What data to be mined

Answer 32

To identify patterns and trends Provide further insight

Question 33

3 Vs

Answer 33

Volume Variety Velocity

Question 34

Volume

Answer 34

Amount of data stored by organisations

Question 35

Volume by organisation

Answer 35

Store large amounts of data from different sources requiring large storage capacity hardware

Question 36

What is volume measured in

Answer 36

Bytes

Question 37

Variety

Answer 37

Different types of variables of data

Question 38

Variety how data is stored and examples

Answer 38

Data is stored in many formats Videos, images and not just text

Question 39

Variety how it’s structured

Answer 39

Data can be structured, semi structured or unstructured

Question 40

Velocity

Answer 40

Speed at which data can be processed

Question 41

Description of velocity

Answer 41

Due to large amounts of data there’s no need to use powerful computer to process data more quickly

Question 42

Velocity can’t be

Answer 42

Processed by normal means

Question 43

Macro

Answer 43

Allows you to automate tasks and add functionality directly to your tables Provided shortcuts for repetitive tasks

Question 44

Report

Answer 44

Data is displayed in a user friendly format and prints the results of processing

Question 45

Form

Answer 45

Used to add data to a database Collects data about customers

Question 46

String

Answer 46

Text

Question 47

Character

Answer 47

Lower and upper case alphabet

Question 48

Integer

Answer 48

Whole numbers

Question 49

Float

Answer 49

Decimal numbers

Question 50

Boolean

Answer 50

True or false