1.   What does SQL stand for?

21.   The below 3 tables are from a Gym’s database. ‘Member’ table: MemID MName Age Years 10 James Adam 24 5.5 20 Mary Kata 36 25.0 30 Pat Smith 19 10 40 Cathy Good 70 20.3 ‘Class’ table: ClassID ClassName Budget Ind10 Individual $1000 Aero3 Aerobics $2100 Yoga1 Yoga $3000 ‘Attends’ table: MemID ClassID Hours 10 Aero3 20 10 Yoga1 10 20 Aero3 10 20 Ind10 12 40 Aero3 12 40 Ind10 18 40 Yoga1 15   Which of the following would be able to retrieve the names of the gym members that attended either yoga or aerobics classes?

9.   Which is optional in a basic SQL query? Select ALL that apply.

30.   What will the following command return? — len(, (4, 5)]) —

26.   Select ALL that apply regarding Python naming conventions.

Choose one of the questions below and answer it fully using standard English grammar and spelling: What role does forecasting play in the supply chain of a build-to-order server manufacturer such as Dell? What types of industries or situations are best suited to the chase strategy?.The flexible strategy? The level strategy? What is the impact of lack of coordination on the performance of a supply chain?  Give a sample scenario to help explain this impact.    

Provide a basic definition of a supply chain and identify its principal objective.

Choose one of the questions below and answer it fully using standard English grammar and spelling: What are some challenges that limit the effort put in by supply chains to improve sustainability? Which processes within each macro process are best suited to being enabled by IT?  Which are least suited?

Choose one of the questions below and answer it fully using standard English grammar and spelling: A specialty chemical company is considering expanding its operations into Brazil, where five companies dominate the consumption of specialty chemicals. What sort of distribution network should this company use?  Why? What types of distribution networks are typically best suited for commodity items?  Why?  What type of network is best suited to highly differentiated products?  Why?

Choose one of the questions below and answer it fully using standard English grammar and spelling: Why may supply chain profits be hurt by a retailer who makes log-sizing decisions with the sole objective or minimizing its own costs? What would the advantage be if the entire supply chain coordinates this decision? Give an example. Why can a Home Depot, with a few large stores, provide a higher level of product availability with lower inventories than a hardware store chain such as True Value, with many smaller stores? Your friend wants to know about managing demand in a supply chain.  Briefly explain it to him or her and give three specific examples of different strategies (be sure to mention the type of firm you think a specific strategy should be used in and why).