Tag Archives: Promotions

View the Exhibits and examine the structure of the COSTS and PROMOTIONS tables. You want to display PROD_IDS

View the Exhibits and examine the structure of the COSTS and PROMOTIONS tables.You want to display PROD_IDS whose promotion cost is less than the highest cost PROD_ID in a promotion time interval.Examine this SQL statement:Exhibit 1.Exhibit 2.What will be the result? A. It gives an error because the ALL keyword is not valid B. It executes successfully but… Read More »

View the Exhibits and examine the structure of the COSTS and PROMOTIONS tables. You want to display PROD_IDS

View the Exhibits and examine the structure of the COSTS and PROMOTIONS tables.You want to display PROD_IDS whose promotion cost is less than the highest cost PROD_ID in a promotion time interval.Examine this SQL statement:Exhibit 1.Exhibit 2.What will be the result? A. It executes successfully but does not give the required result B. It gives an error because… Read More »

View the Exhibits and examine the structure of the COSTS and PROMOTIONS tables. You want to display PROD_IDS

View the Exhibits and examine the structure of the COSTS and PROMOTIONS tables.You want to display PROD_IDS whose promotion cost is less than the highest cost PROD_ID in a promotion time interval.Examine this SQL statement:Exhibit 1.Exhibit 2.What will be the result? A. It executes successfully but does not give the required result B. It gives an error because… Read More »

View the Exhibits and examine the structure of the COSTS and PROMOTIONS tables. You want to display PROD_IDS

View the Exhibits and examine the structure of the COSTS and PROMOTIONS tables.You want to display PROD_IDS whose promotion cost is less than the highest cost PROD_ID in a promotion time interval.Examine this SQL statement:Exhibit 1.Exhibit 2.What will be the result? A. It gives an error because the ALL keyword is not valid B. It executes successfully and… Read More »

View the Exhibits and examine the structure of the COSTS and PROMOTIONS tables. You want to display PROD_IDS

View the Exhibits and examine the structure of the COSTS and PROMOTIONS tables.You want to display PROD_IDS whose promotion cost is less than the highest cost PROD_ID in a promotion time interval.Examine this SQL statement:Exhibit 1.Exhibit 2.What will be the result? A. It executes successfully and gives the required result B. It gives an error because the ALL… Read More »

View the Exhibits and examine the structure of the COSTS and PROMOTIONS tables. You want to display PROD_IDS

View the Exhibits and examine the structure of the COSTS and PROMOTIONS tables.You want to display PROD_IDS whose promotion cost is less than the highest cost PROD_ID in a promotion time interval.Examine this SQL statement:Exhibit 1.Exhibit 2.What will be the result? A. It gives an error because the GROUP BY clause is not valid B. It gives an… Read More »

Examine the description of the PROMOTIONS table: (Exhibit) You want to display the unique promotion costs

Examine the description of the PROMOTIONS table:You want to display the unique promotion costs in each promotion category.Which two queries can be used? (Choose two.) A. SELECT promo_cost, promo_category FROM promotions ORDER BY 1; B. SELECT promo_category, DISTINCT promo_cost FROM promotions ORDER BY 2; C. SELECT DISTINCT promo_cost || ‘ in ‘ || DISTINCT promo_category FROM promotions ORDER… Read More »

Aaron’s Been Running Shopping Ads For Some Time, And He’s Interested In Experimenting With Ways To Improve Sales Performance By Using Additional Features. Which Benefit Might He Obtain By Using Merchant Promotions?

Aaron’s Been Running Shopping Ads For Some Time, And He’s Interested In Experimenting With Ways To Improve Sales Performance By Using Additional Features. Which Benefit Might He Obtain By Using Merchant Promotions? When he adds promotions to products he sells on Google, shoppers will see a “special offer” link. When he adds promotions to products he sells on… Read More »

Your Company’s Created A Collection Of Two-To-Three Years’ Worth Of Weekly Data For Every Driver Of Sales, Including All Marketing Channels, But Also Across Areas Like Price Promotions, Distribution, And Product Changes. You Can Now Analyze ROI (Return On Investment) For Each Media Channel To Determine The Ones You Should Continue To Invest In. Which Analysis Technique Have You Used?

Your Company’s Created A Collection Of Two-To-Three Years’ Worth Of Weekly Data For Every Driver Of Sales, Including All Marketing Channels, But Also Across Areas Like Price Promotions, Distribution, And Product Changes. You Can Now Analyze ROI (Return On Investment) For Each Media Channel To Determine The Ones You Should Continue To Invest In. Which Analysis Technique Have… Read More »