Take this Quiz: T Level Digital: Data and Analysis | Zestly

Question 1

Ledbury Cycles has a spreadsheet cell containing the number 428. The owner claims this is data rather than information. Why is this classification correct?

Accepted Answer

Because on its own it has no context: nothing says what was counted, when, or in what units.

Answer

Because it is a number rather than text.

Answer

Because it is stored in a spreadsheet rather than a database.

Answer

Because nobody has looked at it yet.

Question 2

Pennine Outdoors is designing a customer table and must choose the data type for the postcode field. Which type is most appropriate?

Accepted Answer

Text, because postcodes contain letters as well as digits and the spacing matters.

Answer

Integer, because postcodes should be stored as efficiently as possible.

Answer

Decimal, because some postcodes contain more than one part.

Answer

Boolean, because a postcode is either valid or invalid.

Question 3

Pennine Outdoors is creating a customer table. Which field makes the best primary key, given that it must be unique for every row and never change?

Accepted Answer

A customer number generated by the system when the record is created.

Answer

The customer's surname.

Answer

The customer's email address.

Answer

The customer's postcode.

Question 4

Wharfedale Supplies has a table where each product row repeats the full name and address of its supplier. What is the primary benefit of moving supplier details into a separate table linked by a supplier number?

Answer

Each supplier's address is stored once, so it cannot end up with two different values in different rows.

Answer

The supplier data becomes encrypted.

Answer

Every query against the database runs faster.

Answer

The database ends up with fewer tables than before.

Question 5

An analyst at Caldy Foods is asked for a report of every order worth more than 500 pounds. She sorts all orders by value from highest to lowest and takes the top twenty rows. Why is this approach flawed?

Answer

Sorting changes the values in the rows.

Answer

Sorting cannot be done on a money field.

Answer

The number of orders over 500 pounds might be more or fewer than twenty, so the list is either cut short or padded with orders that do not qualify.

Answer

The report needs to be in alphabetical order instead.