Which type of PL/SQL statement would you use to increase the price values by 10 percent for items with more than 2,000 in stock and by 20 percent for items with fewer than 500 in stock?
A. A WHILE loop
B. A simple UPDATE statement
C. A simple INSERT loop
D. An IF...THEN...ELSE statement
Answer: D. An IF...THEN...ELSE statement
Computer Science & Information Technology
You might also like to view...
A Google account on an Android device by default will synchronize to which of the following locations?
A. Cloud B. SSD C. PC desktop D. MicroSD
Computer Science & Information Technology
When you click a smooth point with the Anchor Point tool ____.
A. the two attached curved segments become straight segments B. the direction lines are broken C. the Convert Anchor Point tool becomes the Delete Anchor Point tool D. the last selected color fills the point
Computer Science & Information Technology