Data

Question 1

How is a normalised floating point number represented in binary?

Answer 1

A normalised floating point number contains a mantissa and exponent, with only a sequence of 01 preceding the binary point

Question 2

What are the five steps to convert from binary to decimal floating point numbers?

Answer 2

×Find the sign of the mantissa
×Find the value of the exponent and its sign in decimal
×Move the binary point as denoted by the exponent
×Perform two’s complement conversion if the number is negative

Question 3

What is the definition of big data?

Answer 3

High volume, high velocity data with a large range

Question 4

What is unstructured data?

Answer 4

Data that cannot be stored in a traditional database

Question 5

What is first normal form?

Answer 5

All data is in atomic form and there are no many-to-many relationships

Question 6

What is second normal form?

Answer 6

The data is in 1NF and there are no partial key dependencies

Question 7

What is third normal form?

Answer 7

The data is in 2NF and there are no non-key dependencies