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
You might also like to view...
Based on the logical data model developed i, create a physical database design for the EasyDrive School of Motoring case study (described in Appendix B.2) based on the DBMS that you have access
What will be an ideal response?
A(n) _____ source operating system allows vendors to use the core source code and gives vendors the ability to customize the operating system
Fill in the blank(s) with correct word
In a pie chart each slice represents a(n) ____________________ of data.
Fill in the blank(s) with the appropriate word(s).
What feature new to Windows Server 2012 provides the ability to find identical sets of data on a SAN based storage array and reduce the identical sets to a single instance, in order to reduce space?
A. Disk pooling B. Data deduplication C. Data multiplexing D. Storage optimizing