Assessment 2011 SET08112 Easy

From Progzoo
Jump to: navigation, search

Question 01

Calculate the total weight of all products in tower 1.


[Font] [Default] [Show] [Resize] [History] [Profile]

Question 02

List the locations that are full - where the number of products in the location is more than or equal to the maximum number of products per location.


[Font] [Default] [Show] [Resize] [History] [Profile]

Question 03

List the trays that are full – where all 10 locations on the tray are in use.


[Font] [Default] [Show] [Resize] [History] [Profile]

Question 04

Give a list of all products available in the cluster. Show the product code, the description and the total number available. List only those products that are in the cluster.


[Font] [Default] [Show] [Resize] [History] [Profile]

Question 05

List the available locations for product 40067569. Give the tower, tray and address for all locations containing this item.


[Font] [Default] [Show] [Resize] [History] [Profile]