Ten workplace situations on data types, primary keys, normalisation, filtering against sorting, choosing a chart, correlation, missing values, averages…
10 questions • Zestly
• Ledbury Cycles has a spreadsheet cell containing the number 428. The owner claims this is data rather than information. Why is this…
• Pennine Outdoors is designing a customer table and must choose the data type for the postcode field. Which type is most appropriate?
• 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…
• Wharfedale Supplies has a table where each product row repeats the full name and address of its supplier. What is the primary benefit of…
• 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…
• Thirlmere Brewing has monthly sales figures for the last twenty-four months and wants to show whether sales are rising or falling over that…
• Selby Leisure finds that in the weeks when its ice cream sales are highest, admissions to its outdoor pool are also highest. What can the…
• At Ravensworth Health, twelve per cent of records have a blank in the age field, and an analyst deletes every row with a blank. What is the…
Want to prepare for an exam — or set one for someone else?
Create your own exam
See the full breakdown →